Which Method to Connect Database?

[soodvarun]

Dear friends,

I am using Access as backend database. I am using OLE DB provider for .Net.

Heard there are two ways of connecting to Database. One is using DATASET other is by DATA READER.

I dont' know which is a better one and how to use them....

I will be very thankful for the suggestions.

Varun Sood.

http://www.foxysolutions.com

 

[chrissie1]

Depends on what you need to do.

the datareader is faster but only lets you go forward in the set of records.

the dataset is slower but you can move anyway you want in the rowscollection.



Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting