QueryableFilterRepeater Classe

Definição

public ref class QueryableFilterRepeater : System::Web::UI::Control

public ref class QueryableFilterRepeater : System::Web::UI::Control, System::Web::DynamicData::IFilterExpressionProvider

public class QueryableFilterRepeater : System.Web.UI.Control

public class QueryableFilterRepeater : System.Web.UI.Control, System.Web.DynamicData.IFilterExpressionProvider

type QueryableFilterRepeater = class
    inherit Control

type QueryableFilterRepeater = class
    inherit Control
    interface IFilterExpressionProvider

Public Class QueryableFilterRepeater
Inherits Control

Public Class QueryableFilterRepeater
Inherits Control
Implements IFilterExpressionProvider

Herança

Object

Control

QueryableFilterRepeater

Implementações

IFilterExpressionProvider

Exemplos

O exemplo a seguir mostra como usar o QueryableFilterRepeater controle para gerar a interface do usuário para filtragem de linha de tabela. O modelo de item do repetidor contém um DynamicFilter controle que cria a interface do usuário para cada tipo de coluna com suporte.

O exemplo requer um site de dados dinâmicos ou um aplicativo Web de dados dinâmicos. Para obter mais informações, consulte Walkthrough: Creating a New Dynamic Data Web Site using Scaffolding.

<%@ Page Language="C#" MasterPageFile="~/Site.master"   
    CodeFile="QueryableFilterRepeater.aspx.cs" 
    Inherits="QueryableFilterRepeaterSample" %>

<%@ Register src="~/DynamicData/Content/GridViewPager.ascx" tagname="GridViewPager" tagprefix="asp" %>

<asp:Content ID="headContent" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">


    <asp:DynamicDataManager ID="DynamicDataManager1" runat="server" AutoLoadForeignKeys="true" />

   
     <h2 class="DDSubHeader"><%= table.DisplayName%></h2>

    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:ValidationSummary ID="ValidationSummary1" runat="server" EnableClientScript="true"
                HeaderText="List of validation errors" />
            <asp:DynamicValidator runat="server" ID="GridViewValidator" ControlToValidate="GridView1" Display="None" />
            
        
        <!-- Set the QueryableFilterRepeater control attributes. --> 
            <asp:QueryableFilterRepeater runat="server" ID="FilterRepeaterID">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("DisplayName") %>' />
                    <asp:DynamicFilter runat="server" ID="DynamicFilter" 
                        OnFilterChanged="OnFilterSelectionChanged"  /><br />
                </ItemTemplate>
            </asp:QueryableFilterRepeater>
           
        
        <br />

             <!-- Data-bound control that shows the filtered table rows. -->
            <asp:GridView ID="GridView1" runat="server" 
                DataSourceID="GridDataSource" EnablePersistedSelection="true"
                AllowPaging="True" AllowSorting="True" CssClass="DDGridView">
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:LinkButton ID="DeleteLinkButton" runat="server" CommandName="Delete"
                                CausesValidation="true" Text="Delete"
                                OnClientClick='return confirm("Are you sure you want to delete this item?");'
                            />
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>

                <PagerStyle CssClass="footer"/>        
                <PagerTemplate>
                    <asp:GridViewPager runat="server" />
                </PagerTemplate>
                <EmptyDataTemplate>
                    There are currently no items in this table.
                </EmptyDataTemplate>
            </asp:GridView>
            
            <asp:LinqDataSource ID="GridDataSource" runat="server" 
                EnableDelete="true" 
                ContextTypeName="AdventureWorksLTDataContext"
                TableName="SalesOrderDetails">
            </asp:LinqDataSource>
            
            <!-- The control that handles the details for querying 
            the database, after a user's filtering action -->
            <asp:QueryExtender ID="QueryBlock1" 
                TargetControlID="GridDataSource" runat="server">
                <asp:DynamicFilterExpression ControlID="FilterRepeaterID" />
            </asp:QueryExtender>
        </ContentTemplate>
    </asp:UpdatePanel>


</asp:Content>

<%@ Page Language="VB" MasterPageFile="~/Site.master" 
AutoEventWireup="true" CodeFile="QueryableFilterRepeater.aspx.vb" 
Inherits="QueryableFilterRepeaterSample" %>


<%@ Register src="~/DynamicData/Content/GridViewPager.ascx" tagname="GridViewPager" tagprefix="asp" %>

<asp:Content ID="headContent" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">


    <asp:DynamicDataManager ID="DynamicDataManager1" runat="server" AutoLoadForeignKeys="true" />

   
     <h2 class="DDSubHeader"><%= table.DisplayName%></h2>

    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:ValidationSummary ID="ValidationSummary1" runat="server" EnableClientScript="true"
                HeaderText="List of validation errors" />
            <asp:DynamicValidator runat="server" ID="GridViewValidator" ControlToValidate="GridView1" Display="None" />
            

            <!-- Set the QueryableFilterRepeater control attributes. -->             
            <asp:QueryableFilterRepeater runat="server" ID="FilterRepeaterID">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("DisplayName") %>' />
                    <asp:DynamicFilter runat="server" ID="DynamicFilter" 
                        OnFilterChanged="OnFilterSelectionChanged" /><br />
                </ItemTemplate>
            </asp:QueryableFilterRepeater>
            
            <br />

             <!-- Data-bound control that shows the filtered table rows. -->
            <asp:GridView ID="GridView1" runat="server" 
                DataSourceID="GridDataSource" EnablePersistedSelection="true"
                AllowPaging="True" AllowSorting="True" CssClass="DDGridView">
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:LinkButton ID="DeleteLinkButton" runat="server" CommandName="Delete"
                                CausesValidation="true" Text="Delete"
                                OnClientClick='return confirm("Are you sure you want to delete this item?");'
                            />
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>

                <PagerStyle CssClass="footer"/>        
                <PagerTemplate>
                    <asp:GridViewPager ID="GridViewPager1" runat="server" />
                </PagerTemplate>
                <EmptyDataTemplate>
                    There are currently no items in this table.
                </EmptyDataTemplate>
            </asp:GridView>
            
            <asp:LinqDataSource ID="GridDataSource" runat="server" 
                EnableDelete="true" 
                ContextTypeName="AdventureWorksLTDataContext"
                TableName="SalesOrderDetails">
            </asp:LinqDataSource>
            
            <!-- The control that handles the details for querying 
            the database, after a user's filtering action -->
            <asp:QueryExtender ID="QueryBlock1" 
                TargetControlID="GridDataSource" runat="server">
                <asp:DynamicFilterExpression ControlID="FilterRepeaterID" />
            </asp:QueryExtender>
        </ContentTemplate>
    </asp:UpdatePanel>


</asp:Content>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using System.Web.DynamicData;

public partial class QueryableFilterRepeaterSample : System.Web.UI.Page 
{
    protected MetaTable table;

    protected void Page_Init(object sender, EventArgs e) {
        DynamicDataManager1.RegisterControl(GridView1, true /*setSelectionFromUrl*/);
    }

    protected void Page_Load(object sender, EventArgs e) {
        table = GridDataSource.GetTable();
        Title = table.DisplayName;

        // Disable various options if the table is readonly
        if (table.IsReadOnly) {
            GridView1.Columns[0].Visible = false;
        }
    }

    // Handle the filter change event.
    // This function resets the index of the page to display.
    protected void OnFilterSelectionChanged(object sender, EventArgs e) 
    {
        GridView1.PageIndex = 0;
    }
 }

Imports System.Data
Imports System.Configuration
Imports System.Collections
Imports System.Linq
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
Imports System.Xml.Linq
Imports System.Web.DynamicData


Partial Public Class QueryableFilterRepeaterSample
    Inherits System.Web.UI.Page
    Protected table As MetaTable

    Protected Sub Page_Init(ByVal sender As Object, ByVal e As EventArgs)
        'setSelectionFromUrl
        DynamicDataManager1.RegisterControl(GridView1, True)
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
        table = GridDataSource.GetTable()
        Title = table.DisplayName

        ' Disable various options if the table is readonly
        If table.IsReadOnly Then
            GridView1.Columns(0).Visible = False
        End If
    End Sub

    ' Handle the filter change event.
    ' This function resets the index of the page to display.
    Protected Sub OnFilterSelectionChanged(ByVal sender As Object, ByVal e As EventArgs)
        GridView1.PageIndex = 0
    End Sub
End Class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using System.Web.DynamicData;

    // Define the enumeration to apply
    // to the OrderQty data field.
    // This enumeration is used for filtering.
    public enum QtyEnum
    {
        None        = 0,
        Small1      = 1,
        Small2      = 2,
        Small3      = 3,
        Medium10    = 10,
        Medium11    = 11,
        Medium12    = 12,
        Medium13    = 13,
        Medium14    = 14,
        Large21     = 21,
        Large22     = 22,
        Large23     = 23,
        XLarge60    = 60,
        XLarge70    = 70
    }

    [MetadataType(typeof(SalesOrderDetail_MD))]
    public partial class SalesOrderDetail {

        private class SalesOrderDetail_MD
        {
            // Qualify the OrderQty field 
            // with the applicable 
            // enumeration type.
            [EnumDataType(typeof(QtyEnum))] 
            public object OrderQty { get; set; }
        }
    }

Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.ComponentModel.DataAnnotations
Imports System.Web.DynamicData

'Define the enumeration to apply
'to the OrderQty data field.
'This enumeration is used for filtering.
Public Enum QtyEnum
    None = 0
    Small1 = 1
    Small2 = 2
    Small3 = 3
    Medium10 = 10
    Medium11 = 11
    Medium12 = 12
    Medium13 = 13
    Medium14 = 14
    Large21 = 21
    Large22 = 22
    Large23 = 23
    XLarge60 = 60
    XLarge70 = 70
End Enum

<MetadataType(GetType(SalesOrderDetail_MD))> _
Partial Public Class SalesOrderDetail


End Class

Public Class SalesOrderDetail_MD
    Private _oq As Object

    'Qualify the OrderQty field 
    'with the applicable 
    'enumeration type.
    <EnumDataType(GetType(QtyEnum))> _
    Public Property OrderQty() As Object
        Get
            Return _oq
        End Get
        Set(ByVal value As Object)
            _oq = value
        End Set
    End Property
End Class

Comentários

Neste artigo:

• Introdução
• Contexto de classe
• Sintaxe declarativa

Introdução

O QueryableFilterRepeater controle é usado na marcação de página para gerar automaticamente a interface do usuário para filtrar linhas de tabela. Por padrão, os Dados Dinâmicos criam a interface do usuário para cada tipo de coluna com suporte usando os modelos de filtro padrão que estão no diretório ~\DynamicData\Filters.

Os modelos padrão dão suporte a tipos de coluna de chave estrangeira, booliana e enumeração.

A tabela a seguir lista as tarefas associadas ao QueryableFilterRepeater tipo.

Contexto de classe

O QueryableFilterRepeater controle foi projetado para funcionar com o QueryExtender controle. Ele deve ser referenciado por uma DynamicFilterExpression instância dentro de um QueryExtender objeto na marcação de página.

A figura a seguir mostra as etapas que os Dados Dinâmicos seguem para implementar a filtragem automática de linhas de tabela.

1. Os DynamicFilter controles (que estão contidos no QueryableFilterRepeater controle), passam um valor de coluna para o QueryExtender controle.
2. O QueryExtender controle usa esse valor para criar as informações de filtragem de consulta, que ela passa para o controle da fonte de dados.
3. O controle da fonte de dados passa as informações de filtragem de consulta para o provedor de fonte de dados.
4. O provedor de fonte de dados passa a consulta para o banco de dados.
5. O banco de dados retorna as linhas de tabela filtradas.
6. O provedor de fonte de dados envia esses dados de volta para o controle da fonte de dados.
7. Esse controle passa as linhas de tabela filtradas para o controle associado a dados para exibição.

Sintaxe declarativa

<asp:QueryableFilterRepeater
    ID="string"
    DynamicFilterContainerId="string"
    EnableViewState="True|False"
    OnDataBinding="DataBinding event handler"
    OnDisposed="Disposed event handler"
    OnInit="Init event handler"
    OnLoad="Load event handler"
    OnPreRender="PreRender event handler"
    OnUnload="Unload event handler"
    Visible="true"
    runat="server" />

Confira também

• DynamicFilter
• Passo a passo: filtrando linhas em tabelas que têm uma relação Parent-Child