Client Server Application in C#
-
Hi everybody, I have a small Windows C# distributable application that connects to SQL Compact 2005. The application allows the user to view,insert,update and delete records stored in the database. This is a single user application and I would like to extend it to be a multiuser application. I want the application to be installed on a main machine (which would connect to the database) and have client installations which would perform the operation on the database installed in the main machine. I am new to this subject and I am not sure where to start. I have been looking for a book or samples that would help me achieve this but I haven't been able to find anything. I have been looking for "2-tier applications c#", "client server applications .net", etc. Could somebody guide me in the right direction? Thanks in advance!
-
Hi everybody, I have a small Windows C# distributable application that connects to SQL Compact 2005. The application allows the user to view,insert,update and delete records stored in the database. This is a single user application and I would like to extend it to be a multiuser application. I want the application to be installed on a main machine (which would connect to the database) and have client installations which would perform the operation on the database installed in the main machine. I am new to this subject and I am not sure where to start. I have been looking for a book or samples that would help me achieve this but I haven't been able to find anything. I have been looking for "2-tier applications c#", "client server applications .net", etc. Could somebody guide me in the right direction? Thanks in advance!
Try this http://n-tier.com/articles/csovervw.html[^] http://www.microsoft.com/belux/msdn/nl/community/columns/hyatt/ntier1.mspx[^]
only two letters away from being an asset
-
Hi everybody, I have a small Windows C# distributable application that connects to SQL Compact 2005. The application allows the user to view,insert,update and delete records stored in the database. This is a single user application and I would like to extend it to be a multiuser application. I want the application to be installed on a main machine (which would connect to the database) and have client installations which would perform the operation on the database installed in the main machine. I am new to this subject and I am not sure where to start. I have been looking for a book or samples that would help me achieve this but I haven't been able to find anything. I have been looking for "2-tier applications c#", "client server applications .net", etc. Could somebody guide me in the right direction? Thanks in advance!
Hi man dont worry ya,because of we are in the IT industry. So u can see search in google or yahoo for client server applications tutrioals. may be this is help to u. http://www.codeproject.com/KB/IP/filesharingvb7.aspx[^] http://msdn2.microsoft.com/en-us/library/ms973279.aspx[^] cheers
Cheers,Earn and Enjoy RRave MCTS,MCPD http://ravesoft.blogspot.com
-
Hi everybody, I have a small Windows C# distributable application that connects to SQL Compact 2005. The application allows the user to view,insert,update and delete records stored in the database. This is a single user application and I would like to extend it to be a multiuser application. I want the application to be installed on a main machine (which would connect to the database) and have client installations which would perform the operation on the database installed in the main machine. I am new to this subject and I am not sure where to start. I have been looking for a book or samples that would help me achieve this but I haven't been able to find anything. I have been looking for "2-tier applications c#", "client server applications .net", etc. Could somebody guide me in the right direction? Thanks in advance!
Hi, in client server application, we have to use common Connection String, so that all the client installation can connect with centralized database at Server. so, have you used connection string in your single user application ? if yes then use the connection string of Central server in App.config file so all client installation will point central server database. use the connection string in App.config like, Source=local/(central Server instance name);Initial Catalog=Database Name;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> then use this connection string in your Connection object. so your all database related code will point this central server. try this. :-D
Chirag Patel Programmer Analyst
-
Hi, in client server application, we have to use common Connection String, so that all the client installation can connect with centralized database at Server. so, have you used connection string in your single user application ? if yes then use the connection string of Central server in App.config file so all client installation will point central server database. use the connection string in App.config like, Source=local/(central Server instance name);Initial Catalog=Database Name;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> then use this connection string in your Connection object. so your all database related code will point this central server. try this. :-D
Chirag Patel Programmer Analyst
Thank you for your answer. Yes, I do use a connection string in my application, however I do not store it in App.config. It is contructed at run-time since the localtion of the database depends on where the users decide to install the applications. I will try to move it to App.config. From what you are saying then, my client applications will only have to point to the location of the central server to find the Database and it will work just like if the database was locally installed. Did I understand correctly? Do I need to change my C# code to manage multi-users vs single users? Thank you for you help!