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?

 

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