如何根据另一个dropdownlist值填充dropdownbox值.... [英] how to populate dropdownbox value based on another dropdownlist value....

问题描述

使用的代码是这个.... plsss告诉我这个错误...


受保护的void DropDownList2_SelectedIndexChanged(对象发送者，EventArgs e)
{
int countryId = int.Parse(DropDownList1.SelectedIndex.ToString());
DataTable dt = new DataTable();
dt = bindDropDown(从tblcountry中选择countryid，countryname，其中tblcountry.regionid =" + countryId);
DropDownList1.DataSource = dt;
DropDownList1.DataValueField ="countryid";
DropDownList1.DataTextField =国家名称";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0，new ListItem(-Select--"，"0"));

}


公共DataTable bindDropDown(字符串查询)
{
SqlDataAdapter dataAdapter =新的SqlDataAdapter(query，con);
DataSet dataSet =新的DataSet();
dataAdapter.Fill(dataSet);
return(dataSet.Tables [0]);
}
在表单加载事件中

如果(！IsPostBack)
{
DataTable dt1 =新的DataTable();
dt1 = bindDropDown(从tblregion中选择tblregion.regionid，tblregion.regionfullname");
DropDownList2.DataSource = dt1;
DropDownList2.DataTextField ="regionfullname";
DropDownList2.DataValueField ="regionid";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0，new ListItem(-Select--"，"0"));
}

the code is used is this ....plsss tell me the error in this...


protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
int countryId = int.Parse(DropDownList1.SelectedIndex.ToString ());
DataTable dt = new DataTable();
dt = bindDropDown("select countryid,countryname from tblcountry where tblcountry.regionid =" + countryId );
DropDownList1.DataSource = dt;
DropDownList1.DataValueField = "countryid";
DropDownList1.DataTextField = "countryname";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("--Select--", "0"));

}


public DataTable bindDropDown(string query)
{
SqlDataAdapter dataAdapter = new SqlDataAdapter(query,con);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
return (dataSet.Tables[0]);
}
in the form load event

if (!IsPostBack)
{
DataTable dt1 = new DataTable();
dt1 = bindDropDown("select tblregion.regionid,tblregion.regionfullname from tblregion");
DropDownList2.DataSource = dt1;
DropDownList2.DataTextField = "regionfullname";
DropDownList2.DataValueField = "regionid";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, new ListItem("--Select--", "0"));
}

推荐答案

浏览 ^ ].
此 [

Go through Populate Cascading DropDownList Based On Selection Of Other ASP.NET[^].
This[^] may also be useful to you.

这篇关于如何根据另一个dropdownlist值填充dropdownbox值....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！