Code Help - General Discussion

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

4/13/2007 4:29 PM

lmeljalb

Joined: 4/9/2007

Posts: 11

Code Help

I am working in the old IBS Portal Starter Kit. However, I am having problems with my vb code and I'm hoping there is a VB guru out here to help. I am using the following code to try and get obtain the UserId from a database...

Dim users2 As New

UsersDB

Dim dr As

SqlDataReader = users2.GetSingleUser(Email.Text)

dr.Read()

userId =

CStr

(dr("UserID"))

dr.Close()

Message.Text = userId

And I am getting this...

UserID

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: UserID

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


            [IndexOutOfRangeException: UserID]
   System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) +55
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +69
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +10
   ASPNET.StarterKit.Portal.ForgottenPassword.SendPasswordBtn_Click(Object sender, EventArgs E) +136
   System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
   System.Web.UI.Page.ProcessRequestMain() +1292

Now, the strange thing is...I can use that same code and pull out the Name, Password, and Email address. But, as soon as I try and get out the userID, it errors. Please help!!!

Page 1 of 1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

UserID

DNN Corp. (DotNetNuke)