hi
i have 2 DDL in my page that when users select item from ddldistric1 item in ddlcity1 will change
these are my code
protected void DDLcity1_SelectedIndexChanged(object sender, EventArgs e)
{
BindDistrictC();
}
private void BindDistrictC()
{
ddldistric1.Items.Clear();
ddldistric1.Items.Add(new ListItem("all", ""));
ddldistric1.AppendDataBoundItems = true;
SqlCommand _cmd = new SqlCommand("selectdistrictC", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@City", DDLcity1.SelectedItem.Text);
_cn.Open();
ddldistric1.DataSource = _cmd.ExecuteReader();
ddldistric1.DataTextField = "District";
ddldistric1.DataValueField = "ID";
ddldistric1.DataBind();
_cn.Close();
}
and
SP
ALTER procedure [dbo].[selectdistrictC]
@City nvarchar(30)
as begin
select ID,District from
District where city=@City or @City='0' group by ID,District
end
