How to get the USERID

Doug Batchelor · Sep 17, 2006

I am using the ASP.NET membership stuff and have succesfully implemented it
on my site. However, I would now like to be able to get the UserId which is
stored for registered users in the aspnet_users table in ASPNETDB.MDF. The
reason is that I would like to include this value for users who insert
records in other tables in my database. I thought I could use the LoginName
control to get the Username which I could then use to query the aspnet_users
table, but I can't find a property which will give me the Username in the
control.

I would appreciate any help from the gurus out there.

Ken Cox [Microsoft MVP] · Sep 18, 2006

Hi Doug,

Can you get it from the Profile? If so, here's some code that might get you
going.

Let us know?

Ken
Microsoft MVP [ASP.NET]

<%@ Page Language="VB" %>
<%@ import namespace="System.Data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

Protected Sub Page_Load _
(ByVal sender As Object, _
ByVal e As System.EventArgs)
If Not IsNothing(Profile.UserName) Then
SqlDataSource1.SelectParameters.Item _
("UserName"). _
DefaultValue = Profile.UserName
Else
SqlDataSource1.SelectCommand = ""
End If
End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Get the UserID from ASPNET users database [Ken Cox]</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<p>
<asp:listbox id="ListBox1" runat="server" datasourceid="SqlDataSource1"
datatextfield="Uid"></asp:listbox></p>
<asp:sqldatasource
id="SqlDataSource1"
runat="server"
connectionstring="<%$ ConnectionStrings:ASPNETDBConnectionString %>"
selectcommand="SELECT UserId AS Uid FROM vw_aspnet_Users WHERE (UserName =
@UserName)">
<selectparameters>
<asp

arameter name="UserName" />
</selectparameters>
</asp:sqldatasource>
 </div>
</form>
</body>
</html>

Dominick Baier · Sep 18, 2006

I guess you are talking about the GUID?

You can get that from MembershipUser.ProviderUserKey

how to get user's UserId	1	Oct 14, 2006
How to get education and coding job coming from abroad starting new in the US? Advice of courses or places to look?	2	May 18, 2023
How to get all values of an object	1	Mar 26, 2022
Hello all! Noob here with completely unrealistic ambitions. Happy to join the crew and get good enough to help others.	4	Aug 13, 2024
How to get started with C programming:	1	Aug 7, 2023
Why doesn't the function get called?	1	Nov 20, 2023
I want to simulate social network activity. How to approach the problem?	1	Oct 17, 2022
Passing UserID/PW: Conventions?	19	Aug 31, 2011

How to get the USERID

Doug Batchelor

Ken Cox [Microsoft MVP]

Dominick Baier

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads