i want to before delete check in two tables "MainBillForm" and "suppliers_Form"
if (Product_ID != 0)
{
cmd = new SqlCommand("IF NOT EXISTS(SELECT Product_Name FROM MainBillForm,suppliers_Form WHERE Product_Name = '" + Product_ID + "')delete Product where Product_ID=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", Product_ID);
btn_Insert.Text = "Save";
int k = cmd.ExecuteNonQuery();
con.Close();
if (k > 0)
{
MessageBox.Show("Record Deleted Successfully!");
}
else
{
MessageBox.Show("Product is Already used in Bill So you don't Deleted this Product !");
}