Hello all,
It's my first post so please be forgiving.
I've studied ScheduleView with database entity framework (SDK samples).I'm wondering if it is possible to get automatic feedback from database and automatically refresh WPF GUI (ScheduleView) ? In SDK example database is placed in mdf file, but for my needs I've transferred all the tables to SQL Server (Express) - through executing all the sql scripts placed in the ScheduleView Database tutorial. I've modified connectionString to connect with SQL Server instance, instead of database mdf file.
Everything works perfect, but I want to achieve effect in which other person(s) will update Appointments directly in SQL database (e.g. via MS SQL Server Management Studio) and in my application WPF ScheduleView (GridView ?) changes will be automatically visible (e.g. Appointment subiect automatically wil be refreshed). Whether it is at all possible ? I hope all my "problems" are clear to you dear forum people.
Regards
Robert
It's my first post so please be forgiving.
I've studied ScheduleView with database entity framework (SDK samples).I'm wondering if it is possible to get automatic feedback from database and automatically refresh WPF GUI (ScheduleView) ? In SDK example database is placed in mdf file, but for my needs I've transferred all the tables to SQL Server (Express) - through executing all the sql scripts placed in the ScheduleView Database tutorial. I've modified connectionString to connect with SQL Server instance, instead of database mdf file.
Everything works perfect, but I want to achieve effect in which other person(s) will update Appointments directly in SQL database (e.g. via MS SQL Server Management Studio) and in my application WPF ScheduleView (GridView ?) changes will be automatically visible (e.g. Appointment subiect automatically wil be refreshed). Whether it is at all possible ? I hope all my "problems" are clear to you dear forum people.
Regards
Robert
1 Answer, 1 is accepted
0
Hello Robert,
I am not sure how such a notification to the UI when there is an update in the database could be implemented, here is a similar topic discussed on StackOverflow:
http://stackoverflow.com/questions/9103196/how-to-automatically-update-gui-whenever-data-source-changes
and such implementation does not seem easily achievable, at least it should be implemented at the database level.
I am sorry we weren't of much help in this case.
Regards,
Yana
Telerik
I am not sure how such a notification to the UI when there is an update in the database could be implemented, here is a similar topic discussed on StackOverflow:
http://stackoverflow.com/questions/9103196/how-to-automatically-update-gui-whenever-data-source-changes
and such implementation does not seem easily achievable, at least it should be implemented at the database level.
I am sorry we weren't of much help in this case.
Regards,
Yana
Telerik
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.