ASP.NET_登录例子

来源:互联网 发布:淘宝的alexa排名是多少 编辑:程序博客网 时间:2024/05/16 04:17

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

using System.Text.RegularExpressions;

using System.Windows.Forms;

 

 

//.net Login方法例子;

protected void Button1_Click(object sender, EventArgs e)

        {

            Session["name"] = tname.Text;

            if (!rb1.Checked & !rb2.Checked) //radiocheckbox 1.2

            {

                MessageBox.Show("请选择用户身份");

            }

            else if (rb1.Checked)

            {

                string cmdtext = "select * from Gltable where userName='" + this.tname.Text +"' and passWord='" + this.tpass.Text + "'";  //数据搜索语句;

                SqlConnection con =new SqlConnection("Server=localhost;database=qcwx;uid=sa;pwd=sasasa");

                con.Open();

                SqlCommand cmd =new SqlCommand(cmdtext, con);

                try

                {

                    SqlDataReader dr = cmd.ExecuteReader();

                    if (dr.Read())

                    {

                        MessageBox.Show("登录成功!");

                        sqlconn.Close();

                        Response.Redirect("jmmuban.aspx");//跳转;

                    }

                    else

                    {

                        MessageBox.Show("用户名或密码错误");

                        dr.Close();

                        con.Close();

                    }

                }

                    catch(Exception err)

                    {

                     Response .Write(err); //异常捕获;

                    }

            }

            else  //未选择身份处理;

            {

                string cmdtext1 ="select * from Staff where s_logname='" + this.tname.Text + "' and s_password='" +this.tpass.Text + "'";

                SqlConnection con =new SqlConnection("Server=localhost;database=qcwx;uid=sa;pwd=sasasa");

                con.Open();

                SqlCommand cmd =new SqlCommand(cmdtext1, con);

                try

                {

                    SqlDataReader dr = cmd.ExecuteReader();

                    if (dr.Read())

                    {

 

                        MessageBox.Show("登录成功!");

                        sqlconn.Close();

                        Response.Redirect("user/Usermb.aspx");

 

                    }

                    else

                    {

                        MessageBox.Show("用户名或密码错误");

                        dr.Close();

                        con.Close();

                    }

                }

                catch (Exception err)

                {

                    Response.Write(err);

                }

            }

     }

原创粉丝点击