Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void gvPrices_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
- {
- gridID = Convert.ToInt32(gvPrices.Rows[e.RowIndex].ToString());
- gridID = Convert.ToInt32(gvPrices.Rows[e.RowIndex].Cells[0].Text.ToString());
- gridID = Convert.ToInt32(gvPrices.Rows[e.RowIndex].Cells[0].Value.ToString());
- }
- protected void btnGridDelete_Click(object sender, EventArgs e)
- {
- using (SqlConnection DataBCon = new SqlConnection(WebFigCon))
- {
- if (gridID != 0)
- {
- string sqlQuery = ("DELETE Treatment WHERE TreatmentID = @id");
- SqlCommand cmdDeleteData = new SqlCommand(sqlQuery, DataBCon);
- DataBCon.Open();
- cmdDeleteData.Parameters.AddWithValue("@id", gridID);
- cmdDeleteData.ExecuteNonQuery();
- DataBCon.Close();
- lblInput.Text = "Treatment deleted";
- DisplayData();
- ClearData();
- }
- else
- {
- lblInput.Text = "Choose a treatment to delete";
- }
- }
Add Comment
Please, Sign In to add comment