SqlDataSourceView.Filtering Event

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Occurs before a filter operation.

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

Public Event Filtering As SqlDataSourceFilteringEventHandler

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: