Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. public void ChangeMeetingName()
  2. {
  3.  
  4. string MeetingName = TxtBoxChangeName.Text;
  5.  
  6.  
  7. string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  8.  
  9. SqlConnection conn = new SqlConnection(connStr); ;
  10.  
  11. SqlCommand cmd = new SqlCommand(@"UPDATE Meetings SET MeetingName=@MeetingName WHERE MeetingsID=@MeetingsID)", conn);
  12.  
  13. SqlParameter Parameter1 = new SqlParameter();
  14. Parameter1.ParameterName = "@MeetingName";
  15. Parameter1.Value = MeetingName;
  16. cmd.Parameters.Add(Parameter1);
  17.  
  18. SqlParameter Parameter2 = new SqlParameter();
  19. Parameter2.ParameterName = "@MeetingsID";
  20. Parameter2.Value = MeetingID;
  21. cmd.Parameters.Add(Parameter2);
  22.  
  23. conn.Open();
  24. cmd.ExecuteNonQuery();
  25. conn.Close();
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement