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);
}
}
}