Export (0) Print
Expand All

SqlDataSourceView.Filtering Event

Note: This event is new in the .NET Framework version 2.0.

Occurs before a filter operation.

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

public event SqlDataSourceFilteringEventHandler Filtering
/** @event */
public void add_Filtering (SqlDataSourceFilteringEventHandler value)

/** @event */
public void remove_Filtering (SqlDataSourceFilteringEventHandler value)

JScript supports the use of events, but not the declaration of new ones.

Handle the Filtering event to perform validation operations on filter parameter values before the SqlDataSourceView object performs a filter operation. You can cancel the Select method by setting the Cancel property of the SqlDataSourceFilteringEventArgs object to true. The event is raised only if the FilterExpression property is set.

Security noteSecurity Note

You should validate any filter parameter value that you receive from the client. The runtime simply substitutes the parameter value into the filter expression and applies it to the DataView object that is returned by the Select method. If you are using the FilterExpression property as a security measure to limit the number of items that are returned, you must validate the parameter values before the filtering occurs.

For more information about handling events, see Consuming Events.

Windows 98, Windows 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0

Community Additions

ADD
Show:
© 2014 Microsoft