Next row in database

  • Thread starter Thread starter David Whitehouse
  • Start date Start date
D

David Whitehouse

I've used an SQL staement to pull a table from my database using the
DataReader. ie SELECT * FROM Table. However i cannot get off the first row
of the table. Is there a DataReader.Next() statement or something that can
force the datareader to jump to the next row?
-David
 
Hi,

yes, you use MyDataReader.Read() to do this. It returns false if there is no
next row. Also, .NET v1.1 has a nice new feature in MyDataReader.HasRows
that helps you to see if the result set has rows or not. .Next() is for
getting the next result set from the same reader in case there is one.

Best regards,

Marc Hoeppner
NeoGeo
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datareader vs Tableadaptor question 1
sqlDataReader skipping first row in loop 3
Access to Rows in a datagrid 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
dropdownlist size limit? 5
Gridview displays old data 2
creating the html from a business object? 1
Iterating through specific rows of DataReader... 8

Back
Top