Data access using ADO.Net has the following steps:
1)Defining the connection string for the database server.
2)Defining the connection (SqlConnection, OleDbConnection, etc) to the database using the connection string.
3)Defining the command (SqlCommand, OleDbCommand, etc) or command string that contains the query .
4)Defining the data adapter (SqlDataAdapter, OleDbDataAdapter, etc) using the command string and the connection object.
5)Creating a new DataSet object.
6)If the command is SELECT, filling the dataset object with the result of the query through the data adapter
7)Reading the records from the DataTables in the datasets using the DataRow and DataColumn objects.
8)If the command is UPDATE, INSERT or DELETE, then updating the dataset through the data adapter.
9)Accepting to save the changes in the dataset to the database.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|