C# :如何在局域网中连接sql server2000

注意using System.Data.SqlClient;

string MyConn = "Initial Catalog=Northwind;Data Source="您的局域网服务器名称";User ID=账户名 Password=密码";//定义数据库连接参数
SqlConnection MyConnection = new SqlConnection();//定义一个数据连接实例
MyConnection.ConnectionString = MyConn;
try
{
MyConnection.Open();
MyConnection.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}

数据库服务器在一台机器 WEB服务器在另台机器C#

using System.Data;
using System.Data.SqlClient;

...

string strConnection="user id=用户名;password=密码;";
strConnection+="initial catalog=数据库名;Server=SQL数据库IP地址;";
strConnection+="Connect Timeout=超时时间";

SqlConnection objConnection=new SqlConnection(strConnection);

...

objConnection.Open();