protected void Country_Dropdown1_SelectedIndexChanged(object sender, EventArgs e) { try { Int64 CountryId = Convert.ToInt64(Country_Dropdown1.SelectedValue.ToString() == "" ? "0" : Country_Dropdown1.SelectedValue.ToString()); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand("SP_State", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Mode", "SelectStateByCountryId"); cmd.Parameters.AddWithValue("@CountryId", CountryId); da.SelectCommand = cmd; da.Fill(ds); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { State_Dropdown.DataTextField = "StateName"; State_Dropdown.DataValueField = "StateId"; State_Dropdown.DataSource = ds; State_Dropdown.DataBind(); State_Dropdown.Items.Insert(0, new ListItem("---Select State---")); } else { State_Dropdown.DataSource = null; State_Dropdown.DataBind(); State_Dropdown.Items.Insert(0, new ListItem("---Select State---")); } } else { State_Dropdown.DataSource = null; State_Dropdown.DataBind(); State_Dropdown.Items.Insert(0, new ListItem("---Select State---")); } } catch (Exception e2) { Response.Write("Error occured : " + e2.Message.ToString()); } }
private void State_DropdownBind() { try { ds = objInteraction.StateSelectAll(); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { State_Dropdown.DataTextField = "StateName"; State_Dropdown.DataValueField = "StateId"; State_Dropdown.DataSource = ds.Tables[0]; State_Dropdown.DataBind(); State_Dropdown.Items.Insert(0, new ListItem("---Select State---")); } else { State_Dropdown.DataSource = null; State_Dropdown.DataBind(); State_Dropdown.Items.Insert(0, new ListItem("---Select State---")); } } else { State_Dropdown.DataSource = null; State_Dropdown.DataBind(); State_Dropdown.Items.Insert(0, new ListItem("---Select State---")); } } catch (Exception ex) { } }