Gets or sets the data retrieval mode that the SqlDataSource control uses to fetch data.
Assembly: System.Web (in System.Web.dll)
The data retrieval mode identifies how a SqlDataSource control retrieves data from the underlying database.
When the DataSet value, data is loaded into a DataSet object and stored in memory on the server. This enables scenarios where user interface controls, such as GridView, offer sorting, filtering, and paging capabilities.property is set to the
When the DataReader value, data is retrieved by a IDataReader object, which is a forward-only, read-only cursor. The specific type of the IDataReader object depends on the NET data provider that the SqlDataSource uses, which is identified by the ProviderName property. By default, the SqlDataSource control uses the provider for Microsoft SQL Server, the System.Data.SqlClient, and the data reader is a SqlDataReader object.property is set to the
The value of theproperty is stored in view state.
Available since 2.0