System.IndexOutOfRangeException

[mfriedenthal]

I have a VB.net app that stores data on SQL. I added a new field called "Status" to one of the SQL tables, of type bit, and created stored procedures to retrieve and edit the new field.

 

Everything works perfectly when the app is compiled in Debug mode.

 

However, when it is compiled in Release mode I get the following error:

 

System.IndexOutOfRangeException: Status

 

The code is executed OnLoad:

 

Try
           MyAppConnection.Open()
           MyAppSQLCommand.Connection = MyAppConnection
           drResults = MyAppSQLCommand.ExecuteReader
           While drResults.Read
               If drResults("Status") Then
                   Status = "Active"
               Else
                   Status = "Not Active"
               End If
               liIndex = New ListItem(drResults("Name").ToString() & " - " & Status, drResults("I_ID").ToString)
               ddlInspectors().Items.Add(liIndex)
           End While
           drResults.Close()
       Catch ex As Exception
           RecordError(ex.ToString)
       Finally...

 

The stack looks like:

 

System.IndexOutOfRangeException: Status

at System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName)

at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)

at System.Data.SqlClient.SqlDataReader.get_Item(String name)

at MyApp.Utilities.MyMethod()

 

Can anyone suggest a solution, or at least, how to go about tracking down the source of the error?

 

Thank you.

[Nerseus]

You can set a breakpoint at the top to step through and see which line has the problem. It's likely the following line, since you mentioned adding the Status column to the query:

   If drResults("Status") Then

 

The error line "System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName)" is saying that it's trying to find a column by name and can't find it. That means the code certainly thinks a column isn't there. I'd check that you really are getting back the Status column (run the query directly through whatever tool you use).

 

-ner

[mfriedenthal]

Thanks, Nerseus. I found my problem.