vs2010 Escribir código del botón de inicio de sesión
string sql = "select * from bs_appuser t donde t.appuser_cd='" TextBox1.Text.ToUpper().Trim() "' and t.passwordhash_tx='"
FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox2.Text, "MD5") "'";
OracleConnection con = new OracleConnection(strConn);
con.Open(); p> OracleCommand cmd = new OracleCommand(sql, con);
OracleDataReader a = cmd.ExecuteReader();
if (a.Read())
{
cadena User_ID = a[0].ToString();
cadena User_Name = a[1].ToString()
cadena sql2 = "select * from bs_appuserrole t donde t.appuser_id='" User_ID "'";
OracleConnection con1 = new OracleConnection(strConn);
con1.Open();
OracleCommand cmd1 = new OracleCommand(sql2);
OracleDataReader a2 = cmd.ExecuteReader()
if (a2.Read())
{
Sesión["User_ID"] = a2[0];
}
con1.Close(); .Dispose();
Response.Redirect("manageWarehouse.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, Page.GetType(), System.DateTime.Now.Ticks.ToString(), "alert('¡Identidad incorrecta o contraseña incorrecta! ');",
verdadero);
}
con.Close();
con.Dispose();