Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SqlDataSourceView.Filtering Event

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)

In JScript, you can handle the events defined by a class, but you cannot define your own.
Not applicable.

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 Server 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.