DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source
InsertCommand , UpdateCommand , and DeleteCommand properties of the DataAdapter are Command objects that manage updates to the data in the data source according to modifications made to the data in the DataSet.
Dim adapter As New SqlDataAdapter() adapter.InsertCommand = New SqlCommand(insertSql, connection)
SqlDataAdapter adapter = new SqlDataAdapter(); adapter.InsertCommand = new SqlCommand(insertSql, connection);
Dim adapter As New SqlDataAdapter() adapter.UpdateCommand = New SqlCommand(updateSql, connection)
SqlDataAdapter adapter = new SqlDataAdapter(); adapter.UpdateCommand = new SqlCommand(updateSql, connection);
Dim adapter As New SqlDataAdapter() adapter.DeleteCommand = New SqlCommand(deleteSql, connection)
SqlDataAdapter adapter = new SqlDataAdapter(); adapter.DeleteCommand = new SqlCommand(deleteSql, connection);
The following ASP.NET program shows how to insert data in the Data Source using SqlDataAdapter and SqlCommand object. Open a connection to the Data Source with the help of SqlConnection object and create a SqlCommand object with insert SQL statement, and assign the SqlCommand to the SqlDataAdapters InsertCommand.
Click the following links to see full source code