DataAdapter Properties and Methods in ADO.NET

This article has been excerpted from book "A Programmer's Guide to ADO.NET in C#".

DataAdapter Properties

As you start working data adapters, you need take a Quick looks at data adapter properties and methods. The DataAdapter has properties of type Command, which represent the ways it can query, insert, delete, and update the database.

These properties are of type OleDbCommand.

Table 5-28 describes OleDbDataAdapter class properties.

Table 5-28 describes ole Db DataAdapter properties 

PROPERTY	DESCRIPTION
DeleteCommand	Represents a DELETE statement or stored procedure for deleting records from the data source
InsertCommand	Represents an INSERT statement or stored procedure for inserting a new record to The data source
SelectCommand	Represents a SELECT statement or stored procedure can be used to select records from a data source
UpdateCommand	Represents an UPDATE statement or stored procedure for Updating recording in a data source
TableMappings	Represents a collection of mappings between actual data source table and a DataTable object

Table 5-29 shows these command properties and their examples.

Table 5-29. OleDbDataAdapter Command Properties with Examples

PROPERTY	EXAMPLE
SelectCommand	cmd.SelectCommand.CommandText = "SELECT * FROM Orders ORDER BY Price";
DeleteCommand	TheDataSetCommand.DeleteCommand.CommandText = "DELETE FROM orders WHERE LastName = 'Smith' ";
InsertCommand	TheDataSetCommand.InsertCommand.CommandText = "INSERT INTO Orders VALUE (25, 'Widget1', 'smith')";
UpdateCommand	TheDataSetCommand.UpdateCommand.CommandText = "UPDATE Orders SET ZipCode = '34956' WHERE OrderNum = 14";

Data Adapter Methods

The DataAdapter class provides many useful methods. For instance, the FILL method of the DataAdapter fills data from a data adapter to the DataSet object, and the Update method stores data from a DataSet object to the data source.

Table 5-30. The ole Db Data Adapter methods 

METHOD	DESCRIPTION
Fill	This method fills data records from a DataAdapter to a DataSet object.
FillSchema	This method adds a DataTable to a DataSet.
GetFillParameters	This method retrieves parameters that are used when a SELECT statement is executed.
Update	This method stores data from a data set to the data source.

Conclusion

Hope this article would have helped you in understanding DataAdapter Properties and Methods in ADO.NET. See my other articles on the website on ADO.NET.

This essential guide to Microsoft's ADO.NET overviews C#, then leads you toward deeper understanding of ADO.NET.