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); // overrides System.Data.Common.DbDataAdapter
   protected override void Dispose( bool disposing);// overrides System.Data.Common.DbDataAdapter
   protected override void OnRowUpdated( System.Data.Common.RowUpdatedEventArgs value);                      
// overrides System.Data.Common.DbDataAdapter
   protected override void OnRowUpdating(System.Data.Common.RowUpdatingEventArgs value);                      
// overrides System.Data.Common.DbDataAdapter
// Events
   public event SqlRowUpdatedEventHandler RowUpdated; 
   public event SqlRowUpdatingEventHandler RowUpdating; 
}

Hierarchy

System.Object System.MarshalByRefObject System.ComponentModel.Component(System.ComponentModel.IComponent, System.IDisposable) System.Data.Common.DataAdapter(System.Data.IDataAdapter) System.Data.Common.DbDataAdapter(System.ICloneable) SqlDataAdapter(System.Data.IDbDataAdapter)

Returned By

SqlCommandBuilder.DataAdapter

Passed To

SqlCommandBuilder.{DataAdapter , SqlCommandBuilder( )}