Dim SavInto As New OleDb.OleDbCommand
Dim ConStr As String = _
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" & _
Application.StartupPath & "\Database.accdb"
Dim Conn As New OleDbConnection(ConStr)
SavInto.Connection = conn
SavInto.CommandType = CommandType.Text
SavInto.CommandText = "INSERT INTO employees (id_card,emp_name,address,birthdate,phone,father,department,salary,room,hir_date,memo)" & _
"values ('" & IdTextBox & "','" & nameTextBox & "','" & addressTextBox & "','" & BirthdateMaskedTextBox & "','" & PhoneTextBox & "','" & FatherTextBox & "','" & DepartmentTextBox & "','" & SalaryTextBox & "','" & RoomTextBox & "','" & hirMaskedTextBox & "','" & MemoTextBox & "') "
conn.Open()
SavInto.ExecuteNonQuery()
conn.Close()
MsgBox("تم الحفظ")
ممكن اسال اية الخطا فى الكود السابق
الكود للحفظ فى قاعدة بيانات اكسس
