SqlDataSourceFilteringEventHandler Delegate
Collapse the table of content
Expand the table of content

SqlDataSourceFilteringEventHandler Delegate


Represents the method that will handle the Filtering event of the SqlDataSource control.

Namespace:   System.Web.UI.WebControls
Assembly:  System.Web (in System.Web.dll)

public delegate void SqlDataSourceFilteringEventHandler(
	object sender,
	SqlDataSourceFilteringEventArgs e


Type: System.Object

The source of the event, a SqlDataSource.

Type: System.Web.UI.WebControls.SqlDataSourceFilteringEventArgs

An SqlDataSourceFilteringEventArgs that contains the event data.

Filtering is supported when the DataSourceMode property is set to the DataSet value.

When you create an SqlDataSourceFilteringEventHandler delegate, you identify the method that will handle the event. To associate the event with your event handler, add an instance of the delegate to the event. The event handler is called whenever the event occurs, unless you remove the delegate. For more information about event handler delegates, see NIB: Consuming Events.

The following code example demonstrates how to retrieve data from the Northwind database and filter it using a FilterExpression and FilterParameters. The FilterExpression of the SqlDataSource is applied anytime the Select method is executed to retrieve data. In this example, the FilterExpression contains a placeholder for a filter parameter, which is contained in the FilterParameters collection. In 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();

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

            <p>Show all employees with the following title:
                <asp:ListItem>Sales Representative</asp:ListItem>
                <asp:ListItem>Sales Manager</asp:ListItem>
                <asp:ListItem>Vice President, Sales</asp:ListItem>

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

                    <asp:BoundField Visible="False" DataField="EmployeeID" />
                    <asp:BoundField HeaderText="First Name" DataField="FirstName" />
                    <asp:BoundField HeaderText="Last Name" DataField="LastName" />
                <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>


.NET Framework
Available since 2.0
Return to top
© 2015 Microsoft