Morning,
My foreign key columns are not filtering.
I get this error: "Expression expected".
Furthermore none of the foreign key columns have the "Contains" filter option.
The WebsiteUrl column has "Contains" filter option and works perfectly.
My columns look like this:
I've Specified the filter menu manually like this:
My foreign key columns are not filtering.
I get this error: "Expression expected".
Furthermore none of the foreign key columns have the "Contains" filter option.
The WebsiteUrl column has "Contains" filter option and works perfectly.
My columns look like this:
<telerik:GridBoundColumn DataField="WebsiteId" DataType="System.Int64" |
EmptyDataText="&nbsp;" HeaderText="WebsiteId" ReadOnly="True" |
SortExpression="WebsiteId" UniqueName="WebsiteId" Visible="false" ForceExtractValue="InEditMode"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="WebsiteUrl" EmptyDataText="&nbsp;" |
HeaderText="WebsiteUrl" SortExpression="WebsiteUrl" UniqueName="WebsiteUrl"> |
</telerik:GridBoundColumn> |
<telerik:GridTemplateColumn HeaderText="Client" |
DataType="System.Int64" UniqueName="Client" > |
<EditItemTemplate> |
<telerik:RadComboBox ID="RadComboBoxClientName" Runat="server" |
DataSourceID="LinqDataSourceClient" DataTextField="ClientName" |
DataValueField="ClientId" SelectedValue='<%# Bind("ClientId") %>' |
Skin="Vista" Width="280px"> |
<CollapseAnimation Duration="200" Type="OutQuint" /> |
</telerik:RadComboBox> |
</EditItemTemplate> |
<ItemTemplate> |
<asp:Label ID="LabelClientName" runat="server" Text= <%#Eval("tblClient.ClientName")%> > </asp:Label> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridTemplateColumn HeaderText="Server" |
DataType="System.Int32" UniqueName="Server" > |
<EditItemTemplate> |
<telerik:RadComboBox ID="RadComboBoxServerName" Runat="server" |
DataSourceID="LinqDataSourceServer" DataTextField="ServerName" |
DataValueField="ServerId" SelectedValue='<%# Bind("ServerId") %>' |
Skin="Vista" Width="280px"> |
<CollapseAnimation Duration="200" Type="OutQuint" /> |
</telerik:RadComboBox> |
</EditItemTemplate> |
<ItemTemplate> |
<asp:Label ID="LabelServerName" runat="server" Text= <%#Eval("tblServer.ServerName")%>> </asp:Label> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridBoundColumn DataField="LogFilePath" EmptyDataText="&nbsp;" |
HeaderText="LogFilePath" SortExpression="LogFilePath" |
UniqueName="LogFilePath" Display="False"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="BandWidthCost" DataType="System.Decimal" |
EmptyDataText="&nbsp;" HeaderText="BandWidthCost" |
SortExpression="BandWidthCost" UniqueName="BandWidthCost" Visible="false"> |
</telerik:GridBoundColumn> |
protected void RadGrid1_Init(object sender, EventArgs e) |
{ |
GridFilterMenu menu = RadGrid1.FilterMenu; |
int i = 0; |
while (i < menu.Items.Count) |
{ |
if (menu.Items[i].Text == "NoFilter" || |
menu.Items[i].Text == "Contains" || |
menu.Items[i].Text == "EqualTo" || |
menu.Items[i].Text == "GreaterThan" || |
menu.Items[i].Text == "LessThan") |
{ |
i++; |
} |
else |
{ |
menu.Items.RemoveAt(i); |
} |
} |
} |