Hi,
I've been using the WinSchedule demo to perform some test with a sql connectionstring which works fine.
except I'm trying to modify it so the app can be used by multiusers and has a constant real-time connection with
the database to show the appointments and other information, is this possible?
I don't want to make use of the synchronise option to get the database in sync...
Important is to be able to update the database from multiple users.
Could I make a dataset which displays all appointments real-time from the database as well update it?
Cheers,
Hello,
A DataSet is designed to be used as a disconnected data source where you only go back every once in a while to get updates from the database. Here's a form thread on Stack Overflow that discusses a very similar issue.
http://stackoverflow.com/questions/1099301/how-do-i-get-a-windows-form-client-to-update-every-time-a-sql-server-table-change