Filter - Filtering DataSourceControl with RadFilter

  • And
  • Or
  • Not And
  • Not Or
  • Contains
  • DoesNotContain
  • StartsWith
  • EndsWith
  • EqualTo
  • NotEqualTo
  • GreaterThan
  • LessThan
  • GreaterThanOrEqualTo
  • LessThanOrEqualTo
  • Between
  • NotBetween
  • IsEmpty
  • NotIsEmpty
  • IsNull
  • NotIsNull

ContactNameCityAddressBool
Maria AndersBerlinObere Str. 57
Ana TrujilloMéxico D.F.Avda. de la Constitución 2222
Antonio MorenoMéxico D.F.Mataderos 2312
Thomas HardyLondon120 Hanover Sq.
Christina BerglundLuleåBerguvsvägen 8
Hanna MoosMannheimForsterstr. 57
Frédérique CiteauxStrasbourg24, place Kléber
Martín SommerMadridC/ Araquil, 67
Laurence LebihanMarseille12, rue des Bouchers
Elizabeth LincolnTsawassen23 Tsawassen Blvd.
123456789
Isolate this demo as a stand-alone application
  • About this demo
  • C#
  • VB

RadFilter can be used to build complex filtering criteria by means of intuitive visual UI and depending on the data type of the underlying source fields. This example demonstrates the integration between RadFilter and .Net 3.5/4.0 DataSourceControls such as LinqDataSource, EntityDataSource and OpenAccessDataSource.

To filter the .NET 35/.NET 4 data source control directly, you need to specify the DataSourceControlID property of RadFilter.

  • defaultcs.aspx
  • defaultcs.aspx.cs
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="defaultcs.aspx.cs" Inherits="Telerik.FilterExamplesCSharp.DataSourceIntegration.DefaultCS"  %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register TagPrefix="qsf" Namespace="Telerik.QuickStart" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
    <telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1"></telerik:RadAjaxLoadingPanel>
    <telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel2" LoadingPanelID="RadAjaxLoadingPanel1" CssClass="demo-container size-narrow">
        <div class="FilterContainer">
            <telerik:RadFilter RenderMode="Lightweight" runat="server" ID="RadFilter1" DataSourceControlID="EntityDataSourceCustomers"
                OnApplyExpressions="RadFilter1_ApplyExpressions">
            </telerik:RadFilter>
            <asp:EntityDataSource ID="EntityDataSourceCustomers" runat="server" ConnectionString="name=NorthwindReadWriteEntities"
                DefaultContainerName="NorthwindReadWriteEntities" EntitySetName="Customers" EnableDelete="True" EnableFlattening="False" EnableInsert="True" EnableUpdate="True">
            </asp:EntityDataSource>
        </div>
        <br />
        <asp:GridView runat="server" ID="GridView1" AllowPaging="true" AllowSorting="true"
            DataSourceID="EntityDataSourceCustomers" AutoGenerateColumns="false">
            <EmptyDataTemplate>
                No recrods to display.
            </EmptyDataTemplate>
            <Columns>
                <asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
                <asp:CheckBoxField DataField="Bool" HeaderText="Bool" SortExpression="Bool" />
            </Columns>
        </asp:GridView>
    </telerik:RadAjaxPanel>
    </form>
</body>
</html>

Support & Learning Resources

Find Assistance

Help Us Improve

Was this example helpful?