Newbie question : looping through records...

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

 

[James Jenkins]

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!

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