Specified cast is not valid when reading a Float column

Well I am stuck... again. Everything was sailing smooth until now. I am reading some data from the DB (something usual) but its giving me the specified cast is not valid error. Its not the first time I've dealt with this error; earlier on I had it with a date column. Anyway, I have a table that I need to read. Its data type is FLOAT. so this is the code I am using:

Dim rdr = sqlCmd.ExecuteReader
While rdr.Read
    theResults.Add(New UserData With {
        .BalAvailable = rdr.GetFloat(0),
        .branch = rdr.GetInt32(1)
End While

This is running under a function; this is the Class...

Class UserData
    Dim theResults = New List(Of UserData)

    Property Branch As Integer
    Property BalAvailable As Single

End Class

And this is the input part...

Dim clientNo As Integer = 0
Dim myResults = GetData(clientNo)
If Integer.TryParse(txtInput.Text, clientNo) Then
    If myResults.Count = 1 Then
        txtBalAvail.Text = CInt(myResults(0).BalAvail)

Everytime I input a value it gives me the specified cast is not valid error.

System.Data.SqlClient.SqlBuffer.get_Int32() +5270501
System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i) +62

I believe this could be related to the statements I use?

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

I am stuck. I also tried changing the rdr.GetFloat to Double, and in Integer.TryParse to Double.TryParse. I am so stuck!


The strongly-typed Get... methods (GetFloat, GetInt32, etc.) will only work if the data-type of the field is an exact match.

Use the GetFieldType method to examine the real data-type of the field, and either use the appropriate strongly-typed Get... method, or the untyped GetValue method.

Need Your Help

(Unsuccessfully) testing the effects of indexes in Oracle SQL

sql database oracle database-design

I am learning about all things SQL, and upon reading about indexes I naturally wanted to create a simple adhoc test to see how indexes REALLY affect performance (rather than just taking the reading...

jPlayer can't get played in IE8.

javascript jquery angularjs angularjs-directive jplayer

I have a problem with jPplayer in IE8. I'm working on an application which should support IE8. It works in every other version >8 of IE and plays on chrome and firefox. I googled it with multiple