Checking database using background worker

[bjay_tiamsic26]

hi everyone .. i really need your help !!

i am building an online ordering using PHP and my back-end in VB.net 2008 ..

for instance, a user of vb.net while working with product maintenance for example , and then someone submits order(so it will be saved to the database), using the background worker, during runtime it will search for new input on the database and notify the user of vb.net that there is a pending order using label (label only for simplicity)....

how can I do that?


please please help me.. (

 

[jmcilhinney]

How many .NET clients will there be and what database are you using?

 

[bjay_tiamsic26]

im using MySQL server.

.NET clients?

 

[jmcilhinney]

A client is something that connects to a server. How many instances of your .NET application will be connecting to your server?

 

[jmcilhinney]

Ah, I initially read your answer as SQL Server but then looked again and noticed that it's actually MySQL. The idea I had is specific to SQL Server. If MySQL has no specific notification functionality then you'll just have to use a Timer and check periodically.

 

[bjay_tiamsic26]

A client is something that connects to a server. How many instances of your .NET application will be connecting to your server?

only one client connects to my server

hhow can i resolve my problem???