Fundamental object in Ado.Net

Question

What are the fundamental object in Ado.net.

Satyapriya Nayak · Answer

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 Arur · Answer

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.