SQLDataReader not reading using VB.net

Question

I am using a SQLDataReader to display the results of my stored procedure, however, I have been unable to have it display any records. I am not generating an error and if I write out reader.hasrows.tostring() it returns true so I know it is returning a single row as intended. I know I have data in all columns to display. Any guidance would be appreciated.

        Dim sqlcon2 As SqlConnection = New SqlConnection(Session("ConnStrEP"))
        sqlcon2.Open()

        Dim sqlcomm2 As SqlCommand = New SqlCommand("up_GetGenInfo_E1_01_02", sqlcon2)
        sqlcomm2.CommandType = Data.CommandType.StoredProcedure
        sqlcomm2.Parameters.Add("AppNo", AppNo)
        sqlcomm2.Parameters.Add("RevNo", RevNo)
        Dim dt As SqlDataReader = sqlcomm2.ExecuteReader()
        dt.Read()

        Response.Write(dt.Item("PrName").ToString())


        dt.Close()
        sqlcomm2.Dispose()
        sqlcon2.Close()

skuntsel · Accepted Answer · 2013-04-29 18:27:28Z

2

Do it in a following way:

 Do While dt.Read()
    Response.Write(dt.Item("PrName").ToString())
 Loop

edited Apr 29, 2013 at 18:27

skuntsel

11.8k11 gold badges49 silver badges68 bronze badges

answered Apr 29, 2013 at 18:09

Shafqat Masood

2,5601 gold badge19 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

SQLDataReader not reading using VB.net

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