Auto Refresh

[tapai_rhino]

hi all...

im using vb.net+sql server and i need to do an auto refresh (every 10 sec) in my form. is there any way to do it?..

thanks in advance...

 

[jmcilhinney]

You'd just need to query the database every 10 seconds. You should include a timestamp column so that you are able to just retrieve records that have changed since the last time you checked. The problem is that you can't really delete records as they will not show as deleted unless you just got all the data again, which would be a fair bit of traffic every 10 seconds in many cases. You could just add a boolean field that indicates whether the record is active or not.