protected void Page_Load(object sender, EventArgs e) { userGrid.DataSource = ShowUser(); userGrid.DataBind(); ageRangeDropdown.DataSource = ShowAge(); ageRangeDropdown.DataTextField = "text"; ageRangeDropdown.DataValueField = "optionID"; ageRangeDropdown.DataBind(); ageRangeDropdown.Items.Insert(0, new ListItem("", "")); StateDropdown.DataSource = ShowState(); StateDropdown.DataTextField = "text"; StateDropdown.DataValueField = "optionID"; StateDropdown.DataBind(); StateDropdown.Items.Insert(0, new ListItem("", "")); BankusedCheckBoxList.Items.Clear(); using (SqlConnection connection = GetConnection()) { SqlCommand optionCommand = new SqlCommand("SELECT * FROM Options WHERE questionID = 6", connection); //execute into reader SqlDataReader optionReader = optionCommand.ExecuteReader(); while (optionReader.Read()) { //build list items from results ListItem item = new ListItem(optionReader["text"].ToString(), optionReader["ID"].ToString()); BankusedCheckBoxList.Items.Add(item); } BankusedCheckBoxList.DataBind(); } }
public void FillRegisterForm(User user, string takeaction = "save") { FirstNameTextBox.SendKeys(user.FirstName); LastNameTextBox.SendKeys(user.LastName); PasswordTextBox.SendKeys(user.Password); AliasAddressTextBox.SendKeys(user.AliasAddress); AddressTextBox.SendKeys(user.Address); CityTextBox.SendKeys(user.City); ZipCodeTextBox.SendKeys(user.ZipCode); CountryDropdown.SelectByText(user.Country); StateDropdown.SelectByText(user.State); MobilePhoneTextBox.SendKeys(user.MobilePhone); SelectDateOfBirth(user.DateOfBirth); if (takeaction == "save") { RegisterButton.Click(); } }