QueryableFilterRepeater Klass

Definition

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

Arv

Object

Control

QueryableFilterRepeater

Implementeringar

IFilterExpressionProvider

Exempel

I följande exempel visas hur du använder QueryableFilterRepeater kontrollen för att generera användargränssnittet för tabellradfiltrering. Repeaterns objektmall innehåller en DynamicFilter kontroll som skapar användargränssnittet för varje kolumntyp som stöds.

Exemplet kräver en webbplats för dynamiska data eller ett webbprogram för dynamiska data. Mer information finns i 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

Kommentarer

I den här artikeln:

• Inledning
• Klasskontext
• Deklarativ syntax

Introduction

Kontrollen QueryableFilterRepeater används i sidmarkering för att automatiskt generera användargränssnittet för att filtrera tabellrader. Som standard skapar dynamiska data användargränssnittet för varje kolumntyp som stöds med hjälp av standardfiltermallarna som finns i katalogen ~\DynamicData\Filters.

Standardmallarna stöder kolumntyperna foreign-key, Boolean och enumeration.

I följande tabell visas uppgifter som är associerade med QueryableFilterRepeater typen.

Klasskontext

Kontrollen QueryableFilterRepeater är utformad för att fungera med QueryExtender kontrollen. Den måste refereras av en DynamicFilterExpression instans i ett QueryExtender objekt i sidmarkeringen.

Följande bild visar de steg som dynamiska data följer för att implementera automatisk tabellradfiltrering.

1. Kontrollerna DynamicFilter (som finns i QueryableFilterRepeater kontrollen) skickar ett kolumnvärde till QueryExtender kontrollen.
2. Kontrollen QueryExtender använder det här värdet för att skapa frågefiltreringsinformationen, som den sedan skickar till datakällans kontroll.
3. Datakällans kontroll skickar frågefiltreringsinformationen till datakällans provider.
4. Datakällans provider skickar frågan till databasen.
5. Databasen returnerar de filtrerade tabellraderna.
6. Datakällans provider skickar dessa data tillbaka till datakällans kontroll.
7. Den här kontrollen skickar de filtrerade tabellraderna till den databundna kontrollen för visning.

Deklarativ syntax

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

Se även

• DynamicFilter
• Genomgång: Filtrera rader i tabeller som har en Parent-Child relation