How to before delete records check in two tables same field

Jyoti Jodha

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

}

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
try this
IF NOT EXISTS(SELECT mf.Product_Name FROM MainBillForm mf,
suppliers_Form sf
WHERE mf.Product_Name =@id orsf.Product_ID=@id)
delete from Product where Product_ID=@id
Jyoti Jodha9y ago
yes, i want to delete product name form Product
if product name (id) don't use in Table suppliers_Form and MainBillForm
Rafnas T P9y ago
I think you wanted to delete product from table which product should not there in MainBillForm , is that you want to do
Rafnas T P9y ago
hi,
can you tell me what do you wanted to do exactly so that we can help you properly
Kailash Polai9y ago
Hi, Try this one
IF NOT EXISTS(Select 1 from MainBillForm M inner join suppliers_Form S on M.Product_Name = S.Product_Name where M.Product_Name = '" + Product_ID + "') Delete Product where Product_ID=@id
Amit Gupta9y ago
Ah!! I missed that
(Select mbf.Product_Name from MainBillForm as mbf, suppliers_Form as sf where mbf.Product_Name = '" + Product_ID + "' and sf.Product_Name = '" + Product_ID + "') Delete Product where Product_ID=@id
Jyoti Jodha9y ago
Ambiguous column name 'Product_Name'.

(Select Product_Name from MainBillForm as mbf, suppliers_Form as sf where mbf.Product_Name = '" + Product_ID + "' and sf.Product_Name = '" + Product_ID + "') Delete Product where Product_ID=@id
Amit Gupta9y ago
This would be as per your tablename
Jyoti Jodha9y ago
Error Show Like this

"Invalid object name 'Supplier_Form'."
Amit Gupta9y ago
You can try like this
IF NOT EXISTS(Select Product_Name
from
MainBillForm mbf, Supplier_Form sf
where mbf.ProductID = 1 and sf.ProductID = 1)
Delete Product where ProductID = 1