Click here to Skip to main content
15,893,508 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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..


What I have tried:

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
Posted
Updated 1-Feb-18 20:34pm
v2
Comments
[no name] 30-Jan-18 2:19am    
How are you saving?Please enlighten in your question.
Ali Khan 30-Jan-18 2:23am    
using two different insert query for two different tables
Rajesh Pandya 30-Jan-18 6:29am    
Is any error you get? Please explain your question in detail.
Ali Khan 30-Jan-18 7:57am    
actually i use two insert queries to save data in both tables now i wanted to show same data which i insert together in datagridview and my select query is mention above.but i only see one table data
Bjørn 30-Jan-18 8:04am    
If I read correctly you are trying to use the built-in functionality of DataTable to save changes. You might need to write your custom DataSource to acomplish this kind of task.

1 solution

First check whether your both insert query inserting data to the table or not.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900