Solved

Visual Studio 2005 VB.Net Variable Values Showing in Hex

Posted on 2009-05-06
3
234 Views
Last Modified: 2013-11-26
I developing a windows project in visual studio 2005.  I noticed some code is not getting the right results.  In the following code sample,  If Not IsNothing(ID) Then, is always true.  I checked the Value of ID and it was &H0.

How can I fix this?  Thanks in advance
Public Sub Login(ByVal UserName As String, ByVal Password As String, ByVal RememberMe As Boolean)

        Dim ID As Integer

        ID = clsDatabase.GetReaderSingleValue("SELECT ID FROM tblUsers WHERE Username = '" & UserName & "' AND Password = '" & Password & "'", CommandType.Text)

        If Not IsNothing(ID) Then

            GetUserByID(ID)

            Authenticated = True

        End If

    End Sub

Open in new window

0
Comment
Question by:moraleskp
  • 2
3 Comments
 
LVL 15

Expert Comment

by:JackOfPH
ID: 24321490
Try this approach:




Public Sub Login(ByVal UserName As String, ByVal Password As String, ByVal RememberMe As Boolean)

        Dim ID As Integer

        ID = clsDatabase.GetReaderSingleValue("SELECT ID FROM tblUsers WHERE Username = '" & UserName & "' AND Password = '" & Password & "'", CommandType.Text)

        If Not ID is noting Then

            GetUserByID(ID)

            Authenticated = True

        End If

    End Sub

Open in new window

0
 
LVL 15

Expert Comment

by:JackOfPH
ID: 24321497
opps, typing error, It should be ...

If Not ID is nothing Then

so the code should be like this



Public Sub Login(ByVal UserName As String, ByVal Password As String, ByVal RememberMe As Boolean)

        Dim ID As Integer

        ID = clsDatabase.GetReaderSingleValue("SELECT ID FROM tblUsers WHERE Username = '" & UserName & "' AND Password = '" & Password & "'", CommandType.Text)

        If Not ID is nothing Then

            GetUserByID(ID)

            Authenticated = True

        End If

    End Sub

Open in new window

0
 

Accepted Solution

by:
moraleskp earned 0 total points
ID: 24321927
thanks for the reply jack.
The clsDatabase procedure was returning nothing with converted to 0 in ID.  I changed the datatype of ID to nullable (of integer)  and the if worked.  The hex values was because the hexadecimal display button was depressed.  until a few minuets ago, I did not know about this.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now