automaticaly refresh
-
Is there any mechanism to refresh a dataset automatically when the data source ,lets say a table in SqlServer, is updated, deleted or inserted. No periodic fill or execuete a sql statement please. Thanks
muharrem wrote:
No periodic fill or execuete a sql statement please.
Why not?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
-
muharrem wrote:
No periodic fill or execuete a sql statement please.
Why not?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
I don't know when the original data source is updated by other user or an other aplication. My project is going to be part of a plant automation system. So the events from the plant level my arise in very short time duration or too long. It depends on the condition at that moment. So if I periodically fill my data set, what will be the period? It is very difficult to gess id advance. Having it too short will bring unnecessary workload for the system. Or having it too long will cause to miss the some indermediate update in the data source. I am not very good on Ado.Net. I need to know ,if possible, can I have my client application to refresh its dataset (automatically) from the data source when it is updated. Thanks for reply, anyhow
-
Is there any mechanism to refresh a dataset automatically when the data source ,lets say a table in SqlServer, is updated, deleted or inserted. No periodic fill or execuete a sql statement please. Thanks
The best way to make this , by using triggers with endpoint in SqlServer 2005
-
The best way to make this , by using triggers with endpoint in SqlServer 2005