ASP.NET Dynamic Data Record Selection

Question

I am displaying a list of customer records from SQL Server using L2S where I only want to display active customers (where Status = 'A'). How do I implement this logic in Dynamic Data? I am using the List.aspx template. I don't want the dropdown filtering option.

could you tag this as "asp.net-dynamic-data" also/instead

Aaron Hoffman
– Aaron Hoffman

2009-07-08 18:08:50 +00:00
Commented Jul 8, 2009 at 18:08 — Aaron Hoffman
– Aaron Hoffman, Commented Jul 8, 2009 at 18:08

Aaron Hoffman · Accepted Answer · 2009-07-08 18:05:38Z

1

You can do this by adding a Parameter to the LinqDataSource's WhereParameters collection.

If you don't want this for every table, you'll have to create a custom page for that Entity, and add it only on that page. (video http://www.asp.net/Learn/3.5-SP1/video-445.aspx)

<asp:LinqDataSource ID="GridDataSource" runat="server" EnableDelete="true" EnableUpdate="true">
    <WhereParameters>
        <asp:DynamicControlParameter ControlId="FilterRepeater" />
        <asp:Parameter Name="Status" DefaultValue="A" />
    </WhereParameters>
</asp:LinqDataSource>

answered Jul 8, 2009 at 18:05

Aaron Hoffman

6,98210 gold badges60 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nikos Over a year ago

Aaron, I want to apply this to every table. Given your example above, how would LinqDataSource know that I want to apply the Parameter Status to the Customer table and no other. I could have a column called Status in a different table which may cause ambiguity.

Aaron Hoffman Over a year ago

Do you want to apply this to every table or not? (I can't tell by your comment) If you do, put it on the Default List.aspx page. If you do not, create a custom page specifically for that Entity (see my original answer for a video link).

Nikos Over a year ago

Thanks Aaron. After further testing, custom page is what I want based on the example that you provided.

Collectives™ on Stack Overflow

ASP.NET Dynamic Data Record Selection

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related