Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

run stored procedures one after the other

Posted on 2014-02-27
3
Medium Priority
?
189 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 1000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month12 days, 23 hours left to enroll

972 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