如下:写上这些代码时param = new SqlParameter("@u", Login1.UserName);这一句的Login.UserName提示未定义,在login控件里已经把UserName文本控件的Group设置成Login1了,不知道为什么不能获取用户名,密码也一样,求高手解决,急用!!!protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
string str = WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select count(*) from login where username = @u and password = @p";
SqlParameter param;
param = new SqlParameter("@u", Login1.UserName);
cmd.Parameters.Add(param);
param = new SqlParameter("@p",Login1.Password);
cmd.Parameters.Add(param);
int n = (int)cmd.ExecuteScalar();
conn.Close();
if (n > 0)
e.Authenticated = true;
else
e.Authenticated = false;
{
string str = WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select count(*) from login where username = @u and password = @p";
SqlParameter param;
param = new SqlParameter("@u", Login1.UserName);
cmd.Parameters.Add(param);
param = new SqlParameter("@p",Login1.Password);
cmd.Parameters.Add(param);
int n = (int)cmd.ExecuteScalar();
conn.Close();
if (n > 0)
e.Authenticated = true;
else
e.Authenticated = false;
有提示,提示里没有name或者UserName,感觉是网页配置问题,可能是少了引用吧,不知道该加上什么引用?