Question

异常详细信息: System.Data.SqlClient.SqlException: 用户 'sa' 登录失败

源错误:

行 82: {
行 83: SqlConnection con = new SqlConnection(GetConStr());
行 84: con.Open();
行 85: SqlDataAdapter ada = new SqlDataAdapter(SqlStr, con);
行 86: DataSet ds = new DataSet();

源文件: e:\GameSF\App_Code\GM.cs 行: 84

堆栈跟踪:

[SqlException (0x80131904): 用户 'sa' 登录失败。]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
GM.EXECDataList(DataList dl, String SqlStr, String DNK) in e:\GameSF\App_Code\GM.cs:84
_Default.Page_Load(Object sender, EventArgs e) in e:\GameSF\Default.aspx.cs:17
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Answer 1

呵呵，用户登录失败，肯定是数据集连接代码有问题。建议你vs自带的数据库连接代码：

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=SchoolInfomation;Integrated Security=True");

Data Source=.; 连接本机数据库系统
Initial Catalog=SchoolInfomation; 连接的数据库名称

其它的就不用管了

追问

还是不行，可以QQ在线指导下吗？我把文件发给你
66162507