هذا الكود للاتصال ولاضافة بس عند ما اضيف يطلغ خطاء
Dim con As New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\Sam\My Documents\web.mdb")
Dim ds As New DataSet
Dim da As New OleDb.OleDbDataAdapter
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
'save
Dim r As DataRow
r = ds.Tables("Tabel1").NewRow
r("Name Of Book") = TextBox1.Text
r("publish") = TextBox2.Text
r("Family") = TextBox3.Text
r("ISPN") = MaskedTextBox1.Text
r("Date") = MaskedTextBox2.Text
ds.Tables("Tabel1").Rows.Add®
Dim c As New OleDb.OleDbCommandBuilder(da)
da.Update(ds.Tables("Tabel1"))
Label12.Text = "The Data Saved"
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'load form
Dim da1 As New OleDb.OleDbDataAdapter
da1.SelectCommand = New OleDb.OleDbCommand
da1.SelectCommand.Connection = con
da1.SelectCommand.CommandText = "select * from Tabel1"
Dim ds1 As New DataSet
da1.Fill(ds1, "Tabel1")
DataGridView1.DataSource = ds1.Tables("Tabel1")
Label12.Text = "The Data Loaded"
End Sub
End Classالخطاء في زر الاضافة يطلع عند الداتا ست