25-06-13, 02:08 PM
انا اظن بان الخطأ في هذا الجزء من الكود
كود :
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim SavInto As New OleDb.OleDbCommand
Dim adapter2 As New OleDbDataAdapter(SQLstr, Conn)
SavInto.Connection = Conn
SavInto.CommandType = CommandType.Text
SavInto.CommandText = "UPDATE TheTable SET Mall = '" & Trim(TextBox3.Text) & "' , Expiry_date_repairs = '" & TextBox4.Value.ToShortDateString() & "' , Repair_Cost= '" & Trim(TextBox5.Text) & "' , Description_repairs= '" & Trim(TextBox6.Text) & "', WHERE Code ='" & m & "'"
Conn.Open()
SavInto.ExecuteNonQuery()
Conn.Close()
TextBox2.ReadOnly = True
TextBox3.ReadOnly = True
TextBox5.ReadOnly = True
TextBox6.ReadOnly = True
End Sub