System.Data.Common Namespace
Represents a set of data commands and a database connection that are used to fill a DataSet and update the data source.
| Visibility |
Name |
Parameters |
Return Type |
| protected |
CloneInternals |
( )
|
DataAdapter
|
| protected |
CreateTableMappings |
( )
|
DataTableMappingCollection
|
| protected |
Dispose |
(
Boolean
disposing
)
|
Void
|
| public |
Fill |
(
DataSet
dataSet
)
|
Int32
|
| protected |
Fill |
(
DataSet
dataSet
,
String
srcTable
,
IDataReader
dataReader
,
Int32
startRecord
,
Int32
maxRecords
)
|
Int32
|
| protected |
Fill |
(
DataTable
dataTables
,
IDataReader
dataReader
,
Int32
startRecord
,
Int32
maxRecords
)
|
Int32
|
| protected |
Fill |
(
DataTable
dataTable
,
IDataReader
dataReader
)
|
Int32
|
| protected |
FillSchema |
(
DataSet
dataSet
,
SchemaType
schemaType
,
String
srcTable
,
IDataReader
dataReader
)
|
DataTable
|
| public |
FillSchema |
(
DataSet
dataSet
,
SchemaType
schemaType
)
|
DataTable
|
| protected |
FillSchema |
(
DataTable
dataTable
,
SchemaType
schemaType
,
IDataReader
dataReader
)
|
DataTable
|
| public |
GetFillParameters |
( )
|
IDataParameter
|
| protected |
HasTableMappings |
( )
|
Boolean
|
| protected |
OnFillError |
(
FillErrorEventArgs
value
)
|
Void
|
| public |
ResetFillLoadOption |
( )
|
Void
|
| public |
ShouldSerializeAcceptChangesDuringFill |
( )
|
Boolean
|
| public |
ShouldSerializeFillLoadOption |
( )
|
Boolean
|
| protected |
ShouldSerializeTableMappings |
( )
|
Boolean
|
| public |
Update |
(
DataSet
dataSet
)
|
Int32
|
|
The DataAdapter serves as a bridge between a data source and a DataSet for retrieving and saving data. The DataAdapter provides this bridge by mapping:
- Fill, which changes the data in the DataSet to match the data in the data source, and
- Update, which changes the data in the data source to match the data in the DataSet.
If you are connecting to a Microsoft SQL Server™ database, you can increase overall performance by using the SqlDataAdapter along with its associated SqlConnection and SqlCommand. For other OLE DB-supported databases, use the OleDbDataAdapter with its associated OleDbConnection and OleDbCommand objects.
DbDataAdapter OleDbDataAdapter SqlDataAdapter
|
|
