ASP.NET

ASP.NET RSS

i got the (User.identity.name) blues :(

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: May 2008

Posts: 34

Reputation: ricksvoid is an unknown quantity at this point

Solved Threads: 0

ricksvoid

Offline

Light Poster

i got the (User.identity.name) blues :(

Sep 3rd, 2009

What I want to do is get a users current login username, and pass it to an SQL query which will search a table and return all entries belonging to that person. Ive managed to pass the username onto a label when that person logs in.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim theUser = User.Identity.Name
        greeting.Text = "hello " & theUser.ToString()
    End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim theUser = User.Identity.Name
        greeting.Text = "hello " & theUser.ToString()
    End Sub

I would like to take this a step further by allowing for a pageload event that automaticly querries a table and binds that information unto a datagrid. BTW... I am familiar with the sytax and logic involved with binding a set of records unto a datagrid control. What i am lacking is the knowlege to allow only information that pertains to the logged in user.

Please help,
Rick Pace

•

Join Date: Feb 2009

Posts: 3,283

Reputation: sknake has much to be proud of

Solved Threads: 584

sknake

Offline

.NET Enthusiast

Re: i got the (User.identity.name) blues :(

Sep 3rd, 2009

 Help with Code Tags 
 vb.net Syntax (Toggle Plain Text) 
Dim query As String = "Select * From someTable Where UserName = '" & theUser.ToString() & "'"
Dim query As String = "Select * From someTable Where UserName = '" & theUser.ToString() & "'"