Cannot read SqlDataReader Object

Question

Trying to get response from my azure db I am using the recommended microsoft snippet

Dim sb As StringBuilder = New StringBuilder()
sb.Append("select top 1 runname from vNameCode")
'sb.Append("where untgscod = ")
Dim sql As String = sb.ToString()
Using command As SqlCommand = New SqlCommand(sql, connection)
    Using reader As SqlDataReader = command.ExecuteReader()
        While reader.Read()
            Console.WriteLine("{0} {1}", reader.GetString(0), reader.GetString(1))
        End While

but as soon as I try to read the values I get the error:

System.IndexOutOfRangeException: 'Index was outside the bounds of the array.'

I get an object back but just cannot read it in the recommended way. Any ideas what I am doing wrong?

djv · Accepted Answer · 2019-11-27 15:48:56Z

1

Since you are getting runname from the table vNameCode but you are trying to access two values from the reader.

Do either of one changes:

Include the corresponding values in the SELECT statement.
Remove reader.GetString() from the Console.WriteLine

Try Below

Dim sb As StringBuilder = New StringBuilder()
sb.Append("select top 1 runname from vNameCode")     
Dim sql As String = sb.ToString()
Using command As SqlCommand = New SqlCommand(sql, connection)
    Using reader As SqlDataReader = command.ExecuteReader()
        While reader.Read()
            Console.WriteLine("{0}", reader.GetString(0))
        End While
    End Using
End Using

edited Nov 27, 2019 at 15:48

djv

15.8k7 gold badges53 silver badges81 bronze badges

answered Nov 27, 2019 at 11:29

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot read SqlDataReader Object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related