Newbie question : looping through records...

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Hi all,

I'm learning VB.net and have a question..

I'm trying database access at the moment, and so far have managed to create
and fill a dataadapter. I can then bind that to a windows control ok and
see/naviagte the records.

Question is: How do I navigate through the datadapter in code? eg loop
through each row to store a record into an array.

Thanks!
 
Nick said:
Hi all,

I'm learning VB.net and have a question..

I'm trying database access at the moment, and so far have managed to
create and fill a dataadapter. I can then bind that to a windows control
ok and see/naviagte the records.

Question is: How do I navigate through the datadapter in code? eg loop
through each row to store a record into an array.

Thanks!
Click to expand...

best way to read records is by using the DataReader object - it will allow
you forward only read only (faster)
 
Back
Top