Datagrid Question

[spencem5]

Here's what I had...

sqlcon.Open()
Dim drManagers As SqlDataReader = cmdGetManagers.ExecuteReader
While drManagers.Read
dgrid_ViewAllUsers.DataSource = drManagers
dgrid_ViewAllUsers.DataBind()
End While
drManagers.Close()
sqlcon.Close()

sqlcon is my connection string and cmdGetManagers is my SQL Command. I'm trying to figure out why the first line in my datagrid is left out. The datagrid looks fine just that first row is showing up. The first row in my datagrid is actually the second row in my table. Any help would be much appreciated.

Thanks,
M

[dj4uk]

You don't need to do a while drManagers.Read the databinding will handle that.

Try:

sqlcon.Open()
Dim drManagers As SqlDataReader = cmdGetManagers.ExecuteReader
dgrid_ViewAllUsers.DataSource = drManagers
dgrid_ViewAllUsers.DataBind()
drManagers.Close()
sqlcon.Close()

Calling drManagers.Read actually moves to the next record in the DataReader hence the missing first record.

HTH

DJ

[spencem5]

Thanks for the feedback...
That was the problem that was screwing me up. Haven't been programming for a few years and holy cow am I rusty. Thanks again for the help.