How to before delete records check in two tables same field

Question

How to before delete records check in two tables same field name c#

 

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 !");

}