Guest User

Untitled

a guest
Mar 18th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. conn = new SqlConnection(ProjectConnection.ConnectionString);
  2. SqlCommand comm2 = new SqlCommand();
  3. comm2.Connection = conn;
  4. comm2.CommandText = "UPDATE Duty SET Edit=@Edit WHERE Current_project='" + Projects_list.SelectedValue + "' AND Date >= "+ Calendar1.SelectedDate+" AND Date <= "+ Calendar2.SelectedDate ;
  5. conn.Open();
  6.  
  7. comm2.Parameters.AddWithValue("@Edit", "1");
  8. comm2.ExecuteNonQuery();
  9. conn.Close();
Add Comment
Please, Sign In to add comment