如何将DropdownList绑定到另一个DropdownList [英] How to Bind the DropdownList to another DropdownList

问题描述

亲爱的朋友们，



祝你有个美好的一天!!



我有两个DROPDOWNLISTS Webform和我想要彼此绑定。



假设我从大学下拉列表中选择CollegeName ...而另一个应该显示该特定学院的部门。

请你建议我怎么做？

谢谢ADVANCE。

Dear Friends,

Have a Good Day !!

I have Two DROPDOWNLISTS on my Webform and I want to Bind Each Other.

Suppose if I select CollegeName from College Dropdownlist...and the Other one Should Display the Departments of that Particular College.
Please can u suggest me how to do this ?
Thanks in ADVANCE.

推荐答案

你可以实现它在很多方面：

1）AJAX Control Toolkit中存在的级联下拉延伸器或

2）带回发的简单C＃代码

3）XML HTTP要求

4）使用jquery



查看以下链接：



http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/CascadingDropDown/CascadingDropDown.aspx [ ^ ]



http://csharpdotnetfreak.blogspot.com/2009/03/populate-dropdown-based-selection-other.html [ ^ ]



http：//www.dotnetcurry .com / ShowArticle.aspx?ID = 417 [ ^ ]



http：// code。 msdn.microsoft.com/CSASPNETCascadingDropDownLi-0a3f1ecf [ ^ ] <小时EF = http://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in-ASP.Net.aspx> http://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in- ASP.Net.aspx [ ^ ]

You can implement it in many ways:
1) Cascading Dropdown Extender present in AJAX Control Toolkit or
2) Simple C# code with postback
3) XML HTTP Request
4) Using jquery

Look in following links:

http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/CascadingDropDown/CascadingDropDown.aspx[^]

http://csharpdotnetfreak.blogspot.com/2009/03/populate-dropdown-based-selection-other.html[^]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=417[^]

http://code.msdn.microsoft.com/CSASPNETCascadingDropDownLi-0a3f1ecf[^]http://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in-ASP.Net.aspx[^]

嗨Ranjeet，



我相信你已经完成了一切正确的事情缺少一些愚蠢的点。

请按照以下步骤操作我希望能解决您的问题

a）将数据库中的大学字段与大学下拉列表绑定。

ex

数据集retCollegeName = objDAL.FillCmbCollegeName（objDataset）;

cmbCollegeNAme.DataSource = retCollegeName.Tables [CollegeName];

cmbCollegeNAme.DataTextField =Name;

cmbCollegeNAme.DataValueField =OrderSeq;

cmbCollegeNAme.DataBind（）;

b）转到cm的性质bCollegeNAme并设置auto postback = true;

c）调用查询从cmbCollegeNAme.SelectedIndexChanged获取上面定义的部门，并以与上面相同的方式填充Department下拉列表。



希望这能解决你的问题

谢谢

Amit Dutta

Hi Ranjeet,

I am sure u have done every thing right just you are missing few silly points.
Please follow the steps below i hope that will solve your problem
a) Bind the college dropdown with college fields in database.
ex
dataset retCollegeName = objDAL.FillCmbCollegeName(objDataset);
cmbCollegeNAme.DataSource = retCollegeName.Tables["CollegeName"];
cmbCollegeNAme.DataTextField = "Name";
cmbCollegeNAme.DataValueField = "OrderSeq";
cmbCollegeNAme.DataBind();
b) go to property of cmbCollegeNAme and set auto postback = true;
c) call a query to fetch department as same defined above from cmbCollegeNAme.SelectedIndexChanged and populate the Department dropdown in the same way as above.

Hope this will solve your problem
Thanks
Amit Dutta

试试这个：

使自动回发成为大学课程下载的真实属性。

Try This :
make auto postback true Property for College Dropdown.

       if (!IsPostBack)
       {
          FillDropDownList();

        }

 private void FillDropDownList()
    {
        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("Select college  FROM tablename",connection object);
        myda.Fill(ds);
        drop_college.DataSource = ds;
        drop_college.DataValueField = "college";
        drop_college.DataBind();
        drop_college.Items.Insert(0, new ListItem("Select", "0"));
    }


then after double click on college Dropdown.

 protected void drop_college_SelectedIndexChanged(object sender, EventArgs e)
    {
       
        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("Select department FROM tablename where college='"+drop_college.SelectedItem.Value+"'", connection object);
        myda.Fill(ds);
        drop_department.DataSource = ds;
        drop_department.DataValueField = "department";
        drop_department.DataBind();
        drop_department.Items.Insert(0, new ListItem("Select", "0"));
       
    }

Hope this will help You.

这篇关于如何将DropdownList绑定到另一个DropdownList的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！