Multiple quries on one connection...

Question

0.00/5 (No votes)

See more:

i want to excute insert and update sql quries on one button event in C#...

i want to to this... so that i will update on table in datable and insertsome data in another table. at the same time...

can anyone give me some idea about this..

Posted 28-Feb-11 17:37pm

codegeekalpha

Add a Solution

5 solutions

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)

m@dhu · Answer 1 · 2011-02-28T18:03:00

Use a procedure with both insert and update queries.

Check the TestProc

SQL

CREATE PROCEDURE TestProc
@Column1 varchar(50),
@Column2 varchar(50),
@Column3 varchar(50),
@Column4 varchar(50)
	
AS
BEGIN
	
insert into Table1(Column1, Column2) values (@Column1, @Column2)

update Table2 set Column4 = @Column4 where column3=@column3

END

CodeHawkz · Answer 2 · 2011-02-28T18:17:00

Solution 3

Hi,

I believe the above answers are good enough. But just so that you know, you can use transactions to execute multiple inserts/updates/deletes and rollback all changes if any of them fails.

Just take a look at this Link[^]

Hope this helps, Regards.

Posted 28-Feb-11 18:17pm

CodeHawkz

Updated 28-Feb-11 18:18pm

v2

Ramalinga Koushik · Answer 3 · 2011-02-28T17:46:00

Solution 1

this[^] might help you.

Posted 28-Feb-11 17:46pm

Ramalinga Koushik

RaviRanjanKr · Answer 4 · 2011-02-28T18:29:00

Use Multiple Active Result Sets (MARS) which allows you to execute multiple queries or stored procedures on a single connection
take a look there-[Want to Execute Multiple Queries on a Single Connection][^].
this article demonstrates how to utilize MARS and also discusses the situations in which MARS is appropriate and can provide performance benefits

sridhar.venkataramanan · Answer 5 · 2011-02-28T19:31:00

Hi,

Create transactions, and insert and commit or rollback the insertion based on the output and then perform the update accordingly and again update the transactions.

some thing like the followings.

connection.transactions
int i = insertIntoMyTable();// call the insertion operation

if(i>0)
{
//Commit transaction
cn. transaction
int u = UpdateIntoMyTable();// call the update method
if(u>0)
{
//commit transaction
}
else
{
//rollback transaction
}
}
else
{
// Rollback the transaction
}

Multiple quries on one connection...

5 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Solution 5

Add your solution here

Preview 0