如何从数据库中检查用户名和密码.我必须通过开关盒打开老师，管理员，父母的页面 [英] how to check userid and password from database.i have to open a page of teacher,admin,parent through switch case

问题描述

how to check userid and password from database.i have to open a page of teacher,admin,parent through switch case

my code is here:................

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con;
    SqlDataReader dr;
    SqlDataReader dr1,dr2;
    SqlDataAdapter da;
    SqlCommand sqlcomm;
    string username;
    string password;
    protected void Page_Load(object sender, EventArgs e)
    {
        string str = (string)ConfigurationManager.AppSettings["connectionstring"];
        con = new SqlConnection(str);
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        string s=selected(DropDownList1.SelectedValue);
        string p="select username,password from login where type="+ s +"";
        sqlcomm = new SqlCommand(p,con);
        dr=sqlcomm.ExecuteReader();
        if (dr.Read())
        {
            username = dr1.GetString(0);
            password = dr2.GetString(1);
            if ((TextBox0.Text == username)&&(TextBox1.Text==password))
            {
                Server.Transfer("Admin.aspx");
                switch ()
                {
                    case "Admin":
                        return "Admin.aspx";
                    case "Parent":
                        return "Parent.aspx";
                    case "Teacher":
                        return "Teacher.aspx";
                    default:
                        return "zero";

                }
            }
        \
        }
       
    }
    public string selected(string i)
    {

        switch (i)
        {
            case "Admin":
                return "Admin";
            case "Parent":
                return "Parent";
            case "Teacher":
                return "Teacher";
            default :
                return "zero";
          
        }
    }
}

推荐答案

尝试为

if ((TextBox0.Text == username)&&(TextBox1.Text==password))
            {
               
                switch (s)
                {
                    case "Admin":
                         Server.Transfer("Admin.aspx");
                    case "Parent":
                         Server.Transfer("Parent.aspx");
                    case "Teacher":
                        Server.Transfer("Teacher.aspx");
                    default:
                        return "zero";
 
                }
            }

con.Open();
字符串s = selected(DropDownList1.SelectedValue);
字符串p =选择用户名，从登录名输入密码，其中type =''" + s +''";
sqlcomm =新的SqlCommand(p，con);
dr = sqlcomm.ExecuteReader();
如果(dr.Read())
{
用户名= dr.GetString(0);
密码= dr.GetString(1);
如果((TextBox0.Text ==用户名)&&(TextBox1.Text ==密码))
{
开关
{
案例管理员":
Server.Transfer("Admin.aspx");
休息；
案例父母":
Server.Transfer("Parent.aspx");
休息；
案例老师":
Server.Transfer("Teacher.aspx");
休息；


}

}
其他
{
Label1.Text =无效的登录名";
Label1.Visible = true;
}

}

con.Open();
string s=selected(DropDownList1.SelectedValue);
string p="select username,password from login where type=''"+ s +"''";
sqlcomm = new SqlCommand(p,con);
dr=sqlcomm.ExecuteReader();
if (dr.Read())
{
username = dr.GetString(0);
password = dr.GetString(1);
if ((TextBox0.Text == username) && (TextBox1.Text == password))
{
switch (s)
{
case "Admin":
Server.Transfer("Admin.aspx");
break;
case "Parent":
Server.Transfer("Parent.aspx");
break;
case "Teacher":
Server.Transfer("Teacher.aspx");
break;


}

}
else
{
Label1.Text = "Invalid login";
Label1.Visible = true;
}

}

您可以像
这样编码
从表中选择类型，其中user =''user''和pwd =''pwd'';

然后

if(type =="Admin"
Server.Transfer("Admin.aspx");
反之亦然

you can code like

select type from table where user=''user'' and pwd=''pwd'';

and then

if(type=="Admin"
Server.Transfer("Admin.aspx");
vice versa

这篇关于如何从数据库中检查用户名和密码.我必须通过开关盒打开老师，管理员，父母的页面的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！