up vote 0 down vote favorite

Basically, I have four asp:DropDownLists and I wish to populate all of them from the same table, with certain conditions.
For example, I have this data source: 

<asp:SqlDataSource ID="ReferenceDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:mrapConnectionString1 %>
    SelectCommand="SELECT * FROM [reference_data] WHERE ([component] = @component)" >
    <SelectParameters>
        <asp:Parameter DefaultValue="MB" Name="component" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>

And I want to know if I can change that component parameter to be different for each of my four dropdown lists.
I tried adding the following code on the DataBinding event for my DropDown:

ReferenceDataSource1.SelectParameters.Remove(ReferenceDataSource1.SelectParameters["component"]);
ReferenceDataSource1.SelectParameters.Add("component", "MB");

But I ironically got a StackOverflowException...

share|improve this question
1  
lol... Got to love irony!! – ggonsalv Jun 7 '10 at 3:06
if you can set the id of your dropdown lists = "component" (MB,etc) you could use a control parameter on the data source with PropertyName=ID – Claudio Redi Jun 7 '10 at 3:33
Claudio, that still requires me to set the control to use, and it could be one of four controls. However, I was not aware I could do that, and I'm sure that's going to come in handy for something else I'm doing, so thanks. – death_au Jun 7 '10 at 4:26
yes, you're right. Sorry man. I made up a feature of ControlParameter. I have to stop answering so late in the night :-( – Claudio Redi Jun 7 '10 at 12:10
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.