SqlDataAdapter cda = new SqlDataAdapter("select Category,Subcategory ,Price from Main m left outer join Subcategory s on m.SubcategoryID= s.[S.ID] join Category c on m.CategoryID= c.[C.ID] WHERE Status = 'ACTIVE' AND NOT EXISTS( SELECT 1 FROM table3 WHERE m.EPC = table3.EPC)", con);
DataTable cdt = new DataTable();
cda.Fill(cdt); BindingSource cbs = new BindingSource();
cbs.DataSource = cdt;
dataGridView2.DataSource = cbs;
cda.Update(cdt);