Insert update to multiple tables

[iknowyou]

How can I insert, update to multiple tables on just one executecommand? Is it possible? Please Give me different approaches. Thanks.

 

[jmcilhinney]

Why do you want different approaches? If there's an approach that works then why do you need more?

The question really comes down to what database and ADO.NET provider you're using. Some providers support multiple SQL statements while some do not. For example, SqlClient will allow you to include multiple SQL statements separated by semicolons in a single CommandText. OleDb with the Jet OLE DB provider for Access will not, so you'd just have to use multiple commands.

 

[iknowyou]

Because, I want to compare the two different approach, and I think difference approaches has its on strength.

Okay, thanks again man. Your helping me always, thanks.