15-10-18, 02:39 PM
كود :
dataconnection()
cmd.Connection = cnn
cmd.CommandText = "UPDATE [info] SET [name] = '" & TextBox12.Text & "',[dateuser] = '" & TextBox15.Text & "',[datauser] = '" & TextBox14.Text & "', [department] = '" & ComboBox2.Text & "', [dgree] = '" & ComboBox3.Text & "', [pagn] = '" & TextBox10.Text & "', [typepag] = '" & TextBox9.Text & "', [typegan] = '" & ComboBox4.Text & "', [ngan] = '" & TextBox8.Text & "', [unti] = '" & TextBox7.Text & "' WHERE ID = " & Val(TextBox13.Text)
cmd.ExecuteNonQuery()
cnn.Close()
clear2()
MessageBox.Show("تم التعديل بنجاح", "تعديل ", MessageBoxButtons.OK, MessageBoxIcon.Information)
loaddata()