dataReader skips first record 1

[kizmar2]

I'm having an issue with a data reader skipping the first returned record. I've double checked the SQL statment and I know it is actually skipping the first record.

I noticed that if I remove the "If dataReader.Read Then..." statement from around my data bind, it works, but then I can't set the label when no records show up.

Here's the code, any help would be appreciated.

Private Function FillHistoryGrid(ByVal studentID)
	' Pulling all history records for this week & this studentID
	sqlQuery = "..."

	' Execute command
	myConnection.Open()
	Dim myCommand As New SqlCommand(sqlQuery, myConnection)
	dataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

	If dataReader.Read Then
		' Bind selected data to the gridview
		Me.gvMealHistory.DataSource = dataReader
		Me.gvMealHistory.DataBind()
	Else
		Me.lblGridMessage.Text = "No records found."
	End If

	' Close connection stuff
	dataReader.Close()
	myConnection.Close()
End Function

KizMar
------------

http://www.maximizetech.com

 

[chrissie1]

You are binding a datareader directly to a datagrid???
That is a new one.

Don't

But if you still want it like this

If dataReader.hasrows Then
        ' Bind selected data to the gridview
        Me.gvMealHistory.DataSource = dataReader
        Me.gvMealHistory.DataBind()
    Else
        Me.lblGridMessage.Text = "No records found."
    End If

Christiaan Baes
Belgium

"My new site" - Me

 

[kizmar2]

I'm a n00b... what object would you suggest binding to the gridview?

KizMar
------------

http://www.maximizetech.com

 

[chrissie1]

a datatable, a dataset, any collection you want and even arrays.

I prefer collections (generic if possible).

Christiaan Baes
Belgium

"My new site" - Me

 

[kizmar2]

BTW "hasrows" is not a valid property of the datareader in VB.NET apparently.

KizMar
------------

http://www.maximizetech.com

 

[chrissie1]

Yes it is.

you did declare it as

dim datareader as sqldatareader

Christiaan Baes
Belgium

"My new site" - Me

 

[kizmar2]

Ahhh... I was declaring it as: "Dim dataReader As System.Data.IDataReader"

If I use "Dim dataReader As SqlDataReader" and "If dataReader.HasRows Then" it fixes my problem.

Like I said, I'm a n00b.

KizMar
------------

http://www.maximizetech.com