protected void Button1_Click(object sender, System.EventArgs e)
{
OleDbConnection myconn;
myconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/evit/My Documents/Visual Studio 2005/WebSites/华思维话务系统/App_Data/2007_GN.mdb");
myconn.Open();
string str = "select * from ryinfo where YongHuMC=? and 密码=?";
OleDbCommand cmd;
cmd = new OleDbCommand(str,myconn);
cmd.Parameters.Add("@YongHuMC", TextBox1.Text);
cmd.Parameters.Add("@密码", TextBox2.Text);
OleDbDataReader dr=cmd.ExecuteReader();
if (dr.Read())
{
Session["权限"] = dr["权限"];
if (Session["权限"].ToString()=="0")
{
Response.Redirect("王静.aspx");
}
else if (Session["权限"].ToString()=="1")
{
Response.Redirect("商务部.aspx");
}
}
else
{
labmsg.Text = "口令或用户名错误!";
}
dr.Close();
myconn.Close();
}
{
OleDbConnection myconn;
myconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/evit/My Documents/Visual Studio 2005/WebSites/华思维话务系统/App_Data/2007_GN.mdb");
myconn.Open();
string str = "select * from ryinfo where YongHuMC=? and 密码=?";
OleDbCommand cmd;
cmd = new OleDbCommand(str,myconn);
cmd.Parameters.Add("@YongHuMC", TextBox1.Text);
cmd.Parameters.Add("@密码", TextBox2.Text);
OleDbDataReader dr=cmd.ExecuteReader();
if (dr.Read())
{
Session["权限"] = dr["权限"];
if (Session["权限"].ToString()=="0")
{
Response.Redirect("王静.aspx");
}
else if (Session["权限"].ToString()=="1")
{
Response.Redirect("商务部.aspx");
}
}
else
{
labmsg.Text = "口令或用户名错误!";
}
dr.Close();
myconn.Close();
}
cmd.Parameters.Add("@密码", System.Data.SqlDbType.VarChar,50);
cmd.Parameters.Value["@YongHuMC"]...