?
Solved

Need to create background process to do DB management

Posted on 2003-12-03
3
Medium Priority
?
374 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Assisted Solution

by:smegghead
smegghead earned 150 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 225 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

Industry Leaders: 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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

801 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