I am using NeedDataSource to databind a RadGrid to a collection of Entities using the Entity Framework 4.
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?
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
>