protected void CompanySignUpButton_Click(object sender, EventArgs e) { if (MultiView2.GetActiveView() == CompanySignUp) { MultiView2.SetActiveView(emptyView); } else { MultiView2.SetActiveView(CompanySignUp); } using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("EXEC ListAllCities", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); companyCityList.DataSource = reader; companyCityList.DataTextField = "Name"; companyCityList.DataValueField = "ID"; companyCityList.DataBind(); } using (SqlConnection connection = new SqlConnection(connectionString)) { CompanyDistrictList.Items.Clear(); SqlCommand command = new SqlCommand("EXEC ListAllDistrictsWithCity " + companyCityList.SelectedItem.Value, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CompanyDistrictList.DataSource = reader; CompanyDistrictList.DataTextField = "Name"; CompanyDistrictList.DataValueField = "ID"; CompanyDistrictList.DataBind(); } }
protected void companyCityList_SelectedIndexChanged(object sender, EventArgs e) { using (SqlConnection connection = new SqlConnection(connectionString)) { CompanyDistrictList.Items.Clear(); SqlCommand command = new SqlCommand("EXEC ListAllDistrictsWithCity " + companyCityList.SelectedItem.Value, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CompanyDistrictList.DataSource = reader; CompanyDistrictList.DataTextField = "Name"; CompanyDistrictList.DataValueField = "ID"; CompanyDistrictList.DataBind(); } companysignuppassword1.Attributes.Add("value", password); companysignuppassword2.Attributes.Add("value", password); }