C# SQL远程操作

来源：百度知道 编辑：UC知道 时间：2024/06/16 22:53:54
求用C#duiSQL远程操作方法，包括连接和发送命令等。
String strCon = "";

strCon = strCon + @"Data Source=" + "192.168.1.171";
strCon = strCon + @"," + "1433"+";";
strCon = strCon + @"Network Library=" + "TCP/IP"+";";
strCon = strCon + @"Initial Catalog=" + "MYDB"+";";
strCon = strCon + @"User ID=" + "fittest"+";";
strCon = strCon + @"Password=" + "111111"+";";
strCon = strCon + @"Persist Security Info=True";
SqlConnection cn = new SqlConnection(strCon);
cn.Open();

为什么老是提示Network Library值不对？

不都是远程的嘛。。。我还真没对本地进行操作过。。。。
给你个执行连接并执行sql语句的方法吧。
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString)
{
private string connectionString = "server=25.31.24.15;database = icd;uid=sa;pwd=sa"
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException e)