How to DataAdapter in OLEDB
OleDbDataAdapter provides the communication between the Dataset and the Data Source with the help of OleDbConnection Object . The OleDbConnection Object has no information about the data it retrieves . Similarly a Dataset has no knowledge of the Data Source where the data coming from. So the OleDbDataAdapter manage the communication between these two Objects.
OleDbDataAdapter is used to retrieve data from a data source and populate tables within a DataSet . The OleDbDataAdapter also resolves changes made to the DataSet back to the data source. The OleDbDataAdapter object allows us to populate Data Tables in a DataSet. We can use Fill method of the OleDbDataAdapter for populating data in a Dataset. The following c# Source Code shows a simple program that uses OleDbDataAdapter to retrieve data from Data Source with the help of OleDbConnection object and populate the data in a Dataset.
Full Source C#- How to DataAdapter in Sql Server
- How to DataAdapter Select Command - Sql Server
- How to DataAdapter Select Command - OLEDB
- How to DataAdapter Insert Command - Sql Server
- How to DataAdapter Insert Command - OLEDB
- How to DataAdapter Update Command - Sql Server
- How to DataAdapter Update Command - OLEDB
- How to DataAdapter Delete Command - SQL SERVER
- How to DataAdapter Delete Command - OLEDB
- How to DataAdapter CommandBuilder in Sql Server
- How to DataAdapter CommandBuilder in OLEDB
- How to DataAdapter DataGridView - Sql Server
- How to DataAdapter DataGridView - OLEDB