ADO.NET DataAdapters
DataAdapters are an important part of ADO.NET. They transfer data from any data source to a DataSet, as well as from the DataSet back to the data source. Usually, the data source is a database, but it could also be an XML file.
When you use DataAdapters, you can specify the portions of the data required from the data source by using a SQL statement or stored procedure. The same logic applies when you are trying to implement the changes from the DataSet into the data source.
The two types of DataAdapters are OleDbDataAdapter and SqlDataAdapter. OleDbDataAdapter can be used with any data source that has an OLE DB provider, whereas SqlDataAdapter is only for SQL Server. Additionally, because SqlDataAdapter doesn't have to go ...
Get Building e-Commerce Sites with the .NET Framework 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.
