Click here to Skip to main content
14,880,719 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all ,

Suppose if i want to insert data to multiple tables without using multiple insert statements,how can i achieve it.and how to do it
in the code ?

thanks in advance

Naveen...
Posted

1 solution

Write a stored procedure and call that instead. The stored procedure will still need to have multiple inserts in it.

Before you execute the command you'll need to add the parameters required for the stored proc. There are many samples of this here on CodeProject.

Cheers.
   

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