how to update multiple table at the same time in c#

Question

0.00/5 (No votes)

See more:

how to update multiple table at the same time in c#??
i want to update 4 tables data at a time where one field is comman in all tables..??
how i can..???

Posted 16-Nov-11 0:32am

soniya sangal

Add a Solution

3 solutions

Solution 1

Are you updating database tbales, HTML tables...?

If you are inquiring about database tables, as in you need to update several tables in one go, then have a look at ADO.NET transactions..

Using Transactions in ADO.NET[^]

Posted 16-Nov-11 0:35am

Mel Padden

Comments

soniya sangal 16-Nov-11 6:36am

thanx for reply...

ya database tables how i can???

Mel Padden 16-Nov-11 7:12am

So you need to update the same column in several tables. With the same value?

Create a database transaction, and in the transaction you update each table with the required value. That way, if one fails, you can roll back all the changes.

Something like:

BEGIN TRANSACTION

UPDATE [TableName] Set Col = @Value WHERE <condition>
UPDATE [TableName2] Set Col = @Value WHERE <condition>
UPDATE [TableName3] Set Col = @Value WHERE <condition>

IF @@ERROR <> 0 BEGIN
ROLLBACK
END ELSE BEGIN
COMMIT
END

RaviRanjanKr 16-Nov-11 16:58pm

My 5+

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)

Vikas_Shukla_89 · Accepted Answer · 2011-11-16T00:58:00

hi,
in this case u can do following two things..
1. u can use or make StoredProcedure and write your sql statement to insert the data to multiple table at a single time.

and the second way according to me, u can create trigger on perticular table for insert.

visit for more info

http://www.upsizing.co.uk/Art18_CascadeTriggers.aspx[]

hope this help..

srinivas vadepally · Accepted Answer · 2011-11-16T02:26:00

Solution 3

hi soniya,

you can update multiple tables with a stored procedure also.
Just follow the below link ,i hope it helps you.

Updating Multiple Tables[^]

If you have any query for me, just make a comment or question.

Posted 16-Nov-11 2:26am

srinivas vadepally