C#关联sql数据库提示sa登陆失败,逐步调试最后三句报错。
public void Insert(DataRow dr)
{
string strCon = "Data Source=DESKTOP-MS6MHFA\\SHLI;database=Table_2;uid = sa; pwd = 123456";
SqlConnection con = new SqlConnection(strCon);
try
{
con.Open();
string sql = "insert dataTable(test1,test2) values(" + dr["F"] + "," + dr["F"] + ")";
SqlCommand cmd = new SqlCommand(sql, con);
int row = cmd.ExecuteNonQuery();
}
catch (Exception ex) //单步调试到这,出现报错!
{
throw ex;
}