SqlDataSourceView.Filtering Event

Definition

Occurs before a filter operation.

public:
 event System::Web::UI::WebControls::SqlDataSourceFilteringEventHandler ^ Filtering;
public event System.Web.UI.WebControls.SqlDataSourceFilteringEventHandler Filtering;
member this.Filtering : System.Web.UI.WebControls.SqlDataSourceFilteringEventHandler 
Public Custom Event Filtering As SqlDataSourceFilteringEventHandler 

Event Type

Remarks

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.

Important

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 how to handle events, see Handling and Raising Events.

Applies to

See also