System.Data.SqlClient.SqlDataAdapter

SqlDataAdapter

public sealed class SqlDataAdapter : DbDataAdapter, IDataAdapter, IDbDataAdapter, ICloneable

Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited.

public SqlCommand DeleteCommand { get; set; }

Gets or sets a Transact-SQL statement or stored procedure to delete records from the data set.

public SqlCommand InsertCommand { get; set; }

Gets or sets a Transact-SQL statement or stored procedure to insert new records into the data source.

public SqlCommand SelectCommand { get; set; }

Gets or sets a Transact-SQL statement or stored procedure used to select records in the data source.

public SqlCommand UpdateCommand { get; set; }

Gets or sets a Transact-SQL statement or stored procedure used to update records in the data source.

public event SqlRowUpdatedEventHandler RowUpdated

Occurs during Update after a command is executed against the data source. The attempt to update is made, so the event fires.

public event SqlRowUpdatingEventHandler RowUpdating

Occurs during Update before a command is executed against the data source. The attempt to update is made, so the event fires.

public SqlDataAdapter()

Initializes a new instance of the SqlDataAdapter class.

public SqlDataAdapter(SqlCommand selectCommand)

Initializes a new instance of the SqlDataAdapter class with the specified SqlCommand as the SelectCommand property.

public SqlDataAdapter(string selectCommandText, SqlConnection selectConnection)

Initializes a new instance of the SqlDataAdapter class with a SelectCommand and a SqlConnection object.

public SqlDataAdapter(string selectCommandText, string selectConnectionString)

Initializes a new instance of the SqlDataAdapter class with a SelectCommand and a connection string.