please help me,my project.........
-
Dear friends: My team has the following task to complete.A solution that consists of 3 projects : 1-Win app that connected to a local DB server(SQL server) . 2-Web app that connected to a remotre server(SQL server). 3-Mobile app for that connected to tha same remote server of the web app. The Details: 1-The win app deals with a DB(Local DB SQL server) for updating ,retriving,inserting and deleting. 2-The web & the mobile app deal with a DB(Remote DB SQL server) for tha same purpose.(updating ,retriving,inserting and deleting) The Goal: 1-The Win app will connect one time per day to update the Remote SQL server with the new data from the Local SQL server. 2-The Web and mobile app connected to the Remote SQL server will update ,retrieve ,delete and insert records in it. The Questions: 1-If I can use Asp.net web services ,How can I use it? 2-How can i make daily transaction to update the Remote SQL server with the new data at the Local SQL server?? 3-How can i make daily transaction to update the Local SQL server with the new data at Remote SQL server ?? 4-How can i manage the DB Transactions ? 5-how can i use the same methods(code) for dealing with the DB ,for the win app , the web app and the mobile app? 6-What is the best way to complete this solution? Thanks for reading to this line. I hope you can help me. thanks again. Best Regards Ahmed Gaser FCSIS IS Dept.
-
Dear friends: My team has the following task to complete.A solution that consists of 3 projects : 1-Win app that connected to a local DB server(SQL server) . 2-Web app that connected to a remotre server(SQL server). 3-Mobile app for that connected to tha same remote server of the web app. The Details: 1-The win app deals with a DB(Local DB SQL server) for updating ,retriving,inserting and deleting. 2-The web & the mobile app deal with a DB(Remote DB SQL server) for tha same purpose.(updating ,retriving,inserting and deleting) The Goal: 1-The Win app will connect one time per day to update the Remote SQL server with the new data from the Local SQL server. 2-The Web and mobile app connected to the Remote SQL server will update ,retrieve ,delete and insert records in it. The Questions: 1-If I can use Asp.net web services ,How can I use it? 2-How can i make daily transaction to update the Remote SQL server with the new data at the Local SQL server?? 3-How can i make daily transaction to update the Local SQL server with the new data at Remote SQL server ?? 4-How can i manage the DB Transactions ? 5-how can i use the same methods(code) for dealing with the DB ,for the win app , the web app and the mobile app? 6-What is the best way to complete this solution? Thanks for reading to this line. I hope you can help me. thanks again. Best Regards Ahmed Gaser FCSIS IS Dept.
Without going into details, .NET will provide you a complete solution, search the forum, similar questions like this has been asked when .NET was relatively new. leppie::AllocCPArticle("Zee blog");
Seen on my Campus BBS: Linux is free...coz no-one wants to pay for it. -
Dear friends: My team has the following task to complete.A solution that consists of 3 projects : 1-Win app that connected to a local DB server(SQL server) . 2-Web app that connected to a remotre server(SQL server). 3-Mobile app for that connected to tha same remote server of the web app. The Details: 1-The win app deals with a DB(Local DB SQL server) for updating ,retriving,inserting and deleting. 2-The web & the mobile app deal with a DB(Remote DB SQL server) for tha same purpose.(updating ,retriving,inserting and deleting) The Goal: 1-The Win app will connect one time per day to update the Remote SQL server with the new data from the Local SQL server. 2-The Web and mobile app connected to the Remote SQL server will update ,retrieve ,delete and insert records in it. The Questions: 1-If I can use Asp.net web services ,How can I use it? 2-How can i make daily transaction to update the Remote SQL server with the new data at the Local SQL server?? 3-How can i make daily transaction to update the Local SQL server with the new data at Remote SQL server ?? 4-How can i manage the DB Transactions ? 5-how can i use the same methods(code) for dealing with the DB ,for the win app , the web app and the mobile app? 6-What is the best way to complete this solution? Thanks for reading to this line. I hope you can help me. thanks again. Best Regards Ahmed Gaser FCSIS IS Dept.
Hmmmm... This sounds suspiciously like a class project.... Some pointers - You'll have to do the grunt work yourself... 1. If you have the ability to use ASP.NET WebServices then you can use them to abstract your business logic what ever that happens to be in the context of this project. 2 & 3: Look for information on replication. Data publishers and data subscribers. 4. That depends on what you mean by "manage"... My own belief is to use stored procedures to manage all access to the database. 5. See 4 6. That is very vague. What are your priorities? --Colin Mackay--