Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeshra_279
Starting Member
1 Post |
 Posted - 2009-12-15 : 06:09:21
|
| Hi All, I have created a windows based Hotel Management Application software in VS 2005 .NET (VB .NET) with SQL server 2005 Express as database. Now I have to upgrade this to a centralize server based application. There are 4 hotels located in different places. The application should run on all the 4 PCs and the SQL database will be centralized. i.e. Updates from the database will be available to all the 4 PCs so that user on these respective PCs can understand what is the present state of any room, e.g., vaccant or occupied.For this I need some information from You all for following:1) Do I need to build an ASP.NET based application for this? I mean will it be like a website, which is accessible to all the 4 PCs having internet connection?2) Any other way to create the application, as I already created the windows based in VB .NET ?3) How to create the centralize SQL database?Overall I want to know like, what are the steps involved to create such kind of applications and their requirement?Any links/suggestions/references/tutorials is appriciated.ThanksRaja S. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-12-18 : 16:38:47
|
| I am guessing its winforms ?1. if this is the case, you can install a centralized db and make a connection string in each application to connect to it.2. If its on a network, install sql on the server and create a client connection to the db.Another way to create the application is to use a website, ie instead of winforms use webforms.3. Install MSSQL on a windows server and add your connection string in the web.config file for webformsTutorials www.asp.net/learn for webformsand www.windowsclients.net for winforms and wpf applications |
 |
|
|
|
|
|
SQL Server 2005 & ASP .NET based application.