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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.