Basic client/server application development

[Niraj Doshi]

Hello Friends, I have developed a desktop application using Windows forms C# as frontend and SQL as backend. But one of my client wants to buy it if the software is able to operate from multiple computers and a common database must be placed on one main computer (server).

Hence I wanted to know, If the already developed application can be configured as client/server application making some minor changes OR should I completely develop a new application.

Secondly, how can I develop a client/server application (any hints or website links would be sufficient). Thank you in advance.

[ThatThatGuy]

This should help

http://www.codeproject.com/KB/IP/TCPIPChat.aspx

[Niraj Doshi]

Hi ThatThatGuy

Thanks for the reply. but I think my task is not too complex. I just need a proper connection strings such that client can access Server Database File.

Thanks

[Joseph Martell]

You can access a SQL Server remotely from multiple clients as long as the clients have a proper connection string. The basic format is this:

"Data Source=[SQL Server name];Initial Catalog=[DB Name];User ID=[username];Password=[password];Application Name=[app name]"

The Application Name parameter is not necessary, but it is useful for any SQL DBAs that are troubleshooting a slow SQL Server.

This will get you connected but there are other considerations as well. I don't know if you are using stored procedures for any of your queries, but you might want to consider it for a client-server set up (for maintenance purposes). Also, make sure none of your queries are locking any tables for a long time because you could cause other users to experience time-outs.