sborchers
asked on
Refresh .net form automatically
We have an inventory system, which people enter orders into. Wondering if there is away using .net application tools, linked to a sql server database, to automatically update a .net datagrid with current live orders? As people save something from their end, it would automatically display in our 'warehouse' in their grid. The table inventory orders get saved into is Orders.
kaufmed
How "live" do you want this to be? You could set up a polling mechanism to periodically check the database for new orders. The period of time you specify is entirely up to you, but you wouldn't want it to be too small (like milliseconds) for performance reasons.
ASKER
I would want pretty much instant changes to appear on their screens. Is that possible, or is the use of timers to pull data from a table the only way of displaying table data? Thanks, Mike
Please let others weigh in on this topic. I think you *could* write some CLR code that would sit on the database and could potentially push updates to your clients. Even if this is possible, I suspect it wouldn't be the best idea in terms of performance (for your database).
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Well there you go = )
ASKER
I will take a look at the link shortly....Thanks!!