Question

“System.Data.SqlClient.SqlException”类型的未经处理的异常在 System.Data.dll 中发生

C#代码如下：using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;namespace StudySystem{ class connect { static string connstr = "Data Source=(local);Initial Catalog=system;User Id=sa;pwd=123"; public static DataSet GetDataset(string sql, string srctable) { SqlConnection conn = new SqlConnection(connstr); SqlCommand com = new SqlCommand(sql, conn); SqlDataAdapter sda = new SqlDataAdapter(com); DataSet ds = new DataSet(); conn.Open(); sda.Fill(ds, srctable); conn.Close(); return ds; } public static int Sqlexcute(string sql) { int count = 0; SqlConnection conn = new SqlConnection(connstr); SqlCommand com = new SqlCommand(sql, conn); conn.Open(); count = com.ExecuteNonQuery(); conn.Close(); return count; } public static bool Panduan(string sql, string psw, string ziduan) { bool ck = false; SqlConnection conn = new SqlConnection(connstr); conn = new SqlConnection("Data Source=(local);Initial Catalog=system;User Id=sa;pwd=123"); SqlCommand com = new SqlCommand(sql, conn); conn.Open(); SqlDataReader sdr = com.ExecuteReader(); if (sdr.Read()) { if (sdr[ziduan].ToString().Trim() == psw) { ck = true; } } conn.Close(); return ck; } }}

Answer 1

在sqlserver服务器端使用sa账号能否登录，如果不能登录则看看服务器的验证方式是window验证还是混合验证，修改为混合验证

追问

SQL SEVER 可以用sa+密码登陆，从别处看的更改服务状态的方法都试过了，没有用