“/gbdt”应用程序中的服务器错误。
--------------------------------------------------------------------------------FROM 子句语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: FROM 子句语法错误。源错误:
行 38: String selectsql = "select * from user where userId='" + txtUser.Text.Trim() + "'and userPwd='" + txtPwd.Text.Trim() + "'";
行 39: OleDbCommand cmd = new OleDbCommand(selectsql, conn);
行 40: OleDbDataReader reader = cmd.ExecuteReader();行 41: if (reader.Read())
行 42: {
源文件: e:\gbdt\admin_login.aspx.cs 行: 40 堆栈跟踪:
[OleDbException (0x80040e14): FROM 子句语法错误。]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +65
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +181
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +307
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +77
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +188
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +122
System.Data.OleDb.OleDbCommand.ExecuteReader() +26
admin_login.btnSubmit_Click(Object sender, EventArgs e) in e:\gbdt\admin_login.aspx.cs:40
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +96
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +116
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3837
--------------------------------------------------------------------------------FROM 子句语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: FROM 子句语法错误。源错误:
行 38: String selectsql = "select * from user where userId='" + txtUser.Text.Trim() + "'and userPwd='" + txtPwd.Text.Trim() + "'";
行 39: OleDbCommand cmd = new OleDbCommand(selectsql, conn);
行 40: OleDbDataReader reader = cmd.ExecuteReader();行 41: if (reader.Read())
行 42: {
源文件: e:\gbdt\admin_login.aspx.cs 行: 40 堆栈跟踪:
[OleDbException (0x80040e14): FROM 子句语法错误。]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +65
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +181
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +307
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +77
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +188
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +122
System.Data.OleDb.OleDbCommand.ExecuteReader() +26
admin_login.btnSubmit_Click(Object sender, EventArgs e) in e:\gbdt\admin_login.aspx.cs:40
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +96
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +116
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3837
select * from [user].......