RadioButtonList1与button,lable做用户登录界面的问题？

pretty409 2009-03-22 10:00:56

我在做一个系统，首页上要求是有三个权限，学生，教师和管理员，我用radiobuttonlist设了三个权限，想在button按钮里实现选择任何一个时，登录的界面不一样，代码如下： protected void Button1_Click(object sender, EventArgs e)
{
if (RadioButtonList1.Text = "学生")//运行说这有错误，无法将string转换为bool型。求救，我该怎么改
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "data source=.;database=school;uid=sa;pwd=";
string sql = "select *from [student] where sno='" + TextBox1.Text + "' and sname='" + TextBox2.Text + "'and sdept='"+ TextBox3 .Text +"'and spwd='" + TextBox4.Text + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = null;
conn.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["sname"] = dr["sname"].ToString();
Session["sno"] = dr["sno"].ToString();
Response.Write(" <script>alert('登录成功！');location.href='../student/学主页.aspx' </script>");
}
else
{
Response.Write(" <script>alert('登录信息有误！无法登录！') </script>");
}

}
if(RadioButtonList1 .Text ="教师")
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "data source=.;database=school;uid=sa;pwd=";
string sql = "select *from [teacher] where tno='" + TextBox1.Text + "' and tname='" + TextBox2.Text + "'and tdept='" + TextBox3.Text + "'and tpwd='"+TextBox4 .Text +"'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = null;
conn.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.Write(" <script>alert('登录成功！'); </script>");
}
else
{
Response.Write(" <script>alert('登录信息有误！无法登录！') </script>");
}
}
if(RadioButtonList1 .Text ="管理员")
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "data source=.;database=school;uid=sa;pwd=";
string sql = "select *from [admin] where ano='" + TextBox1.Text + "'and ananme='"+ TextBox2 .Text +"'and adept='"+ TextBox3 .Text + "' and apwd='" + TextBox4.Text + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = null;
conn.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.Write(" <script>alert('登录成功！'); </script>");
}
else
{
Response.Write(" <script>alert('登录信息有误！无法登录！') </script>");
}
}

...全文

167 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

pretty409 2009-03-24

打赏
举报

谢谢你的建议！说的很有道理！

Jinglecat 2009-03-24

打赏
举报

1. C# 中判断相等使用 == 两个等号

2. RadioButtonList.Text 实际上是被选中 Item 的 Value，你的 ListItem 的 value 是 “学生“还是 Text 是？

3. 不要这样写 if 浪费 CPU，并且难以出错调试，请用 if-else if-else

if (RadioButtonList1.Text == "学生")
{
}

else if(RadioButtonList1.Text == "教师")
{
}
else if(RadioButtonList1.Text == "管理员")
{
}
else {
throw new Exception("Unkown: " + RadioButtonList1.Text);
}

4. 请确保 Connection 是关闭的，比如使用 using

using(SqlConnection conn = new SqlConnection()) {
conn.ConnectionString = "data source=.;database=school;uid=sa;pwd=";
string sql = "select *from [student] where sno='" + TextBox1.Text + "' and sname='" + TextBox2.Text + "'and sdept='"+ TextBox3 .Text +"'and spwd='" + TextBox4.Text + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = null;
conn.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["sname"] = dr["sname"].ToString();
Session["sno"] = dr["sno"].ToString();
Response.Write(" <script>alert('登录成功！');location.href='../student/学主页.aspx' </script>");
}
else
{
Response.Write(" <script>alert('登录信息有误！无法登录！') </script>");
}
}

5. 同学，你需要掌握的知识太多太多了 .... 先多多看书，再动手吧