vs2010 编写登录按钮代码

vs2010 编写登录按钮代码

string sql = "select * from bs_appuser t where t.appuser_cd='" + TextBox1.Text.ToUpper().Trim() + "' and t.passwordhash_tx='"
+ FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox2.Text, "MD5") + "'";
OracleConnection con = new OracleConnection(strConn);
con.Open();
OracleCommand cmd = new OracleCommand(sql,con);
OracleDataReader a = cmd.ExecuteReader();
if (a.Read())
{
string User_ID = a[0].ToString();
string User_Name = a[1].ToString();
string sql2 = "select * from bs_appuserrole t where t.appuser_id='"+ User_ID +"'";
OracleConnection con1 = new OracleConnection(strConn);
con1.Open();
OracleCommand cmd1 = new OracleCommand(sql2);
OracleDataReader a2 = cmd.ExecuteReader();
if (a2.Read())
{
Session["User_ID"] = a2[0];
}
con1.Close();
con1.Dispose();
Response.Redirect("manageWarehouse.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, Page.GetType(), System.DateTime.Now.Ticks.ToString(), "alert('身份不对或密码错误！');", true);
}
con.Close();
con.Dispose();

你是想要登陆功能啊？还是？

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息