Check out and contribute to CodePedia, the wiki for developers.
*/

Other Views

corner
*/

ADONET FAQ - Steps Involved in Data Access in Disconnected Environment

What are the basic steps involved in data access with ADO.Net in disconnected environment?

Data access using ADO.Net involves the following steps:

  • Defining the connection string for the database server
  • Defining the connection (SqlConnection, OleDbConnection, etc) to the database using the connection string
  • Defining the command (SqlCommand, OleDbCommand, etc) or command string that contains the query
  • Defining the data adapter (SqlDataAdapter, OleDbDataAdapter, etc) using the command string and the connection object
  • Creating a new DataSet object
  • If the command is SELECT, filling the dataset object with the result of the query through the data adapter
  • Reading the records from the DataTables in the datasets using the DataRow and DataColumn objects
  • If the command is UPDATE, INSERT or DELETE, then updating the dataset through the data adapter
  • Accepting to save the changes in the dataset to the database
Back
corner
© 1996-2008 CommunityHeaven LLC. All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
North American business development: Nicolai Wadstrom. Publisher: Lars Hagelin.
Resource Listings