dropdownlist help

nikita more

I have a booking form for a travel agency where there are two dropdown, one to select the package representing a state and the other to select the subpackages belonging to that state.......... how am i supposed to connect both these dropdown so that when i select a state package from the 1st dropdown list only the respected subpackages of that state package are shown in the other...... also please help me out with the database for this... if any... Thank you.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

kathikeyan Nagaraj8y ago
Its really Simple Use This
DropDownPackage Auto Post back=true
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Package();
}
}
void Package()
{
con.Open();
String str = "Select PackageID,PackageName from Package";
SqlCommand cmd = new SqlCommand(str, con);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DropDownPackage.DataSource = ds;
DropDownPackage.DataTextField = "PackageName";
DropDownPackage.DataValueField = "PackageID";
DropDownPackage.DataBind();
DropDownPackage.Items.Insert(0, new ListItem("Select", "0"));
con.Close();
}
protected void DropDownPackage_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
String str = "Select SubPackageID,SubPackageName from SubPackage where MainPackageID='"+DropDownPackage.Selectedvalue+"'"; //You Must have Main Package ID in SubPackage Note Else Create it....
SqlCommand cmd = new SqlCommand(str, con);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DropDownSubPackage.DataSource = ds;
DropDownSubPackage.DataTextField = "SubPackageName";
DropDownSubPackage.DataValueField = "SubPackageID";
DropDownSubPackage.DataBind();
DropDownSubPackage.Items.Insert(0, new ListItem("Select", "0"));
con.Close();
}
Piyush Pansuriya8y ago
Hi,
Go through the below link:

https://www.aspsnippets.com/Articles/AJAX-Cascading-DropDown-Example-in-ASPNet.aspx
Manav Pandya8y ago
Hello

For than you can use server side control and methods for that

Like :

1 . Bind first drop down onload event

2 . Than when user selects value from first dropdown , than get value on dropdown_selectedchange() event

3 . Based on first value bind 2nd dropdown based on first fropdown selecttion

That is the simple scenario i have use

For reference you can go through some links :

https://www.aspsnippets.com/Articles/Cascading-DropDownList-for-CountryStateCity-in-ASPNet.aspx

https://www.aspsnippets.com/Articles/Creating-Cascading-DropDownLists-in-ASP.Net.aspx

https://www.c-sharpcorner.com/UploadFile/009464/cascading-one-dropdownlist-with-other-dropdownlist-in-asp-ne/

Just try to understand mechanism , and implement it

Thanks