DataReader Not returning rows

[traceytr]

Hello.
I'm pretty new to VB.NET, and I'm trying to get my .NET code to execute a SQL Server stored procedure and return the recordset. The stored procedure is executing, but no rows are returned into the DataReader as indicated by my message box. Can anyone tell me what I'm missing? Thanks.

Tracey

'Connection - Declare and open connection        
Dim myConnectionString As String = "Integrated Security=XXXX;Persist Security Info=False;Initial Catalog=DataBaseName;Data Source=ServerName;Packet Size=XXXX"
Dim myConnection As SqlConnection = New SqlConnection(myConnectionString)
myConnection.Open()

'Command
Dim mySqlCommand As SqlCommand = New SqlCommand("sp_myStoredProcedure", myConnection)

'DataReader - Declare DataReader and populate with result set from stored procedure.
Dim myReader As SqlDataReader = mySqlCommand.ExecuteReader()

Try
    'If myReader.HasRows Then
    If myReader.Read <> False Then
       Do While myReader.Read()
           MsgBox("Rows Returned.", MsgBoxStyle.Information)
        Loop
    Else
        MsgBox("No rows returned.", MsgBoxStyle.Information)
    End If

Finally
    myReader.Close()
    myConnection.Close()
End Try

 

[vonehle]

I'm pretty new to this too, but I think your problem is that the myReader.read() comes after the .HasRows. It will always not have rows before the read starts.

 

[traceytr]

Thank you, Vonehle, for responding -- I appreciate it. I didn't get a chance to try your suggestion, but at the very moment I was reading it the light came on, and I realized why no rows were returned. The stored procedure was executing when I ran the code, but not returning any rows... Basically the stored procedure truncates a data table and then loads it with current data. This was working, so for the life of me I couldn't figure out why the rows weren't being returned. Well, as it turns out the stored procedure loaded the table, but I did not write a select statement to select the new rows. Here I thought it was because I was new to .NET, and all the while it was because I didn't ask for the records in the first place. I totally overlooked the obvious.

 

[vonehle]

Good for you, because I was wrong anyway. Lucky for me, your code tipped me off on how to fix something I was working on. So, thank you!