SqlDataAdapter marshal by reference, disposable

SqlDataAdapter

marshal by reference, disposable

---

System.Data.SqlClient (system.data.dll)

sealed class

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( )}