Hi

I have a data adapter bound to a table. How can I loop through the table via
and access each record's column values on the way?

Thanks

Regards

What kind of table are you binding to? If it is a standard .NET control,
everyone I know has a Data bind method of some sort where you can query
values as the form is loaded.

Show quoteHide quote

A "data adapter" can't really be bound to anything. You can bind to the
DataSet populated by a DataAdapter or bind to the underlying DataTables.
The DataTable object can be addressed by iterating through the Rows
collection as in

    For each dr as DataRow in myDataSet.Tables("MyTableName").Rows

    Next
The individual columns are referenced through the DataRow Item "property"
which can be addressed by name or ordinal (number).

I suggest picking up any one of the dozens of books on ADO.NET. Even my
(relatively old) ADO and ADO.NET Examples and Best Practices discusses these
basics.

hth

Show quoteHide quote

John,

Do you read replies to these newsgroups?

http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/msg/df51c13d3e6742c1

Now Bill is using time to write in another way the same as I did.

Cor


Show quoteHide quote

Timer driving me nuts
OK, new registry question
Tree List View
ToolStrip Border
validating textbox
Listview - get value multiple columns
Delete files in use
Jet error message when trying to create a DS from Excel
modular programming???
Confusion on nothing