venkataramanaiahsr
asked on
writing DB polling application in visual basic 6
I want to write a polling application in visual basic 6 which sits on windows taskbar on client desktop (winxp). This application should poll the db periodically and retrives the stock which has gone below the min stock level and displays on the grid.
Can some expert let me know how to accomplish this
ASKER
The DB is Sql 2005. For each item min stock position is defined. I can retrieve the current stock from soh table for each item by comparing it with min stock level for that particular item and display it in the grid. But my question is, i want to have vb application sitting on windows task bar (minimized) and continously poll the DB for this data at perioidic intervals and refresh the grid and give a pop up msg to the user of this data. I would be thankful to the experts if you could let me know how to develop this kind of application in VB.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In its simplest form, seems like a no-brainer. Like LowFat said, just poll the DB on a timer and update your grid. If an item is below min stock levels, display another form with its own timer that displays the info for a short period of time then unloads itself.
But you probably need more advanced functionality like LowFat is describing. If so, study his response thoroughly and work with him on this.
But you probably need more advanced functionality like LowFat is describing. If so, study his response thoroughly and work with him on this.
Please provide the info requested and we should be able to help you further.