Saturday, 27 April 2013

List all the steps in order, to access a database through ADO.NET? | ASP.Net interview questions

=> 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.

No comments: