Select

System.Web.UI.WebControls.SqlDataSourceView.Select Method

Retrieves data from the underlying database using the SqlDataSourceView.SelectCommand SQL string and any parameters that are in the SqlDataSourceView.SelectParameters collection.

Syntax

public IEnumerable Select (System.Web.UI.DataSourceSelectArguments arguments)

Parameters

arguments
A System.Web.UI.DataSourceSelectArguments used to request operations on the data beyond basic data retrieval.

Returns

An IEnumerable list of data rows.

Remarks

The SqlDataSourceView.Select(System.Web.UI.DataSourceSelectArguments) method calls the SqlDataSourceView.ExecuteSelect(System.Web.UI.DataSourceSelectArguments) method, passing the selectArgs parameter.

The SqlDataSourceView.ExecuteSelect(System.Web.UI.DataSourceSelectArguments) method returns a System.Data.DataView object, if the SqlDataSource.DataSourceMode property is set to the SqlDataSourceMode.DataSet value or it returns a System.Data.IDataReader object, if the SqlDataSource.DataSourceMode property is set to the SqlDataSourceMode.DataReader value. Close the System.Data.IDataReader object when you have finished reading the data.

Requirements

Namespace: System.Web.UI.WebControls
Assembly: System.Web (in System.Web.dll)
Assembly Versions: 2.0.0.0
Since: .NET 2.0