ASP.NET Dynamic Data Record Selection

asp.net-dynamic-datadynamic-data

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.

Best Answer

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>

Related Solutions

ASP.NET Dynamic Data Add Additional Filter Criteria to Page

If you want to add your own criteria to the application that isn't automatically given to you by DD, you'll have to go to DynamicDataFiltering to do that. DynamicData itself doesn't currently support custom filters and searching. It isn't difficult to implement. Josh Heyes did a great job on it.

Come back if that's not quite what you are looking for

EDIT: Also, if you are just intending on doing some further filtering of the displayed data you could write something like this maybe in the Page_Init without Josh's filtering project:

GridDataSource.WhereParameters.Add(new Parameter("it.myColumn", TypeCode.Int32, myValue));

Doing "in" or "contains" is a little more complicated than that, and would require DynamicDataFiltering.

Sql – How to filter choices out of a drop down list when using Dynamic Data

LINQ to SQL generates partial classes.

Add a new property (copy from the other foreign key property)
Apply the filter in the get (either by LINQ2SQL or filtering the original property)
Bind to that property

Example UnapprovedContacts in Association table

public partial class Association
{
    public IList<Contact> UnapprovedContacts
    {
        get
        {
            return Contacts.Where(c => !c.IsApproved).ToList();
        }
    }
}

Best Answer

Related Solutions

ASP.NET Dynamic Data Add Additional Filter Criteria to Page

Sql – How to filter choices out of a drop down list when using Dynamic Data

Related Topic