protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { DataSet ak = SqlAC.CheckData("SELECT * FROM Users WHERE Username='******'"); TB_password.Text = ak.Tables[0].Rows[0]["Password"].ToString(); TB_Conforirmpassword.Text = ak.Tables[0].Rows[0]["Password"].ToString(); TB_Email.Text = ak.Tables[0].Rows[0]["Email"].ToString(); TB_FN.Text = ak.Tables[0].Rows[0]["FName"].ToString(); TB_LN.Text = ak.Tables[0].Rows[0]["LName"].ToString(); TB_PN.Text = ak.Tables[0].Rows[0]["Phone"].ToString(); DataSet ds = SqlAC.CheckData("SELECT * FROM Cities"); TB_City.DataSource = ds.Tables[0]; TB_City.DataTextField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataValueField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataBind(); TB_City.Text = ak.Tables[0].Rows[0]["City"].ToString(); } catch (Exception) { Response.Redirect("Home.aspx"); } } }
private void UDDL() { DataSet ds = SqlAC.CheckData("SELECT * FROM Cities"); TB_City.DataSource = ds.Tables[0]; TB_City.DataTextField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataValueField = ds.Tables[0].Columns["City"].ToString(); TB_City.DataBind(); }
/// <summary> /// Reset Button OnClick /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Btn_Reset_MouseClick(object sender, MouseEventArgs e) { Btn_Ok.Enabled = false; TB_FN.Clear(); TB_MI.Clear(); TB_LN.Clear(); CB_Gender.SelectedIndex = -1; TB_Addr1.Clear(); TB_Addr2.Clear(); TB_City.Clear(); TB_State.Clear(); TB_Zip.Clear(); TB_Email.Clear(); TB_Tel.Clear(); hide_time_start.Clear(); hide_time_save.Clear(); hide_back_num.Clear(); }
/// <summary> /// Basic Form Functions: clear /// </summary> private void clear_form() { modify = false; Btn_Ok.Enabled = false; TB_FN.Clear(); TB_MI.Clear(); TB_LN.Clear(); CB_Gender.SelectedIndex = -1; TB_Addr1.Clear(); TB_Addr2.Clear(); TB_City.Clear(); TB_State.Clear(); TB_Zip.Clear(); TB_Email.Clear(); TB_Tel.Clear(); lstItems.SelectedItems.Clear(); hide_time_start.Clear(); hide_time_save.Clear(); hide_back_num.Clear(); }