Database monitoring

[Mosteck]

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:

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?

 

[arjmand]

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.

 

[Mosteck]

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..

 

[arjmand]

not sure

Well i am not sure about that, I have been doing it like the way I have shared with ya.