ADO.NET in a Nutshell

Name

SqlDataAdapter

Synopsis

This class represents a data adapter that can retrieve information from a SQL Server database to a System.Data.DataSet and update that database with changes made to the DataSet. For information about the basic SqlDataAdapter methods and properties, refer to the reference for the System.Data.IDbDataAdapter and System.Data.IDataAdapter interfaces, which SqlDataAdapter implements.

public sealed class SqlDataAdapter : System.Data.Common.DbDataAdapter, System.Data.IDbDataAdapter {

// Public Constructors

   public SqlDataAdapter( );  

   public SqlDataAdapter(SqlCommand selectCommand);  

   public SqlDataAdapter(string selectCommandText, SqlConnection selectConnection);

   public SqlDataAdapter(string selectCommandText,  string selectConnectionString);

// Public Instance Properties

   public SqlCommand DeleteCommand{set; get; } 

   public SqlCommand InsertCommand{set; get; } 

   public SqlCommand SelectCommand{set; get; } 

   public SqlCommand UpdateCommand{set; get; } 

// Protected Instance Methods

   protected override RowUpdatedEventArgs CreateRowUpdatedEvent(System.Data.DataRow dataRow,

        System.Data.IDbCommand command, System.Data.StatementType statementType,

        System.Data.Common.DataTableMapping tableMapping);// overrides System.Data.Common.DbDataAdapter

   protected override RowUpdatingEventArgs CreateRowUpdatingEvent(System.Data.DataRow dataRow,

        System.Data.  DataRow dataRow, System.Data.IDbCommand command, System.Data.StatementType statementType, 

        System.Data.Common.DataTableMapping tableMapping ...