Sql and VB question?

Question

I have a vb form that needs a little visible counter that says you have x new requests but it should refresh automatically every few seconds and it should get the number from a sum query

can you help me do that, please don't answer if you don't know how.

Answer 1

Well, your question is a little vague.

Where is the data coming from? Access? SQL Server? Is this a client server app, simple Windows form app, or web based?

Basically, you just nee to run a query, probably with some ADO.NET stuff, and then run a method to execute the quesry and update the label/textbox on the form. You could create a timer object to keep track of the timing.

More Info = Better Answer

Good luck : )

Answer 2

Sounds like you want to set up a timer. Whenever the timer fires:

1) Execute your sum query

2) Update your your form with the query results

3) Reset your timer.