Terry,
In addition to Earl and Bennie.
A Dataset is an object that holds datatables. You can compare Datatables
with recordset, although the major difference is that datasets/datatables
are disconnected and a recordset stays connected to the database.
To go through a datatable as with a movenext from a recordset can be.
dim mytable as datatable = ds.tables(0) ' you can do it with the dataset
direct as well
dim mydatarow as datarow1 = mydatatable.rows(0) ' which is the first row it
it extist
did mydatarow as datarow2 = mydatatable.rows(1) ' which is the second row if
it exist
(In a lot of cases is the currencymanager used, that has nothing to do with
money however with the current position in the datatable)
Both the datareader and datasets are good to use.
When you use it in connection with a "data" control as the datatagrid,
combobox, and listbox or with a "single item" control as the textbox,
checkbox, label or whatever, than the dataset/datatable is in my opinion
the best choise.
When you use it with a control as a treeview or a listview that has to be
loaded in advance, the datareader is in my opinion a better choise.
I hope this gives some more ideas?
Cor
"Terry Maguire"
te*******@verizon.net
I am an old VB6 programmer, and we have recently gone to VB.NET. I am
struggling to duplicate some of the things I had done in VB5 and VB6 to the
new language.
What I need to do is to use VB.NET code to :
#1: Open an MS Access database
#2: Retrieve the data from one of the tables into an array
#3: Once I have the array filled, I can process the data in the array via
VB.NET code
If my DB is ddddd and my table within the DB is ttttt, what code do I need
to open the database and read each member from the table sequentially until
the end of the table?
Thanks for answering.