Can't Read User.ProviderUserKey

sg48 · May 3rd, 2010, 09:52 AM

Help please. Thank you.

I get this statement in the watch window:
Because this evaluation could cause side effects, it will not be executed until enabled by user.

Membership.GetUser().UserName does show the name of the logged in user

Code:

Session("loggedinusername") = Membership.GetUser().UserName
Dim User As MembershipUser = Membership.GetUser()
Dim UserKey As GUID = User.ProviderUserKey

Imar · May 3rd, 2010, 10:09 AM

Hi there,

GetUser is a method, so the watch window doesn't execute it for you automatically. You have to manually execute / enable it.

Cheers,

Imar

sg48 · May 3rd, 2010, 10:23 AM

When I breakpoint in my code the value UserKey is empty
There is definitely a value in the Membership DB

Imar · May 3rd, 2010, 10:37 AM

But what happens when you manually update the value by clicking the refresh icon in the watch window? I thought that's what you meant with "Because this evaluation could cause side effects, it will not be executed until enabled by user."

Cheers,

Imar

sg48 · May 3rd, 2010, 10:42 AM

The value in the watch window shows as Empty when I click the + sign

I think the watch window is not relevant.

In my code when I manually examine the ProviderUserKey it is empty.

My query that uses it as a parameter is failing because of this.

There is a value in the Membership DB and there is a logged in user

Imar · May 3rd, 2010, 10:55 AM

This is not about the plus sign, but about the Refresh icon near that message you posted. My guess is that the code is OK, but that the Watch window just doesn't execute it.

What happens when you watch:

Membership,GetUser("UserNameOfUserThatIsLoggdIn")

In other words, how can you be sure there is a logged in user?

Imar

sg48 · May 3rd, 2010, 11:09 AM

Because

Session("loggedinusername") = Membership.GetUser().UserName

Shows the name of the logged in user

Imar · May 3rd, 2010, 11:28 AM

Then it has to have a ProviderUserKey as well.

Are you're interpreting the value in the wacth window correctly? Your posts feel a bit crumpy and you're not really supplying a whole lot of information which makes it kind of unattractive to dig into this real deep with you, but my guess is that what you see in the watch window is not what you think you are seeing. Another guess is that entering
Membership.GetUser().ProviderUserKey.ToString() will shed some light on this.

Cheers,

Imar

sg48 · May 3rd, 2010, 11:44 AM

I do appreciate your help.

I put in an instruction to convert the ProviderUserKey to a string as you suggested and it does show a value. My code is failing when I am filling my dataset.

Code:

ProtectedSub InitSessionVariables()
Session("loggedinusername") = Membership.GetUser().UserName
Dim User As MembershipUser = Membership.GetUser()
Dim UserKey As GUID = User.ProviderUserKey
Dim a AsString = Membership.GetUser().ProviderUserKey.ToString()


Dim Conn AsNew SqlConnection(dsDeals.ConnectionString)


'******************************************
Dim dataSet1 AsNew DataSet()
Dim adapter1 As SqlDataAdapter
Dim CmdGetPersonData AsNew SqlCommand("procGetPersonByUserIDSelect", Conn)

CmdGetPersonData.CommandType = Data.CommandType.StoredProcedure
Dim useridparam AsNew SqlParameter("@userid", SqlDbType.UniqueIdentifier)
useridparam.Value = UserKey
Dim PersonID AsInteger
Dim FName AsString
Dim LName AsString
Conn.Open()
adapter1 = New SqlDataAdapter(CmdGetPersonData)
Try
adapter1.Fill(dataSet1)

My stored procedure is shown below

Code:


ALTER PROCEDURE dbo.procGetPersonByUserIDSelect
(
@userid UniqueIdentifier 

)
AS
SELECT PersonID, FName, LName
FROM tblPerson WHERE userid=@userid
RETURN

sg48 · May 3rd, 2010, 11:55 AM

I removed my tRy Catch and am getting following error now

Procedure or function 'procGetPersonByUserIDSelect' expects parameter '@userid', which was not supplied.