i am using two insert query to add two table data instead of insert with select clause and it works but not save data together. then i am using this query to show data in datatable gridview..
SELECT dbo.Setup_article_production.article_id, dbo.Setup_article_production.article_code, dbo.Setup_article_production.article_name, dbo.Setup_article_production.machine_size, dbo.Setup_article_production.guage, dbo.Setup_article_production.gsm, dbo.Setup_article_production.weight, dbo.Setup_buyer.buyer_code FROM dbo.Setup_article_production LEFT JOIN dbo.Setup_buyer ON dbo.Setup_article_production.article_id = dbo.Setup_buyer.buyer_id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)