c# how to sync/check the data from database to datatable?

Question

Hi folks,

Good Day!

I have a datagridview using datatable as my datasource. Now my problem is how do I keep my datatable sync to our Server database? Like for example somebody tried to update the database so automatically my datatable will be update too. Without using iteration. Is this possible guys?

Thanks a lot.

Regards, kurt

Answer 1

Is this using WPF or Winforms?

simple way: each client regularly polls the server and updates as needed.

More complex way: service oriented using callbacks, eg http://www.switchonthecode.com/tutorials/wcf-tutorial-events-and-callbacks

Answer 2

There is nothing automatic in software. We need to automate things that seems to be automatic. You can use caching mechanism for your solution. The datatable can be filled using a cache. The cache can be made invalid on change of underlying tables in the database. And upon invalidating, the datatable shall have to be recreated again and so the gridview shall have to be updated.

If you are using ASP.NET, you can refer the MSDN article on the same here: http://msdn.microsoft.com/en-us/library/ms972379.aspx