Rafael,
You can use the Insert command, however mostly is used the dataset, a
datatable, a dataadapter and databinding with dotNet.
See this sample how the use of buttons and textboxes becomes than very
simple
http://www.windowsformsdatagridhelp....9-4deb7fa4a0b8
For the update you use the dataadapter.update
I see now that we have nothing for that on our website so that will be soon.
In fact it can go in general like this (for the first table in the dataset)
sample for the most part typed in this message so watch errors.
\\\
(imports system.data.oledb)
Dim Conn As New OleDbConnection("connectionstring")
Try
Dim da As New OleDbDataAdapter(sqlstring, Conn)
da.SelectCommand.CommandTimeout = 160
Dim cb As New OleDbCommandBuilder(da)
Bindingcontext(ds.Tables(0)).EndCurrentEdit
If ds.HasChanges Then
da.Update(ds.Tables(0))
End If
Catch ex As OleDbException
'procedures to Handlde the errors
Catch ex As Exception
'procedures to handle the errors
End Try
////