Hi,
Have a look at the first answer of this question:
http://stackoverflow.com/questions/1258637/insert-dataset-records-in-database[
^]
The answer is C# code, this is the same code converted in VB.NET:
Dim data = New DataTable()
data.Columns.Add("CompanyName", GetType(String))
data.Columns.Add("Phone", GetType(String))
data.Rows.Add("Foo", "12345678")
data.Rows.Add("Bar", "87654321")
Using connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=Northwind.mdb")
connection.Open()
Dim adapter = New OleDbDataAdapter()
adapter.InsertCommand = New OleDbCommand("INSERT INTO Shippers (CompanyName, Phone) VALUES (@CompanyName , @Phone)", connection)
adapter.InsertCommand.Parameters.Add("CompanyName", OleDbType.VarChar, 40, "CompanyName")
adapter.InsertCommand.Parameters.Add("Phone", OleDbType.VarChar, 24, "Phone")
adapter.Update(data)
End Using