using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ } protected void Button1_Click(object sender, EventArgs e)
{
string username = TBX_Username.Text.Trim();
string password = TBX_Pass.Text.Trim();
string type = DropDownList1.Text.Trim();
string temp =@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\wgl\Documents\stuorg.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
string sql = "select * from Login where Username='" + username + "' and Password='" + password + "'and Type='" + type + "'";
OleDbConnection conn = new OleDbConnection(temp);
conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Session["Username"] = username;
Session["Password"] = password;
if (type == "0")
{
Response.Redirect("系统管理员.aspx");
}
else if(type == "1")
{
Response.Redirect("普通用户视图.aspx");
}
}
else
{
Response.Write("<script language='javascript'>alert('用户名或密码错误!');location='login.aspx' </script>"); }
}
protected void TBX_Username_TextChanged(object sender, EventArgs e)
{ }
protected void TBX_Pass_TextChanged(object sender, EventArgs e)
{}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{}
}
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ } protected void Button1_Click(object sender, EventArgs e)
{
string username = TBX_Username.Text.Trim();
string password = TBX_Pass.Text.Trim();
string type = DropDownList1.Text.Trim();
string temp =@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\wgl\Documents\stuorg.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
string sql = "select * from Login where Username='" + username + "' and Password='" + password + "'and Type='" + type + "'";
OleDbConnection conn = new OleDbConnection(temp);
conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Session["Username"] = username;
Session["Password"] = password;
if (type == "0")
{
Response.Redirect("系统管理员.aspx");
}
else if(type == "1")
{
Response.Redirect("普通用户视图.aspx");
}
}
else
{
Response.Write("<script language='javascript'>alert('用户名或密码错误!');location='login.aspx' </script>"); }
}
protected void TBX_Username_TextChanged(object sender, EventArgs e)
{ }
protected void TBX_Pass_TextChanged(object sender, EventArgs e)
{}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{}
}
AccessDatabaseengine