Database monitoring

Mosteck

Active member
Joined
Nov 23, 2008
Messages
31
Location
Toronto
Programming Experience
3-5
I'm developing a VB.net program using VS2008 that acts as a data collection system.

The main screen displays a couple of datagrids that are displaying information from a MS Access database. Currently I'm using the following code to update the datagrid display on a 1 second timer:

VB.NET:
Me.IADC_FaultStorageTableAdapter.Fill(Me.FaultDBDataSet.IADC_FaultStorage)
Me.FaultDataGridview.Refresh()

I'm seeing that the HDD light is flashing constantly when the application is running and this worries me a bit. Is there a way to check if a database has changed and then do a refresh of the datagrid(s) that are populated by that database?
 
Hi

You can count the records in the Dataset and compare them with backend table records, If the two don't match, you can trigger the refill.
 
You can count the records in the Dataset and compare them with backend table records, If the two don't match, you can trigger the refill.

Thanks Arjmand... This would be less the most appropriate way of doing this?

I was thinking that maybe there was a flag that the database could be configured to set when it's changed so I'm not reading the database (for information or row counting) all the time.

I do appreciate your time for the response though..
 

Latest posts

Back
Top