Dataadapter InsertCommand - OLEDB Data Source
OleDbDataAdapter provides the communication between the Dataset and the Data Source with the help of OleDbConnection Object . The InsertCommand in OleDbDataAdapter Object manages to insert the data in the specified Data Source .
In the following 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.
Imports System.Data.OleDb Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connetionString As String Dim connection As OleDbConnection Dim oledbAdapter As New OleDbDataAdapter Dim sql As String connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Your mdb filename;" connection = New OleDbConnection(connetionString) sql = "insert into user values('user1','password1')" Try connection.Open() oledbAdapter.InsertCommand = New OleDbCommand(sql, connection) oledbAdapter.InsertCommand.ExecuteNonQuery() MsgBox("Row(s) Inserted !! ") Catch ex As Exception MsgBox(ex.ToString) End Try End Sub End Class
Related Topics
- Dataadapter with dataset - sql sever
- Dataadapter with dataset - OLEDB Data Source
- Dataadapter SelectCommand - Sql Server
- Dataadapter SelectCommand - OLEDB Data Source
- Dataadapter InsertCommand - Sql Server
- Dataadapter UpdateCommand - Sql Server
- Dataadapter UpdateCommand - OLEDB Data Source
- Dataadapter DeleteCommand - Sql Server
- Dataadapter DeleteCommand - OLEDB Data Source
- Dataadapter with CommandBuilder - Sql Server
- Dataadapter with CommandBuilder - OLEDB
- Dataadapter with DataGridView - Sql Server
- Dataadapter with DataGridView - OLEDB
Related Topics