Solved

Need to create background process to do DB management

Posted on 2003-12-03
3
362 Views
Last Modified: 2013-12-03
I'll give more points for the right answer.

I want to create a Windows app in C# that does some simple DB stuff, such as adding a new employee. When this program starts, it also creates another thread(?) that periodically accesses the database (ex. sql server) and does some stuff to it. This background process would wake up every 10 min, for example, does what it needs to do, then goes to sleep for 10 min. The process has to run asynchronously to the main app.

What I'm looking for is a prototype of this main app/background process. Thanks.
0
Comment
Question by:hobster
3 Comments
 
LVL 10

Assisted Solution

by:smegghead
smegghead earned 50 total points
ID: 9871520
Why not just use a timer?? that way you don't have to bother with creating/starting threads.

Just put a timer on your form and add your code to check the sql.

Smg.
0
 
LVL 6

Accepted Solution

by:
townsma earned 75 total points
ID: 9878807
To take the recomendation of smegghead one stage further, try creating a thread at a module level, then when the timer event fires, check the state of the thread, if still running, exit the sub.  If not still running start the thread.  This way you db work will still run in a seperate thread.

Hope this helps, good luck.
0
 
LVL 2

Author Comment

by:hobster
ID: 10005885
Do threads run asynchronously of each other? I read that they don't. One thread runs for a bit, then stops and another thread runs and stops and the 1st one runs again. It's not true multitasking. Is there a way to make them both run at the same time?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

726 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