Read row on Access database

[Anthoni]

Dear All,
I need to read data (specific column from specific row from specific
table) on Access database.
Since it need to b read numerous number of times, I want to connect
the database and load the desired columns outside the loop, and use
filter critiria inside the loop in order to hunt the desired data.

How I implement it on C#?
I made a connection with OleDbConnection
Then made OleDbCommand and use the OleDbDataReader, the problem is
when I try to load() the OleDbDataReader to DataTable object it not
seems to work (I used the ExecuteReader() to init the reader).
What is the right tactics to do it?
Thanks in advanced,

[sloan]

If you need to requery data, withOUT re talking to the database, you probaby
want to choose a DataSet object.

LoadDataSet is the method of interest.

After you get a generic (untyped) dataset working , you probaby want to
upgrade to a "strongly typed dataset".

Google typed dataset for some more info.


"Anthoni" <de*********@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...

Dear All,
I need to read data (specific column from specific row from specific
table) on Access database.
Since it need to b read numerous number of times, I want to connect
the database and load the desired columns outside the loop, and use
filter critiria inside the loop in order to hunt the desired data.

How I implement it on C#?
I made a connection with OleDbConnection
Then made OleDbCommand and use the OleDbDataReader, the problem is
when I try to load() the OleDbDataReader to DataTable object it not
seems to work (I used the ExecuteReader() to init the reader).
What is the right tactics to do it?
Thanks in advanced,