How to get real-time data from SQL Server Compact databases (*.sdf file) using Visual Studio 2010, WinForm, C#.NET, .NET Framework 4.0 to update Controls (Label and DataGridView).
0
votes
By real-time, you mean you want the application to be updated every time there are changes in the database?
- whastupduck
yes, is that possible? like in SQL Server 2005 or higher.
- CodeGhoib
For SQL Server Compact, you will have to do polling, depending on how you structure tables, you can do some leightweight polling
- ErikEJ
2 Answers
0
votes
There are some solutions for this problem. On the database side, you can use Event Notifications where you can subscribe to the changes occurring in the database and handle the events. Another would be polling, that is monitoring your database by constantly running queries and checking changes.
0
votes
