Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
populate dropdownlist from another dropdownlist where each list has AppendDataBoundItems="true
Posted on 2015-02-23
hi Experts,
I have 2 ddls each bound to a sqldatasource; on the first ddl I have set autopostback to true and I'm using the selected index change event to capture the selected value in a session variable which then filters the data in the second ddl.
The Two Bound DDLs:
However I now have a situation where the user is potentially going to select a value which doesn't exist in the sqldatasource and in fact whatever value they select from the first ddl, the data in the second ddl no longer filters, is there a way round this?
The alternative would be to add a checkbox to my form ahead of the ddls so they only show if relevant, I'm just curious to see if this can work without...
many thanks in adv.
I have 2 ddls each bound to a sqldatasource; on the first ddl I have set autopostback to true and I'm using the selected index change event to capture the selected value in a session variable which then filters the data in the second ddl.
The Two Bound DDLs:
<table width="100%" cellspacing="0" cellpadding="8">
<tr valign="middle" align="left" style="background-color: aliceblue;">
<td>Client No:</td>
<td><asp:DropDownList ID="DDLClientNo" DataSourceID="ClientNo" runat="server" OnSelectedIndexChanged="DDLClientNo_SelectedIndexChanged"
AutoPostBack="true" DataTextField="client_ref" DataValueField="client_ref" AppendDataBoundItems="true">
<asp:ListItem Text="n/a" Value="0" />
</asp:DropDownList>
<asp:SqlDataSource ID="ClientNo" ConnectionString="<%$ connectionStrings:xxxxxxxxx %>"
SelectCommand="Select DISTINCT client_ref from matter order by client_ref asc" runat="server"></asp:SqlDataSource>
</td>
<td>Matter Name:</td>
<td><asp:DropDownList ID="DDLMatterName" DataSourceID="MatterName" runat="server"
DataTextField="matter_suffix" DataValueField="matter_suffix" AppendDataBoundItems="true" >
<asp:ListItem Text="n/a" Value="0" />
</asp:DropDownList>
<asp:SqlDataSource ID="MatterName" ConnectionString="<%$ connectionStrings:xxxxxxx %>"
SelectCommand="Select DISTINCT matter_suffix from matter where client_ref=@client_ref order by matter_suffix" runat="server">
<SelectParameters>
<asp:SessionParameter Name="client_ref" SessionField="client_ref" />
</SelectParameters>
</asp:SqlDataSource>
</td></tr></table>
protected void DDLClientNo_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddList = sender as DropDownList;
Session["client_ref"] = ddList.SelectedValue.ToString();
}
However I now have a situation where the user is potentially going to select a value which doesn't exist in the sqldatasource and in fact whatever value they select from the first ddl, the data in the second ddl no longer filters, is there a way round this?
The alternative would be to add a checkbox to my form ahead of the ddls so they only show if relevant, I'm just curious to see if this can work without...
many thanks in adv.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
12
11
23 Comments
Active today
I don't understand your question. Does the DropDownList function correctly, until a value is selected that does not exist in the data source?
It functions correctly until I append the two n/a values; without those it works, with them it doesn't matter what I select in the first ddl, the second one will display all the data, it no longer filters...
Active today
Is this how you are filtering?
<asp:SqlDataSource ID="MatterName" ConnectionString="<%$ connectionStrings:xxxxxxx %>"
SelectCommand="Select DISTINCT matter_suffix from matter where client_ref=@client_ref order by matter_suffix" runat="server">
<SelectParameters>
<asp:SessionParameter Name="client_ref" SessionField="client_ref" />
</SelectParameters>
</asp:SqlDataSource>
Active today
I see where you set the Session parameter here:
Is this value what you need it to be to filter correctly?
Session["client_ref"] = ddList.SelectedValue.ToString();
Is this value what you need it to be to filter correctly?
yes that's correct, so that is picking up the selected value from the first ddl and using it to filter the data of the second, it's a one to many relationship in the database table, so each client_ref has a number of matter_suffix.
Active today
If it is the value that you expect, then what is the impact of this statement?
"they select from the first ddl, the data in the second ddl no longer filters"
That would suggest that the value in the WHERE clause is incorrect.
"they select from the first ddl, the data in the second ddl no longer filters"
That would suggest that the value in the WHERE clause is incorrect.
Well no, the problem only occurs once I append the two additional values (which of course are not within the database) so I am not surprised that at this point the filtering breaks but it has nothing to do with the value in the where clause it is because I am appending onto that an additional value 0. I know this. I don't know if there is a workaround or whether it is simpler to approach differently.
Active today
I still don't understand the issue. If the WHERE clause is correct, and the proper values are returned from the database, are you saying that the DropDownList does not show the correct items?
The code below filters as expected - that works.
The code I posted in the original question which includes the appended list items does not.
The code I posted in the original question which includes the appended list items does not.
<td>Client No:</td>
<td>
<asp:DropDownList ID="DDLClientNo" DataSourceID="ClientNo" runat="server" OnSelectedIndexChanged="DDLClientNo_SelectedIndexChanged"
AutoPostBack="true" DataTextField="client_ref" DataValueField="client_ref">
</asp:DropDownList>
<asp:SqlDataSource ID="ClientNo" ConnectionString="<%$ connectionStrings:xxxxxx%>"
SelectCommand="Select DISTINCT client_ref from matter order by client_ref asc" runat="server"></asp:SqlDataSource>
</td>
<td>Matter No:</td>
<td>
<asp:DropDownList ID="DDLMatterNo" DataSourceID="MatterNo" runat="server" AutoPostBack="true"
DataTextField="matter_suffix" DataValueField="matter_suffix" OnSelectedIndexChanged="DDLMatterNo_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource ID="MatterNo" ConnectionString="<%$ connectionStrings:xxxxxx %>"
SelectCommand="Select matter_suffix from matter where client_ref=@client_ref order by matter_suffix" runat="server">
<SelectParameters>
<asp:SessionParameter Name="client_ref" SessionField="client_ref" />
</SelectParameters>
</asp:SqlDataSource>
</td>
Active today
What is the difference when adding the N/A items?
<asp:ListItem Text="n/a" Value="0" />
Do the data-bound items have value > 0?
<asp:ListItem Text="n/a" Value="0" />
Do the data-bound items have value > 0?
Yes the Databound items are all values >0, the second ddl appears to return a lot more data that without the n/a values, but because I am unfamiliar with the data itself it's quite hard to see what exactly is going on. but whereas prior to the n/a values the second ddl might filter down to just one record - the same selection with the n/a values appended will return 30+ items so it's fairly clear that it isn't filtering as it was.
Active today
"the same selection with the n/a values appended will return 30+ items so it's fairly clear that it isn't filtering as it was."
What is the value for this selection here?
What is the value for this selection here?
Session["client_ref"] = ddList.SelectedValue.ToString();
Active today
Something has to explain why there would be a difference when you add the N/A item, but I haven't seen anything yet, so I can't suggest a different approach, yet...
I did a bit of googling on this and it seems this might be a generic problem with trying to filter ddls with appended data - the last few comments in the link below suggest a possible workaround which I will try but it otherwise looks like a non-starter :
http://weblogs.asp.net/sco
thanks for your help, I will update if I get the workaround to play nicely..
http://weblogs.asp.net/sco
thanks for your help, I will update if I get the workaround to play nicely..
Active today
You might try to add the items in the SqlDataSource.Selecting event handler, and not using AppendDataboundItems.
Example:
Example:
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
SqlDataSource1.SelectParameters["OwnerID"].DefaultValue = Membership.GetUser(true).ProviderUserKey.ToString();
}
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
HyperText Transfer Protocol (http://www.ietf.org/rfc/rfc2616.txt) or "HTTP" is the underpinning of internet communication.  As a teacher of web development I have heard many questions, mostly from my younger students who have come to t…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 8 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.