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();
}
