Guest User

Untitled

a guest
Jan 12th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. private void gvPrices_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
  2. {
  3. gridID = Convert.ToInt32(gvPrices.Rows[e.RowIndex].ToString());
  4. gridID = Convert.ToInt32(gvPrices.Rows[e.RowIndex].Cells[0].Text.ToString());
  5. gridID = Convert.ToInt32(gvPrices.Rows[e.RowIndex].Cells[0].Value.ToString());
  6. }
  7.  
  8. protected void btnGridDelete_Click(object sender, EventArgs e)
  9. {
  10. using (SqlConnection DataBCon = new SqlConnection(WebFigCon))
  11. {
  12. if (gridID != 0)
  13. {
  14. string sqlQuery = ("DELETE Treatment WHERE TreatmentID = @id");
  15. SqlCommand cmdDeleteData = new SqlCommand(sqlQuery, DataBCon);
  16.  
  17. DataBCon.Open();
  18. cmdDeleteData.Parameters.AddWithValue("@id", gridID);
  19. cmdDeleteData.ExecuteNonQuery();
  20. DataBCon.Close();
  21.  
  22.  
  23. lblInput.Text = "Treatment deleted";
  24.  
  25. DisplayData();
  26. ClearData();
  27. }
  28. else
  29. {
  30. lblInput.Text = "Choose a treatment to delete";
  31. }
  32. }
Add Comment
Please, Sign In to add comment