hi i have 3 drop down list in my page1ddlzone12ddldistrict13ddlstore1this is ddlzone1 code protected void DDLzone1SelectedIndexChangedobject sender EventArgs e DDLstore1ItemsClear DDLstore1ItemsAddnew ListItem34select center34 3434 DDLstore1AppendDataBoundItems true SqlCommand cmd new SqlCommand34selectcenter34 cn cmdCommandType CommandTypeStoredProcedure cmdParametersAddWithValue34Re

You must create methods for each dropdownlist and call them on the SelectedIndexChanged event protected void DDLzone1SelectedIndexChangedobject sender EventArgs e BindRegion BindDistrict private static void BindRegion DDLstore1ItemsClear DDLstore1ItemsAddnew ListItem34select center34 3434 DDLstore1AppendDataBoundItems true SqlCommand cmd new SqlCommand34selectcenter34 cn cmdCommandType CommandTypeStoredProcedure cmdParametersAddWithValue34RegionID34 DDLzone1SelectedItemValue try cnOpen DDLstore1DataSource cmdExecuteReader DDLstore1DataTextField 34Centername34 DDLstore1DataValueField 34ID34 DDLstore1DataBind catch Exception ex throw ex finally cnClose

Populate multiple Cascading DropDownList on selection on main DropDownList ASP.Net

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Aug 12, 2012 11:50 PM
Forum: ASP.Net Web Forms
Answer: 1
Views: 2557

i have 3 drop down list in my page

1-ddlzone1

2-ddldistrict1

3-ddlstore1

this is ddlzone1 code

 protected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e)
    {

        DDLstore1.Items.Clear();
        DDLstore1.Items.Add(new ListItem("select center", ""));
        DDLstore1.AppendDataBoundItems = true;
        SqlCommand _cmd = new SqlCommand("selectcenter", _cn);
        _cmd.CommandType = CommandType.StoredProcedure;
        _cmd.Parameters.AddWithValue("@RegionID", DDLzone1.SelectedItem.Value);
        try
        {
            _cn.Open();
            DDLstore1.DataSource = _cmd.ExecuteReader();
            DDLstore1.DataTextField = "Centername";
            DDLstore1.DataValueField = "ID";
            DDLstore1.DataBind();


        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            _cn.Close();
            _cn.Dispose();
        }
    }

here when users select item from ddlzone1 ,ddlstore1 value will be change now

i want when users select item from ddlzone1 both ddl 1-ddlstore1 and 2-ddldistrict1 value will be change

how i can do it?

and this is sP

create procedure  dbo.selectdistrict

@RegionID varchar(5)
as
begin
select ID,District
from District
where RegionID=@RegionID
group by ID,District
end

Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Aug 12, 2012 11:51 PM
Report

You must create methods for each dropdownlist and call them on the SelectedIndexChanged event

    protected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindRegion();
        BindDistrict();
    }

    private static void BindRegion()
    {
        DDLstore1.Items.Clear();
        DDLstore1.Items.Add(new ListItem("select center", ""));
        DDLstore1.AppendDataBoundItems = true;

        SqlCommand _cmd = new SqlCommand("selectcenter", _cn);
        _cmd.CommandType = CommandType.StoredProcedure;
        _cmd.Parameters.AddWithValue("@RegionID", DDLzone1.SelectedItem.Value);
        try
        {
            _cn.Open();
            DDLstore1.DataSource = _cmd.ExecuteReader();
            DDLstore1.DataTextField = "Centername";
            DDLstore1.DataValueField = "ID";
            DDLstore1.DataBind();

        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            _cn.Close();
            _cn.Dispose();
        }
    }
    private static void BindDistrict()
    {
        DDLdistrict1.Items.Clear();
        DDLdistrict1.Items.Add(new ListItem("select district", ""));
        DDLdistrict1.AppendDataBoundItems = true;

        SqlCommand _cmd = new SqlCommand("selectdistrict", _cn);
        _cmd.CommandType = CommandType.StoredProcedure;
        _cmd.Parameters.AddWithValue("@RegionID", DDLzone1.SelectedItem.Value);
        try
        {
            _cn.Open();
            DDLdistrict1.DataSource = _cmd.ExecuteReader();
            DDLdistrict1.DataTextField = "District";
            DDLdistrict1.DataValueField = "ID";
            DDLdistrict1.DataBind();

        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            _cn.Close();
            _cn.Dispose();
        }
    }

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Populate multiple Cascading DropDownList on selection on main DropDownList ASP.Net

Company

Explore

Follow us

Contact Us