To Add, Edit N To Delete Records
In Form Declaration
Dim dt As DataTable
Dim dr As DataRow
In Form Load Event
dt = DataSet11.Tables("courses")
To Add
dr = dt.NewRow
dr(0) = TextBox1.Text
dr(1) = TextBox2.Text
dr(2) = TextBox3.Text
dt.Rows.Add(dr)
USRUPDATE()
'To edit table row
dr = dt.Rows.Find(TextBox1.Text)
dr.BeginEdit()
dr(0) = TextBox1.Text
dr(1) = TextBox2.Text
dr(2) = TextBox3.Text
dr.EndEdit()
USRUPDATE()
'To delete aRecord
dr = dt.Rows.Find(TextBox1.Text)
dr.Delete()
USRUPDATE()
SUB USRUPDATE()
OleDbDataAdapter1.Update(DataSet11, "courses")
MsgBox("The Opeeration Done")
OleDbDataAdapter1.Fill(DataSet11, "courses")
End sub