How to DataAdapter Insert Command - OLEDB
OleDbDataAdapter provides the communication between the Dataset and the Data Source with the help of OleDbConnection Object . InsertCommand , UpdateCommand , and DeleteCommand properties of the OleDbDataAdapter are Command objects that manage updates to the data in the data source according to modifications made to the data in the DataSet.
The InsertCommand in OleDbDataAdapter Object manages to insert the data in the specified Data Source . From the following C# Source Code shows how to insert data in the Data Source using OleDbDataAdapter and OleDbCommand Object . Open a connection to the Data Source with the help of OleDbConnection object and create an OleDbCommand object with insert SQL statement, and assign the OleDbCommand to the SqlDataAdapter's InsertCommand.