我想插入两个表数据，然后将两个表数据显示到一个datagridview表中 [英] I want to insert two table data and then show both table data into one datagridview table

问题描述

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

推荐答案

首先检查您是否都将插入查询插入数据到表中.

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

这篇关于我想插入两个表数据，然后将两个表数据显示到一个datagridview表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！