Guest User

Untitled

a guest
Dec 11th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. private void button6_Click(object sender, EventArgs e)
  2. {
  3. try
  4. {
  5. connection.Open();
  6. OleDbCommand command = new OleDbCommand();
  7. command.Connection = connection;
  8. string query =
  9. "UPDATE Marc SET Marcstud =@ln Where IDSubject=@subject AND IDStudent=@student";
  10.  
  11. //command.Parameters.AddWithValue("@ln", Convert.ToInt32(textBox_m.Text));
  12. //command.Parameters.AddWithValue("@student", Convert.ToInt32(textBox_S.Text));
  13. //command.Parameters.AddWithValue("@subject", Convert.ToInt32(textBox_p.Text));
  14.  
  15. command.Parameters.AddWithValue("@ln", 4);
  16. command.Parameters.AddWithValue("@student", 301);
  17. command.Parameters.AddWithValue("@subject", 101);
  18.  
  19.  
  20. MessageBox.Show(query);
  21. command.CommandText = query;
  22.  
  23. command.ExecuteNonQuery();
  24. MessageBox.Show("data edit successful");
  25. connection.Close();
  26. }
  27. catch (Exception ex)
  28. {
  29. MessageBox.Show("error" + ex); ;
  30. }
  31. }
  32.  
  33. public void Update(String connectionString)
  34. {
  35. var ln = Convert.ToInt32(textBox_m.Text);
  36. var student = Convert.ToInt32(textBox_S.Text);
  37. var subject = Convert.ToInt32(textBox_p.Text);
  38.  
  39. using (var connection = new OleDbConnection(connectionString))
  40. {
  41. using (var command = connection.CreateCommand())
  42. {
  43. command.CommandText = "UPDATE Marc SET Marcstud = @ln Where IDSubject = @subject AND IDStudent = @student;";
  44. command.Parameters.AddRange(new OleDbParameter[]
  45. {
  46. new OleDbParameter("@ln", ln),
  47. new OleDbParameter("@student", student),
  48. new OleDbParameter("@subject", subject)
  49. });
  50.  
  51. connection.Open();
  52. command.ExecuteNonQuery();
  53. }
  54. }
  55. }
Add Comment
Please, Sign In to add comment