January 8, 2009 01:58pm pst

1. Juan_Bar... 6,500
2. DropZone 2,500
3. OBonio 2,000
3. fsze88 2,000
3. AntYau 2,000
3. MaseBase 2,000
3. psasik 2,000
3. melmers 2,000
3. Idle_Mind 2,000
3. Fernando... 2,000
3. Rhino1272 2,000
12. bedanand 1,800
13. WhiteMeat 1,750
14. CalmSoul 1,500
14. RahulPara... 1,500
16. Louis01 1,000
16. kaufmed 1,000
16. Dhaest 1,000
16. tgerbert 1,000
20. Dabas 900
21. TheLearn... 625
22. emoreau 500
23. flwam93 400
24. bmatumbura 200

1. TheLearn... 691,976
2. samtran0... 248,110
3. Dhaest 246,994
4. jaime_oliv... 230,908
5. surajguptha 201,972
6. Idle_Mind 196,445
7. emoreau 163,704
8. jpaulino 143,950
9. Fernando... 118,334
10. jcoehoorn 117,657
11. graye 108,049
12. JimBrandley 103,222
13. webtubbs 102,560
14. angelIII 100,042
15. VBRocks 100,000
16. GreenGho... 94,860
17. DarkoLord 90,476
18. tedbilly 90,024
19. McExp 89,513
20. raterus 79,425
21. prairiedog 78,350
22. naspinski 78,240
23. Sancler 77,532
24. pratima_... 75,829
25. TSmooth 73,363

08.29.2008 at 07:25AM PDT, ID: 23688932

	[x] Attachment Details

How can I make a WIndows Application wait for a stored procedure to finish before continuing?

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.3

Zones:

.NET Framework 2.x, Microsoft Visual C#.Net, .Net Editors & IDEs

Tags:

C# .NET 2.0, T-SQL

I have a situation where I have a Windows Application that processes a few stored procedures and a few other functions in between. The problem is that the stored procedures are not finished before my application moves forward. The stored procs have to finish before moving on. Is there a way to make the code wait for the stored proc to finish before processing the next line of code?

Example:

ProcessSP1() //stored procedure
MoveFile() //file move
ProcessSP2() //stored procedure
DeleteFile() //file deletion
CreateFile() //file creation
ProcessSP3() //stored procedure

In this example ProcessSP1() has to be finished before I can invoke MoveFile(), but MoveFile is taking place while the ProcessSP1() is still running.

Is there a way to make it wait for the ProcessSP1() to finish before contiuing?

Start your 7 day free trial to see this answer

Answered By:	CuteBug
Expert Since:	10/30/2002
Accepted Solutions:	125
Computer Expertise:	Intermediate

CuteBug has been an Expert for 6 years 2 months, during which he has posted 364 comments and answered 125 questions. CuteBug is just one of 1649 experts in the .NET Framework 2.x Zone. 1 expert collaborated on this answer, which was graded an "A" by the asker.

#	Title
1	DeleteFile and CreateFile
2	CreateFile
3	CreateFile and asynchronous
4	CreateFile
5	CreateFile/WriteFile API
6	FileSystemObject MoveFile functionality