求大神帮我看看哪里出问题了。

[qq_35635176]

FROM 子句语法错误。

说明: 执行当前 Web 请求期间，出现未经处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.OleDb.OleDbException: FROM 子句语法错误。

源错误:


行 17: cmd.Parameters.AddWithValue("@密码", this.t2.Text);
行 18: conn.Open();
行 19: OleDbDataReader rd = cmd.ExecuteReader();
行 20: if (rd.Read())
行 21: {

源文件: c:\Users\Administrator\Desktop\aspppppppppp\Sign in.aspx 行: 19

堆栈跟踪:


[OleDbException (0x80040e14): FROM 子句语法错误。]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1138392
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +247
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +208
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +162
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +110
System.Data.OleDb.OleDbCommand.ExecuteReader() +11
ASP.sign_in_aspx.b1_Click(Object sender, EventArgs e) in c:\Users\Administrator\Desktop\aspppppppppp\Sign in.aspx:19
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9696694
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +204
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +12
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +15
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1639

[qq_35635176]

<%@ Page Language="C#" Debug="true" %> <%@ Import Namespace="System.IO" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat="server"> protected void b1_Click(object sender, EventArgs e) { string 用户名 = t1.Text; string 密码 = t2.Text; if ((用户名 != "") && (密码 != "")) { OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_data/information.mdb")); string strSql = "select * from user where 用户名=@用户名 and 密码=@密码"; OleDbCommand cmd = new OleDbCommand(strSql, conn); cmd.Parameters.AddWithValue("@用户名", this.t1.Text); cmd.Parameters.AddWithValue("@密码", this.t2.Text); conn.Open(); OleDbDataReader rd = cmd.ExecuteReader(); if (rd.Read()) { Session["UserName"] = 用户名; Response.Redirect("Main.aspx"); } else { Label2.Text = "用户名或密码错误！"; } } } </script>

[EnForGrass]

user是关键字，改成这样试试

   string strSql = "select * from [user] where 用户名=@用户名 and 密码=@密码";

[fleetingevent]

引用 2 楼 Chinajiyong 的回复:

user是关键字，改成这样试试

   string strSql = "select * from [user] where 用户名=@用户名 and 密码=@密码";

求问啊。。我是mysql也想这么做登录 为什么查询数据库为空

 string TPassword = txtPass.Text.Trim();
            string sql = "select * from users where Name='@HAName' and Password='@HAPassword'";
            MySqlCommand cmd = new MySqlCommand(sql, con);
            cmd.Parameters.AddWithValue("@HAName", "TName");
            cmd.Parameters.AddWithValue("@HAPassword", "TPassword");