Solved

run stored procedures one after the other

Posted on 2014-02-27
3
177 Views
Last Modified: 2014-02-28
In my asp.net 3.5 app I want to run a stored procedure to insert/update a database table.  Then I want my gridview to reference that table using a second stored procedure.  How can I make sure the second stored procedure runs after the first has finished?
0
Comment
Question by:AlHal2
3 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 39893722
Database operations are usually synchronous, but not all of them.  Can you explain what you are working with?
0
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 250 total points
ID: 39893791
Simply merge the two procedures into one. You can have more than one SQL command in the same procedure.
0
 

Author Closing Comment

by:AlHal2
ID: 39894274
thanks.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How can I use SQL Stored Procedure to return FedEx Zone 17 41
Two different visual studio versions 3 21
Run time Error 4 34
Not seen Link button 5 0
Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now