[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Visual Studio 2005 VB.Net Variable Values Showing in Hex

Posted on 2009-05-06
3
Medium Priority
?
264 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
I'd like to talk about something that is near and dear to my heart: build systems. Without them, building software is all about compiling locally, with software versions everywhere. It can be a mess. Today we are going to discuss building a small di…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

649 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