Asp按钮没有触发 [英] Asp button is not firing
问题描述
嗨朋友
i在一个管理文件夹里面有一个adminlogin页面,不在根目录中
in adminlogin.aspx页面有登录表单(NOT LOGIN TOOLBOX)有一个名为Signin的按钮如果我点击登录按钮就会出现错误:
错误:语法附近不正确'', ''。
即使没有触发按钮
请求帮助我
我应该在管理员内部需要两个webconfig文件文件夹?
我的登录按钮代码
瘦LoginButton在admin文件夹中不在根目录下的页面是login.aspx
hi friends
i have a adminlogin page inside a admin folder not in root directory
in adminlogin.aspx page there is login form ( NOT LOGIN TOOLBOX) there a button called Signin if i click the signin button am getting a error:
ERROR : Incorrect Syntax near'',''.
the even is not firing in button
pleas help me
should i need two webconfig file inside admin folder?
my login Button Code
thin LoginButton is in admin folder not in root directory the page is login.aspx
protected void btnLog_Click(object sender, EventArgs e)
{
String constr = ConfigurationManager.ConnectionStrings["MyProject"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
string sql;
sql = "SELECT UserName,Password from tblLogin where UserName= '" + txtU.Text + "', Password ='" + txtP.Text + "'";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("@UserName", txtU.Text);
cmd.Parameters.AddWithValue("@Password", txtP.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
//Session.Timeout = 60;
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Response.Redirect("~/admin/MainPage.aspx");
}
else
{
Response.Write("Login failed");
}
}
推荐答案
嗨sreeCoderMan,
请更新您的查询专线
Hi sreeCoderMan,
Please update your query line
string sql;
sql = "SELECT UserName,Password from tblLogin where UserName= '" + txtU.Text + "', Password ='" + txtP.Text + "'";
with
with
string sql;
sql = "SELECT UserName,Password from tblLogin where UserName= '" + txtU.Text + "' AND Password ='" + txtP.Text + "'";
您的查询应如下所示
You query should be like below
sql = "SELECT UserName,Password from tblLogin where UserName= @UserName and Password =@Password";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("@UserName", txtU.Text.Trim());
cmd.Parameters.AddWithValue("@Password", txtP.Text.Trim());
谢谢
Thanks
hi,
问题出现在这一行上
the problem is on this line
sql = "SELECT UserName,Password from tblLogin where UserName= '" + txtU.Text + "', Password ='" + txtP.Text + "'";
你的callling select语句格式不正确。
选择查询是这样的..
your callling select statement that is not correct format.
the select query is like this..
select * from table_name where col_name=condition1 and col_name=condition2
但在您的选择查询中而不是和您的使用(,)。
but in your select query instead of and your using (,).
这篇关于Asp按钮没有触发的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!