When I try to use i =da.Getint32("MemberID") I get i = -1
Memberid column in SQL Table is data type Int.

I get i = -1 whether I use da.GetValue("MemberID") or
da.item("MemberID") or da.Getint16("MemberID") or da.Getint64("MemberID").

Code I am using:


Dim da As SqlDataReader

            myConn.Open()

            da = selectCmd.ExecuteReader(CommandBehavior.SingleRow)
            da.Read()

            i = da.GetInt16("Memberid")
            Return i
            da.Close()
            myConn.Close()


What is wrong??

This from the VS help:
[Visual Basic]
Public Overridable Function GetInt64( _
   ByVal i As Integer _
) As Long Implements IDataRecord.GetInt64

The GetInt## function requires an integer as a parmeter, not a column name

That should work then

jbenson001

I see what you are saying about GetInt64.
When I put s= da.Item("Name") this fetches the string that is contained in "Name" column.
How do you get the integer in "MemberID" column using data adapter in this situation??


Dim da As SqlDataReader

            myConn.Open()

            da = selectCmd.ExecuteReader(CommandBehavior.SingleRow)
            da.Read()

            i = da.GetInt16("Memberid")
            Return i
            da.Close()
            myConn.Close()

Did you try:

CType(da.Item("MemberID"), Integer)

The Get functions seem to only take the index number.

Brian

bmains

I tried your suggestion:

Try

            Dim da As SqlDataReader

            myConn.Open()

            da = selectCmd.ExecuteReader(CommandBehavior.SingleRow)
            da.Read()
            i = CType(da.Item("MemberID"), Integer)

            Return i
            da.Close()
            myConn.Close()

        Catch ex As Exception

            Return i = 0

        End Try


I still get -1. What does -1 mean? Does it mean i didn't return anything cuz I set the exception to 0 when it failed?

Please help me

Probably... verify the query.