Remote work with DB in C#
Please suggest architecture, tomorrow at work will have to do a big project.
The bottom line:
So, I connect remotely with mysql, take a table such as orders and bring her every minute I update it, here the question:
There is this idea yet, the Manager will not be the same to watch all of the orders, for this you can do a select where
I almost forgot!The most important question!
How to get table from remote database and display it on the form, and the option to download the entire database every minute is not an option...
In General, if there are more ideas on architecture, tells.
Damn, now I can't sleep, think I will...
Judging by the question you are not interested in architecture, and the actual mechanism of how to do it. Moreover, it is unclear - web face where orders can be filed Yes or no? In General, the question reframe explained - Barmaley 22-06-2012 в 11:38:00
Learn how to work with remote database in C#. The task is actually very simple, srednichek =) - AseN 22-06-2012 в 13:43:29
I would work out WPF with database via WCF services, namely dualBindings for two-way communication. This will allow you to get away from timers and spam the database with repeated requests from customers (1st question). When adding a new customer get new information and send it to your customers challenge the "colback" (2nd).
Answered: wind 22-06-2012 в 14:04:16
something like that.
Answered: Yura Ivanov 21-06-2012 в 17:22:00