Can't Read User.ProviderUserKey

sg48 · May 3rd, 2010, 12:01 PM

I forgot to add the parameter.

CmdGetPersonData.Parameters.Add(useridparam)

Thank you for your response. It was helpful in getting me to the root of the problem.

Imar · May 3rd, 2010, 12:04 PM

So, this doesn't have much to do with the ProviderUserKey, but with the rest of your code? That, once again, proves the importance of providing detailed explanations of the code and problem, backed up with relevant snippets as you did in your last post.

Code:

Dim useridparam As New SqlParameter("@userid", SqlDbType.UniqueIdentifier)
useridparam.Value = UserKey

An excellent SqlParameter you have here. And what a pity you completely forget about it after you create it. In other words, you're never adding it to the Parameters collection of the SqlCommand object.

Hope this helps,

Imar

sg48 · May 3rd, 2010, 12:23 PM

Yes you are correct. I got fooled by the watch window in the beginning.

Also, my Try Catch masked the problem.

The reason I didn't put in all of my code in the beginning was that I didn't want to clutter the post with stuff I thought wasn't relevant. A few lessons here: 1 A person doesn't know what they don't know. 2. Do more debugging before posting.

In any case, you were very helpful. Thank you. Steve

Imar · May 3rd, 2010, 12:25 PM

And 3) Don't be crumpy..... ;-)

Glad you got it sored out.

Cheers,

Imar

gbianchi · May 3rd, 2010, 12:36 PM

You are never passing the parameter you create to the command object.. Did you realize that???