C#调用SQL数据库,一运行代码就提示在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace another
{
public partial class Form1 : DevExpress.XtraEditors.XtraForm
{
public Form1()
{
InitializeComponent();
SqlConnection lo_conn = new SqlConnection("Server=192.168.1.127;Database=sq1345;uid=LEE;pwd=123");
lo_conn.Open();这里会显示
SqlCommand lo_cmd = new SqlCommand();
lo_cmd.CommandText = "这里是SQL语句";
lo_cmd.Connection = lo_conn;
lo_cmd.ExecuteNonQuery();
SqlDataReader lo_reader = lo_cmd.ExecuteReader();
SqlDataAdapter dbAdapter = new SqlDataAdapter(lo_cmd);
DataSet ds = new DataSet();
dbAdapter.Fill(ds);
lo_conn.Close();
}
}
}