C# DataReader simple question

[EFileTahi-A]

Please ppl, tell me...

 

Is OleDbDataReader the only way to retrieve values from the rows???

 

I Wish there was a way to retrieve info from rows like I use to do in VB6 recordsets. So that I could retrieve columns names, rows values, moving forward and backward on the records, and have a recordset per table to make relationships between them.

[Diesel]

You can use a DataAdapter and load the whole table into a DataSet (or Database for that matter).

[EFileTahi-A]

You can use a DataAdapter and load the whole table into a DataSet (or Database for that matter).

 

ok I found the way of retrieving the rows values, unfortunately I have to select the rows by numbers. Is there a way to select a row column for his name?

Edited December 17, 2004 by EFileTahi-A

[EFileTahi-A]

Ok, I found the way!

myDataTable.Rows[x]["ColumnName"].ToString()

 

- THREAD RESOLVED -

[Diesel]

Look up typed Datasets, it will save you a lot of hassle.