This is a migrated thread and some comments may be shown as answers.

Filtering with StartsWith and Entities using NeedDataSource

2 Answers 212 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Curtis asked on 09 Jul 2011, 06:53 AM

I am using NeedDataSource to databind a RadGrid to a collection of Entities using the Entity Framework 4.

protected void dgPerson_NeedDataSource(object source, GridNeedDataSourceEventArgs e)

{

dgPerson.DataSource = LocalEntityManager.Context.People;

}

That all works fine but the StartsWith and EqualTo filter option do not return any rows. I have tried setting EnableLinqExpression to true and false but it makes no difference. There are 65,000 objects in this list of people objects. Could it be that is too many to filter by?

<telerik:RadGrid ID="dgPerson" runat="server"

AllowFilteringByColumn="True"

AllowSorting="True"

AllowPaging="true"

PagerStyle-Mode="NextPrevNumericAndAdvanced"

GridLines="None"

OnNeedDataSource="dgPerson_NeedDataSource"

EnableLinqExpressions="true"

ShowStatusBar="true"

Skin="Black">

<MasterTableView

Name="Person"

autogeneratecolumns="False"

CommandItemDisplay="Top"

datakeynames="PersonID"

pagesize="20"

EditMode="PopUp"

EditFormSettings-PopUpSettings-Modal="false"

EditFormSettings-PopUpSettings-Width="950px">

<RowIndicatorColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<SortExpressions>

<telerik:GridSortExpression FieldName="FullName" SortOrder="Ascending" />

</SortExpressions>

<Columns>

<telerik:GridBoundColumn DataField="PersonID" DataType="System.Int32" FilterControlWidth="40px"

HeaderText="ID" ReadOnly="True" SortExpression="PersonID" UniqueName="PersonID">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="Full Name" SortExpression="FullName" UniqueName="FullName" DataField="FullName" AutoPostBackOnFilter="true" CurrentFilterFunction="StartsWith">

<ItemTemplate><asp:Literal runat="server" ID="litFullName" Text='<%# Eval("FullName") %>'></asp:Literal></ItemTemplate>

<EditItemTemplate><asp:TextBox runat="server" ID="txtFullName" Width="300px" Text='<%# Bind("FullName") %>'></asp:TextBox></EditItemTemplate>

</telerik:GridTemplateColumn>

2 Answers, 1 is accepted

Accepted