This topic has not yet been rated - Rate this topic

SqlDataSource.Selecting Event

.NET Framework 3.0

Occurs before a data retrieval operation.

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

'Declaration
Public Event Selecting As SqlDataSourceSelectingEventHandler
'Usage
Dim instance As SqlDataSource
Dim handler As SqlDataSourceSelectingEventHandler

AddHandler instance.Selecting, handler

/** @event */
public void add_Selecting (SqlDataSourceSelectingEventHandler value)

/** @event */
public void remove_Selecting (SqlDataSourceSelectingEventHandler value)

JScript

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

XAML

Not applicable.

Remarks

Handle the Selecting event to perform additional initialization operations that are specific to your application, to validate the values of parameters, or to change the parameter values before the SqlDataSource control performs the select operation. The select arguments are available from the SqlDataSourceSelectingEventArgs object that is associated with the event.

For more information about handling events, see Consuming Events.

Platforms

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.

Version Information

.NET Framework

Supported in: 3.0, 2.0

Reference

SqlDataSource Class
SqlDataSource Members
System.Web.UI.WebControls Namespace
SqlDataSource.Selected Event
OnSelecting
Select
SqlDataSource.SelectParameters Property

Other Resources

ASP.NET Data Access Overview
Data Source Web Server Controls
SqlDataSource Web Server Control Overview
Introduction to the ASP.NET Page Life Cycle

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD