For inserting data to multiple tables without using multiple insert statements ,how to do ?

Question

0.00/5 (No votes)

See more:

VS2005

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 5-Jul-10 5:38am

nav234

Add a Solution

1 solution

Add a Solution

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

TheyCallMeMrJames · Accepted Answer · 2010-07-05T07:33:00

Solution 1

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.

Posted 5-Jul-10 7:33am

TheyCallMeMrJames

For inserting data to multiple tables without using multiple insert statements ,how to do ?

1 solution

Solution 1

Add your solution here

Preview 0

For inserting data to multiple tables without using multiple insert statements ,how to do ?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us