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 ; } HierarchySystem.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 BySqlCommandBuilder.DataAdapter Passed ToSqlCommandBuilder.{DataAdapter , SqlCommandBuilder( )} |