SqlDataSourceView.Filtering Event

 

Occurs before a filter operation.

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

public event SqlDataSourceFilteringEventHandler Filtering

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.

System_CAPS_security Security 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 NIB: Consuming Events.

.NET Framework
Available since 2.0
Return to top
Show: