How to ADO.net using ASP.NET ?

ADO.net Architecture:

ADO.Net provides a bridge between the front end controls and the back end database. 

Following figure show ADO.net objects at detected.Following are namespace provided by .Net for data management.System.Data, System.Data.oleDB, System.Data.Sqlclient,System.XML.

ADO.net architecture are divided into two part:

1) Connected class.

2) Disconnected class.

1) Connected class:-ADO.net architecture show four main section of Data provider.
Data provider provides access to data source -> SQL server.
                                                                      ->Access.
                                                                      -> ORACLE.
In short it providers object to achieve functionalists like ->Opening & Closing connection,
                                                                                      -> retrieve data,
                                                                                      ->update data.

• connection: It's provided connection between data-set and asp.net.
• command object: This object to used stored procedures.
• Data Adapter: This object act as bridge between data store and dataset.
• Data reader: This object reads data from data store in forward only mode.

2) Disconnected class:- Dataset object represented disconnected and catch data.if you see diagram, it is not in direct connection with data store ,rather it talks with data adapter, who is responsible for filling the dataset.

dataset can have one or more Data table and relations. 

Example: