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