List All The Steps In Order, To Access A Database Through Ado.net?

1.	List All The Steps In Order, To Access A Database Through Ado.net?
Answer» Create a connection to the database using a connection object. Invoke a command to create a DataSet object using an adapter object. Use the DataSet object in code to display DATA or to CHANGE items in the database. Invoke a command to UPDATE the database from the DataSet object using an adapter object. Close the database connection if you explicitly opened it in step 2 using the Open method. Invoking commands without FIRST invoking the Open method implicitly opens and closes the connection with each request.

Answer»

Create a connection to the database using a connection object.
Invoke a command to create a DataSet object using an adapter object.
Use the DataSet object in code to display DATA or to CHANGE items in the database.
Invoke a command to UPDATE the database from the DataSet object using an adapter object.
Close the database connection if you explicitly opened it in step 2 using the Open method. Invoking commands without FIRST invoking the Open method implicitly opens and closes the connection with each request.

Discussion