DataGridView auto refresh

dentis2l

New member
Joined
Sep 20, 2006
Messages
2
Programming Experience
Beginner
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

Well-known member
Joined
Aug 30, 2005
Messages
2,015
Location
Cambridge, UK
Programming Experience
5-10
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.
 
Top Bottom