SqlDataSourceFilteringEventArgs SqlDataSourceFilteringEventArgs SqlDataSourceFilteringEventArgs SqlDataSourceFilteringEventArgs Class

Definizione

Fornisce i dati per l'evento Filtering del controllo SqlDataSource.Provides data for the Filtering event of the SqlDataSource control.

public ref class SqlDataSourceFilteringEventArgs : System::ComponentModel::CancelEventArgs
public class SqlDataSourceFilteringEventArgs : System.ComponentModel.CancelEventArgs
type SqlDataSourceFilteringEventArgs = class
    inherit CancelEventArgs
Public Class SqlDataSourceFilteringEventArgs
Inherits CancelEventArgs
Ereditarietà
SqlDataSourceFilteringEventArgsSqlDataSourceFilteringEventArgsSqlDataSourceFilteringEventArgsSqlDataSourceFilteringEventArgs

Esempi

Nell'esempio di codice seguente viene illustrato come recuperare i dati dal database Northwind e filtrarli utilizzando FilterExpression e FilterParameters.The following code example demonstrates how to retrieve data from the Northwind database and filter it using a FilterExpression and FilterParameters. L' FilterExpression oggetto SqlDataSource di viene applicato ogni volta che viene eseguito il Select metodo per recuperare i dati.The FilterExpression of the SqlDataSource is applied anytime the Select method is executed to retrieve data. In questo esempio, FilterExpression contiene un segnaposto per un parametro di filtro, contenuto FilterParameters nella raccolta.In this example, the FilterExpression contains a placeholder for a filter parameter, which is contained in the FilterParameters collection. Nell'evento, il parametro Filter viene visualizzato in un Label controllo. FilteringIn the Filtering event, the filter parameter is displayed in a Label control.

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

    //Protected Sub SqlDataSource1_Filtering(ByVal sender As Object, _
    //    ByVal e As System.Web.UI.WebControls.SqlDataSourceFilteringEventArgs)
    //    Label1.Text = e.ParameterValues(0).ToString()
    //End Sub


    protected void SqlDataSource1_Filtering(object sender, SqlDataSourceFilteringEventArgs e)
    {
        Label1.Text = e.ParameterValues[0].ToString();
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
    <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
        <form id="FORM1" runat="server">

            <p>Show all employees with the following title:
            <asp:DropDownList
                id="DropDownList1"
                runat="server"
                AutoPostBack="True">
                <asp:ListItem>Sales Representative</asp:ListItem>
                <asp:ListItem>Sales Manager</asp:ListItem>
                <asp:ListItem>Vice President, Sales</asp:ListItem>
            </asp:DropDownList></p>

            <asp:SqlDataSource
                id="SqlDataSource1"
                runat="server"
                ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>"
                SelectCommand="SELECT EmployeeID,FirstName,LastName,Title FROM Employees"
                FilterExpression="Title='{0}'" OnFiltering="SqlDataSource1_Filtering">
                <FilterParameters>
                    <asp:ControlParameter Name="Title" ControlId="DropDownList1" PropertyName="SelectedValue"/>
                </FilterParameters>
            </asp:SqlDataSource><br />

            <asp:GridView
                id="GridView1"
                runat="server"
                DataSourceID="SqlDataSource1"
                AutoGenerateColumns="False">
                <columns>
                    <asp:BoundField Visible="False" DataField="EmployeeID" />
                    <asp:BoundField HeaderText="First Name" DataField="FirstName" />
                    <asp:BoundField HeaderText="Last Name" DataField="LastName" />
                </columns>
            </asp:GridView>
                <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

        </form>
    </body>
</html>
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

    Protected Sub SqlDataSource1_Filtering(ByVal sender As Object, _
        ByVal e As System.Web.UI.WebControls.SqlDataSourceFilteringEventArgs)
        Label1.Text = e.ParameterValues(0).ToString()
    End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
    <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
        <form id="form1" runat="server">

            <p>Show all employees with the following title:
            <asp:DropDownList
                id="DropDownList1"
                runat="server"
                AutoPostBack="True">
                <asp:ListItem>Sales Representative</asp:ListItem>
                <asp:ListItem>Sales Manager</asp:ListItem>
                <asp:ListItem>Vice President, Sales</asp:ListItem>
            </asp:DropDownList></p>

            <asp:SqlDataSource
                id="SqlDataSource1"
                runat="server"
                ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>"
                SelectCommand="SELECT EmployeeID,FirstName,LastName,Title FROM Employees"
                FilterExpression="Title='{0}'" OnFiltering="SqlDataSource1_Filtering">
                <FilterParameters>
                    <asp:ControlParameter Name="Title" ControlId="DropDownList1" PropertyName="SelectedValue"/>
                </FilterParameters>
            </asp:SqlDataSource><br />

            <asp:GridView
                id="GridView1"
                runat="server"
                DataSourceID="SqlDataSource1"
                AutoGenerateColumns="False">
                <columns>
                    <asp:BoundField Visible="False" DataField="EmployeeID" />
                    <asp:BoundField HeaderText="First Name" DataField="FirstName" />
                    <asp:BoundField HeaderText="Last Name" DataField="LastName" />
                </columns>
            </asp:GridView>
                <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

        </form>
    </body>
</html>

Commenti

La SqlDataSourceFilteringEventArgs classe viene utilizzata per passare i dati Filtering al gestore eventi del SqlDataSource controllo.The SqlDataSourceFilteringEventArgs class is used to pass data to the Filtering event handler of the SqlDataSource control. La ParameterValues proprietà fornisce l'accesso ai valori dei parametri di filtro prima che venga eseguita l'operazione di filtro.The ParameterValues property provides access to the filter parameter values before the filtering operation is performed. È possibile annullare il Select metodo impostando la Cancel proprietà di ObjectDataSourceFilteringEventArgs su true.You can cancel the Select method by setting the Cancel property of the ObjectDataSourceFilteringEventArgs to true. Il filtro è supportato quando DataSourceMode la proprietà è impostata DataSet sul valore.Filtering is supported when the DataSourceMode property is set to the DataSet value.

Costruttori

SqlDataSourceFilteringEventArgs(IOrderedDictionary) SqlDataSourceFilteringEventArgs(IOrderedDictionary) SqlDataSourceFilteringEventArgs(IOrderedDictionary) SqlDataSourceFilteringEventArgs(IOrderedDictionary)

Inizializza una nuova istanza della classe SqlDataSourceFilteringEventArgs utilizzando l'oggetto specificato.Initializes a new instance of the SqlDataSourceFilteringEventArgs class by using the specified object.

Proprietà

Cancel Cancel Cancel Cancel

Ottiene o imposta un valore che indica se l'evento debba essere annullato.Gets or sets a value indicating whether the event should be canceled.

(Inherited from CancelEventArgs)
ParameterValues ParameterValues ParameterValues ParameterValues

Ottiene un oggetto IOrderedDictionary che fornisce accesso agli oggetti Parameter della classe SqlDataSource.Gets an IOrderedDictionary object that provides access to the Parameter objects of the SqlDataSource class.

Metodi

Equals(Object) Equals(Object) Equals(Object) Equals(Object)

Determina se l'oggetto specificato è uguale all'oggetto corrente.Determines whether the specified object is equal to the current object.

(Inherited from Object)
GetHashCode() GetHashCode() GetHashCode() GetHashCode()

Funge da funzione hash predefinita.Serves as the default hash function.

(Inherited from Object)
GetType() GetType() GetType() GetType()

Ottiene l'oggetto Type dell'istanza corrente.Gets the Type of the current instance.

(Inherited from Object)
MemberwiseClone() MemberwiseClone() MemberwiseClone() MemberwiseClone()

Crea una copia superficiale dell'oggetto Object corrente.Creates a shallow copy of the current Object.

(Inherited from Object)
ToString() ToString() ToString() ToString()

Restituisce una stringa che rappresenta l'oggetto corrente.Returns a string that represents the current object.

(Inherited from Object)

Si applica a

Vedi anche