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