Insert Data on Onlinedabase Sql server from local client using C#.net

Question

how to insert Database from local client to online database Sql server 2005 Using C#.
How to connect to online Database Sql server or FTP,TCP using C#.net.

How to do network Programing in C#.net.

Please Understand this Q and Explain Some useful Solution....

Serban Cosmin · Answer

Here is a simple application that connects to a database and retrieves data from it. To connect to the remote database you must replace the Data Source property in the connection string from localhost to whatever the remote server name is ( like: W2K3-SERVER\SQLSERVER2005 ). http://msdn.microsoft.com/en-us/library/dw70f090(VS.71).aspx For an overview of ADO .NET please follow this link http://msdn.microsoft.com/en-us/library/h43ks021(VS.71).aspx and feel free to let me know if you have any problems with these.

jinge · Answer

First you may need to use sql server express or more advanced version of sql server to support remote access. As for how to update the database. You can use ADO.NET to do the job. We simply don't use TCP or Udp like protocals to update the database the details have been abstracted within ADO.NET. You can get some sample code from codefx project.