protected void btn_Click(object sender, EventArgs e) { try { String pass = EncodePassword(password.Text); Connect_SQL sql = new Connect_SQL(); var param = new List <Tuple <string, string> >(); param.Add(Tuple.Create("@name", user.Text)); param.Add(Tuple.Create("@pass", pass)); String query = "select_Account"; if (sql.Get_Data(query, param).Rows.Count > 0) { Session["login"] = 1; Response.Redirect("Form_Main.aspx"); } else { Session["login"] = null; lblCheck.Text = "Incorrect username or password"; } } catch (NullReferenceException) { lblCheck.Text = "Connect to Database fail"; } }
public DataTable Select_Customer(String id) { try { var param = new List <Tuple <string, string> >(); param.Add(Tuple.Create("@id", id)); String query = "Select_Customer"; dt = sql.Get_Data(query, param); count_row = dt.Rows.Count; current_row = 0; if (count_row > 0) { Set_Values(); } return(dt); } catch (Exception ex) { throw ex; } }