SqlDataSourceMode Enumeration
Specifies whether a SqlDataSource or AccessDataSource control retrieves data as a IDataReader or DataSet.
Assembly: System.Web (in System.Web.dll)
| Member name | Description | |
|---|---|---|
| DataReader | Retrieves data from the underlying data storage as an IDataReader | |
| DataSet | Retrieves data from the underlying data storage into a DataSet structure. |
The SqlDataSourceMode enumeration is used by the SqlDataSource and AccessDataSource controls to describe the data retrieval mode that the data source control uses when the Select method is called. When the DataSourceMode property is set to DataSet, data is loaded into a DataSet structure. This enables scenarios where user interface controls such as GridView offer sorting and paging capabilities. When the DataSourceMode property is set to DataReader, data is retrieved by an IDataReader object, which is a read-only, forward-only cursor.
The SqlDataSourceMode enumeration is only used to describe how the Select command retrieves data; it has no effect on other operations the SqlDataSource control performs, such as Insert, Update, or Delete.
The following code example demonstrates how to set the DataSourceMode of a SqlDataSource control to DataReader when retrieving a simple list of items from a SQL Server database into a ListBox control.
The following code example demonstrates how to set the DataSourceMode to DataSet when retrieving a set of data into a GridView control that has sorting enabled.
Available since 2.0