Server and clinet interaction to transfer the data using SQL server 2005..

Vidyadhar K

Hello folks,

I am developing an application using windows forms in Visual Studio 2005 using language C#.

My application needs an interaction between a server and several client machines. I need to make my application to transfer the data entered in client machine sholud be stored in the database of the server machine.

How can i accomplish this task using SQL server 2005? is it possible through win Forms or i need to build ASP.net web page? I have less knowledge in ASP. So can u help me in this regard?

Thank u all 4 support.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vidyadhar K18y ago
Hi Scott, Thank you for ur precious reply..

I have worked with SQL server, I have updated my database locally.. the problem arising when i try to update a data entered in a client machine to the database of Server machine.

I have tried many ways to do it, Iv even reinstalled my SQL server 2005. I have tried the following codes-

string conn= "server=computername;Database=mydatabase;Integrated Security=true"; [or]

string conn= "server=computername;Database=mydatabase;User ID=sa;Password=123"; [or]

string conn= "server=IP address;Database=mydatabase;User ID=sa;Password=123";

But m getting errors.

tcan anyone tell me the excact procedure to solve this problem?

can anyone send me the code snippet for Window form application using C#?

Thanks all..
Scott Lysle18y ago
You can work with SQL Server 2005 in either a win forms or a web application; you might start by taking a look at the Microsoft ADO.NET overview: http://msdn.microsoft.com/en-us/library/h43ks021.aspx