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

Create a View of Both Table then insert data of Required fields.

Show your insert query and tell us more about your issue, in the question you used joins with select statement

You cannot save data to multiple tables When you use joins to fetch from multiple table.

first i use this "insert into article-production(code,name,weight)values(@code,@name,@weig ht,(select buyer from setup where id =@id)" but it gives error then i use inserting into two different query for two different tables and wanted to see both table data in one select query but both tables not link or join and select query mention in question

Answers

i want to insert two table data and then show both table dat

Ali Khan

565

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

Answers (5)

Next Recommended Forum

Read a large Text File ( 250 MB) And Write in TextBox C#

Bot Framework related query

Leaderboard

View all

Netaji Junghari

+79

George

Lokendra Singh

-1

View all

Yesterday's leader

Netaji Junghari

Bangalore (India)

897

103.8k

852

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

711

9.7k

1.3k

Speaker of the month

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

156

117.7k

11.8k

500

Upcoming events

View all

Suggested for you

View all

Pradeep Sahoo

Manev Dave

Dhanapal Chandran

Rathrola Prem Kumar

Kajul Nisha

Forum Statistics

Please welcome our newest member Adarsh Manepalli.
3,078,351 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 4 new threads, 21 new posts, and 68 new users.
In last week, the most popular thread is 'Get 24 months rollover value from database'.