Datagrid Question

[spencem5]

One quick question... datagrids.
I have my output looking the way I want and it now prints to the datagrid fine but my datagrid isn't listing first entry, starts with the second. It's like the first row isn't being read but the rest print fine. Did I forget something?

Thanks a ton,
M

[mendhak]

Show us the datagrid's code and the codebehind for your datagrid's binding.

[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.