The properties of System.Web.UI.WebControls.SqlDataSource are listed below. For a list of all members, see the SqlDataSource Members list.
See Also: Inherited members from System.Web.UI.DataSourceControl
CacheDuration | int.
Gets or sets the length of time, in seconds, that the data source control caches data that is retrieved by the SqlDataSource.Select(System.Web.UI.DataSourceSelectArguments) method. | |
CacheExpirationPolicy | System.Web.UI.DataSourceCacheExpiry.
Gets or sets the cache expiration behavior that, when combined with the duration, describes the behavior of the cache that the data source control uses. | |
CacheKeyDependency | string.
Gets or sets a user-defined key dependency that is linked to all data cache objects that are created by the data source control. All cache objects are explicitly expired when the key is expired. | |
CancelSelectOnNullParameter | bool.
Gets or sets a value indicating whether a data retrieval operation is canceled when any parameter that is contained in the SqlDataSource.SelectParameters collection evaluates to null. | |
ConflictDetection | System.Web.UI.ConflictOptions.
Gets or sets the value indicating how the System.Web.UI.WebControls.SqlDataSource control performs updates and deletes when data in a row in the underlying database changes during the time of the operation. | |
ConnectionString | string.
Gets or sets the ADO.NET provider–specific connection string that the System.Web.UI.WebControls.SqlDataSource control uses to connect to an underlying database. | |
DataSourceMode | SqlDataSourceMode.
Gets or sets the data retrieval mode that the System.Web.UI.WebControls.SqlDataSource control uses to fetch data. | |
DeleteCommand | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSource control uses to delete data from the underlying database. | |
DeleteCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSource.DeleteCommand property is an SQL statement or the name of a stored procedure. | |
[read-only] | DeleteParameters | ParameterCollection.
Gets the parameters collection that contains the parameters that are used by the SqlDataSource.DeleteCommand property from the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the System.Web.UI.WebControls.SqlDataSource control. |
EnableCaching | bool.
Gets or sets a value indicating whether the System.Web.UI.WebControls.SqlDataSource control has data caching enabled. | |
FilterExpression | string.
Gets or sets a filtering expression that is applied when the SqlDataSource.Select(System.Web.UI.DataSourceSelectArguments) method is called. | |
[read-only] | FilterParameters | ParameterCollection.
Gets a collection of parameters that are associated with any parameter placeholders that are in the SqlDataSource.FilterExpression string. |
InsertCommand | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSource control uses to insert data into the underlying database. | |
InsertCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSource.InsertCommand property is an SQL statement or the name of a stored procedure. | |
[read-only] | InsertParameters | ParameterCollection.
Gets the parameters collection that contains the parameters that are used by the SqlDataSource.InsertCommand property from the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the System.Web.UI.WebControls.SqlDataSource control. |
OldValuesParameterFormatString | string.
Gets or sets a format string to apply to the names of any parameters that are passed to the SqlDataSource.Delete or SqlDataSource.Update method. | |
ProviderName | string.
Gets or sets the name of the .NET Framework data provider that the System.Web.UI.WebControls.SqlDataSource control uses to connect to an underlying data source. | |
SelectCommand | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSource control uses to retrieve data from the underlying database. | |
SelectCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSource.SelectCommand property is an SQL query or the name of a stored procedure. | |
[read-only] | SelectParameters | ParameterCollection.
Gets the parameters collection that contains the parameters that are used by the SqlDataSource.SelectCommand property from the System.Web.UI.WebControls.SqlDataSourceView object that is associated with the System.Web.UI.WebControls.SqlDataSource control. |
SortParameterName | string.
Gets or sets the name of a stored procedure parameter that is used to sort retrieved data when data retrieval is performed using a stored procedure. | |
SqlCacheDependency | string.
Gets or sets a semicolon-delimited string that indicates which databases and tables to use for the Microsoft SQL Server cache dependency. | |
UpdateCommand | string.
Gets or sets the SQL string that the System.Web.UI.WebControls.SqlDataSource control uses to update data in the underlying database. | |
UpdateCommandType | SqlDataSourceCommandType.
Gets or sets a value indicating whether the text in the SqlDataSource.UpdateCommand property is an SQL statement or the name of a stored procedure. | |
[read-only] | UpdateParameters | ParameterCollection.
Gets the parameters collection that contains the parameters that are used by the SqlDataSource.UpdateCommand property from the System.Web.UI.WebControls.SqlDataSourceView control that is associated with the System.Web.UI.WebControls.SqlDataSource control. |