DataGridView auto refresh

[dentis2l]

Hello,

I am building a windows application. I know how to load the data manually using dataadapter and dataset. I was wondering if there is a way to synchronize an sql server table with a datagridview. When someone updates the database, the content of the dataview should be automatically refreshed in my form.

Is it possible to have the datagrid updated automatically without triggering the manual update every ‘n’ seconds?

Thank you for you time,
Dent

 

[vis781]

There is, and it is called SQL Server Notification Services. This can happen on a number of levels but the most appropriate for you would be on the file level. This means that the notification service will write to a file with the contents of the notification. You could maybe use a file watcher to determine when this directory has been altered.
Have a look into SQL Server Notification Services, i haven't got into them yet myself so i can't really help much more than that.