Solved

Need to create background process to do DB management

Posted on 2003-12-03
3
347 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Vb.net dynamic formulas in runtime 11 74
C# MVC and a global static factory that never dies 4 57
C#.NET and microsoft certification. 3 40
Hey Audio! 3 27
In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

815 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

10 Experts available now in Live!

Get 1:1 Help Now