asp where parameter for linq query

Here is my scenario.  I have an aspx webpage that has a dropdown in the form.  I am populating the dropdown with a view that is in my dataclasses file.  This view is just a list of years, but for the particular form I am using i need to filter the results of that view.  From the dropdown i have configured a linqdatasource.  in that wizard i selected to add some parameters to the where clause.  this works as expected when specifing year less than 2000 and greater than 1955; however, what i need to do is include all years less than current year - 9 and greater than current year - 50.  

what i think i should be able to do is something similar to select year(getdate())-9 as the default value; however, when doing so i get an error "Input string was not in a correct format"

please advise.  
<asp:DropDownList ID="BirthYear" runat="server" AppendDataBoundItems="True" 
        Width="180px" DataSourceID="LinqDataSource_DropDown_BirthYear" DataTextField="intYear" 
            <asp:ListItem Selected="True" Value="0">Choose One</asp:ListItem>
        <asp:LinqDataSource ID="LinqDataSource_DropDown_BirthYear" runat="server" 
        Select="new (intYear)" TableName="viewDropDown_Years" 
        Where="intYear &lt; @intYear &amp;&amp; intYear &gt; @intYear1">
                <asp:Parameter DefaultValue="2000" Name="intYear" Type="Int32" />
                <asp:Parameter DefaultValue="1955" Name="intYear1" Type="Int32" />

Open in new window

Who is Participating?
rugby148Connect With a Mentor Author Commented:
I found a solution.  i did not need to use the parameter.  I could just put what i needed in the where property of the linkdatasource.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.