SQLData … Objects

The SQLData … objects are a collection of optimized data access and manipulation objects designed for working with SQL Server databases.

SQLDataAdapter Object

The SQLDataAdapter object represents a set of SQLDataCommands and a SQLDataConnection, which are used to manipulate data. (See Tables C.29, C.30, and C.31.)

Table C.29. Properties of the SQLDataAdapter Object
Property Description
DeleteCommand Gets or sets a SQL statement used to delete rows from a DataSet.
InsertCommand Gets or sets a SQL statement used to insert rows of data into a DataSet.
SelectCommand Gets or sets a SQL statement used to retrieve rows from a DataSet.
UpdateCommand Gets or sets a SQL statement used to update rows in a DataSet.
Table C.30. Methods ...

Get Inside ASP.NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.