How Do I Execute Multiple Stored Procedures On Single Click ?

Question

0.00/5 (No votes)

See more:

i want to run this command several times with different ids

Exec dbs_sp_applyrule2_helo + id1
Exec dbs_sp_applyrule2_helo + id2
Exec dbs_sp_applyrule2_helo + id3
Exec dbs_sp_applyrule2_helo + id4
.
.
.
.
Exec rbs_sp_applyrule2_mtbc + id50

Note: ids is a number always different

Posted 15-Jan-15 18:59pm

muhammadfaisal1826

Add a Solution

Comments

_Asif_ 16-Jan-15 2:30am

What have you tried so far?

Niju1 16-Jan-15 11:30am

for where you get id? if from a table create another procedure to to call this procedure in a loop

4 solutions

Solution 1

Pick your favorite:

C#

foreach(int id in idCollection) {
// your Exec code with current ID
}

for (int i = 1 to 50) {
// your EXEC code with current ID (i)
}

int i = 0;
while (++i > 50) {
// your EXEC cide with current ID (i)
}

Posted 15-Jan-15 20:44pm

Sinisa Hajnal

Solution 2

Quote:
Hi,

Please create a dynamic query in for or foreach loop and execute it in one hit....

for that you need to create a new stored procedure which will take this query a input parameter.

hope you got concept..

Posted 15-Jan-15 21:09pm

Bharat Singh Negi

Solution 3

Use Threading to do so...

Create a function which takes a parameter as ID... and call this function in for loop with new thread assigned to it... THis way you can take good advantage of SQL... and atlast use thread.join().

Try it out !!!!

Posted 16-Jan-15 1:29am

deepakdynamite

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)

Richard Deeming · Accepted Answer · 2015-01-16T02:25:00

Try this:

C#

using (SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE"))
using (SqlCommand command = new SqlCommand("dbs_sp_applyrule2_helo", connection))
{
    command.CommandType = CommandType.StoredProcedure;
    
    SqlParameter idParameter = command.Parameters.Add("@ID", SqlDbType.Int);
    
    connection.Open();
    
    foreach (int id in listOfIdsToUse)
    {
        idParameter.Value = id;
        command.ExecuteNonQuery();
    }
}