How to insert into two different table in same stored procedure

Question

1.00/5 (1 vote)

See more:

i want to insert two different data in different tables and both tables not join or link and then i wanted to see inserted data together in datagridview

What I have tried:

insert into article-production(code,name,weight)values(@code,@name,@weig‌ht,(select buyer from setup where id =@id)

Posted 29-Jan-18 22:45pm

Ali Khan

Updated 29-Jan-18 22:57pm

Add a Solution

Comments

Afzaal Ahmad Zeeshan 30-Jan-18 5:29am

That code of SQL is incorrect in itself, article-production does not let you execute two insert statements. You would require to execute two statements to do this.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

F-ES Sitecore · Answer 1 · 2018-01-29T22:57:00

Solution 1

If it is a stored procedure just use two insert statements

SQL

insert into table1 (...) values (...)

insert into table2 (...) values (...)

We can't help you with your display issue as we don't know about your tables or what you want to show. We only know what you tell us, we can't access your code or your database and we can't read your mind.

Posted 29-Jan-18 22:57pm

F-ES Sitecore

Comments

Ali Khan 30-Jan-18 5:11am

yea i use same query but both table data save in there particular table but when i wanted to show both table data in single datagridview then it show only one table data

F-ES Sitecore 30-Jan-18 5:32am

That depends how you want the two tables to appear. You can only do what the underlying control supports, so if it supports master\child tables then do that, but if it only supports a single datasource you'll need to just JOIN the tables together to turn them into one big dataset.

Ali Khan 30-Jan-18 5:15am

in my production table i have columns name as(article-code,article-id ,weight) and in my buyer table columns (buyer-code,buyer-id,buyer-name) now i wanted to save both table data together then show data in datatable gridview together

Afzaal Ahmad Zeeshan 30-Jan-18 5:28am

5ed.