Fundamental object in Ado.Net

DataReader - It is basically used in the Connected Environment. For example... If you want to select some data from the database, then you can just run your procedure or your query through the command object and can use the DataReader oBJECT to read the values fetched through the query and display or use it in the further process.... For this the Connection with the Data Source is compulsary. You cannot use this object in the disconnected environment.

Dataset - It is basically used in the disconnected environment. You just fetch the data from the Datasource using a DataAdapted and fill the Dataset using the Fill() method of the Adapter Object. The Dataset can store multiple content in tabular format. Once you fetch the values from the Datasource in the Adapter and fill the Dataset, you can use the Dataset even if the connection with the DataSource is closed.

In ADO.NET, some other Objects like Connection Object, Command Object, Data Adapters, Data Tables, etc also are the most vital objects. Atleast you always need to use the Connection Object for connecting with the database.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Hi Sharad,

Please refer the below links

http://www.codeproject.com/Articles/8477/Using-ADO-NET-for-beginners

http://www.csharp-station.com/Tutorial/AdoDotNet/lesson01

http://www.functionx.com/adonet/index.htm

Thanks
If this post helps you mark it as answer
Shivanand Arur14y ago
DataReader - It is basically used in the Connected Environment. For example... If you want to select some data from the database, then you can just run your procedure or your query through the command object and can use the DataReader oBJECT to read the values fetched through the query and display or use it in the further process.... For this the Connection with the Data Source is compulsary. You cannot use this object in the disconnected environment.

Dataset - It is basically used in the disconnected environment. You just fetch the data from the Datasource using a DataAdapted and fill the Dataset using the Fill() method of the Adapter Object. The Dataset can store multiple content in tabular format. Once you fetch the values from the Datasource in the Adapter and fill the Dataset, you can use the Dataset even if the connection with the DataSource is closed.

In ADO.NET, some other Objects like Connection Object, Command Object, Data Adapters, Data Tables, etc also are the most vital objects. Atleast you always need to use the Connection Object for connecting with the database.