New to Telerik UI for ASP.NET AJAX? Download free 30-day trial

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.
12345678910

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>
<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