SQL异常未处理,用户sa登录失败
本文关键字:sa 登录 失败 用户 异常 未处理 SQL | 更新日期: 2023-09-27 18:03:36
用户sa登录失败
我一直在与sqlserver连接的。net c#项目上工作,我一直得到这个错误。"sql异常未处理",用户sa登录失败,这是我的代码。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace FrontOffice
{
public class dblayer
{
#region DB Variables
SqlConnection con = new SqlConnection("server=localhost;uid=sa;pwd=multi;database=officedb");
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adp = new SqlDataAdapter();
public SqlConnection con1 = new SqlConnection("server=localhost;uid=sa;pwd=multi;database=officedb");
SqlDataReader rdr;
#endregion
SqlConnection opencon()
{
if (con.State == ConnectionState.Closed)
con.Open();
return con;
}
public SqlConnection Connect()
{
SqlConnection tempcon = new SqlConnection("server=localhost;uid=sa;pwd=multi;database=officedb");
tempcon.Open();
return tempcon;
}
#region Insert functions
public bool newVisitorAdd(string name,string gender,string nation,string phone,string place,string catogory,string empid,string message)
{
cmd = new SqlCommand("exec visitadd @name,@gender,@nation,@phone,@place,@vcat,@empid,@message,@date,@time ",opencon());
cmd.Parameters.AddWithValue("@name", (object)name);
cmd.Parameters.AddWithValue("@gender", (object)gender);
cmd.Parameters.AddWithValue("@nation", (object)nation);
cmd.Parameters.AddWithValue("@phone", (object)phone);
cmd.Parameters.AddWithValue("@place", (object)place);
cmd.Parameters.AddWithValue("@vcat", (object)catogory);
cmd.Parameters.AddWithValue("@empid", (object)empid);
cmd.Parameters.AddWithValue("@message", (object)message);
cmd.Parameters.AddWithValue("@date", (object)DateTime.Now.ToShortDateString());
cmd.Parameters.AddWithValue("@time", (object)DateTime.Now.ToShortTimeString());
int dd = cmd.ExecuteNonQuery();
if (dd >= -1)
{
return true;
}
else
return false;
}
public bool newvisitorimg(List<string> imglst, string name)
{
try
{
foreach (string img in imglst)
{
cmd = new SqlCommand("insert into imgtb values('" + img + "','" + name + "')",opencon());
cmd.ExecuteNonQuery();
}
return true;
}
catch { return false; }
}
#endregion
public SqlDataReader ExecuteReader(string qry)
{
try
{
cmd = new SqlCommand(qry, opencon());
rdr = cmd.ExecuteReader();
return rdr;
}
catch { return rdr; }
}
}
}
任何帮助都将是感激的,提前感谢!
SA账号是否启用?如果您使用标准安装,我相信默认情况下是不启用它并使用Windows身份验证,在这种情况下,您可以更改连接字符串以使用Windows身份验证或使用管理工作室登录SQL并启用sa帐户。
你可能还想创建一个全局const变量来保存连接字符串,这样你就不用多次/多次更改