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)
{
}
}
