SqlDataSource Properties
.NET Framework 2.0
(see also
Protected Properties
)
Top
| Name | Description | |
|---|---|---|
| AppRelativeTemplateSourceDirectory | Gets or sets the application-relative virtual directory of the Page or UserControl object that contains this control. (Inherited from Control.) |
| BindingContainer | Gets the control that contains this control's data binding. (Inherited from Control.) |
| CacheDuration | Gets or sets the length of time, in seconds, that the data source control caches data that is retrieved by the Select method. |
| CacheExpirationPolicy | 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 | 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 | Gets or sets a value indicating whether a data retrieval operation is canceled when any parameter that is contained in the SelectParameters collection evaluates to a null reference (Nothing in Visual Basic). |
| ClientID | Gets the server control identifier generated by ASP.NET. (Inherited from DataSourceControl.) |
| ConflictDetection | Gets or sets the value indicating how the SqlDataSource control performs updates and deletes when data in a row in the underlying database changes during the time of the operation. |
| ConnectionString | Gets or sets the ADO.NET provider–specific connection string that the SqlDataSource control uses to connect to an underlying database. |
| Controls | Gets a ControlCollection object that represents the child controls for a specified server control in the UI hierarchy. (Inherited from DataSourceControl.) |
| DataSourceMode | Gets or sets the data retrieval mode that the SqlDataSource control uses to fetch data. |
| DeleteCommand | Gets or sets the SQL string that the SqlDataSource control uses to delete data from the underlying database. |
| DeleteCommandType | Gets or sets a value indicating whether the text in the DeleteCommand property is an SQL statement or the name of a stored procedure. |
| DeleteParameters | Gets the parameters collection that contains the parameters that are used by the DeleteCommand property from the SqlDataSourceView object that is associated with the SqlDataSource control. |
| EnableCaching | Gets or sets a value indicating whether the SqlDataSource control has data caching enabled. |
| EnableTheming | Gets a value indicating whether this control supports themes. (Inherited from DataSourceControl.) |
| EnableViewState | Gets or sets a value indicating whether the server control persists its view state, and the view state of any child controls it contains, to the requesting client. (Inherited from Control.) |
| FilterExpression | Gets or sets a filtering expression that is applied when the Select method is called. |
| FilterParameters | Gets a collection of parameters that are associated with any parameter placeholders that are in the FilterExpression string. |
| ID | Gets or sets the programmatic identifier assigned to the server control. (Inherited from Control.) |
| InsertCommand | Gets or sets the SQL string that the SqlDataSource control uses to insert data into the underlying database. |
| InsertCommandType | Gets or sets a value indicating whether the text in the InsertCommand property is an SQL statement or the name of a stored procedure. |
| InsertParameters | Gets the parameters collection that contains the parameters that are used by the InsertCommand property from the SqlDataSourceView object that is associated with the SqlDataSource control. |
| NamingContainer | Gets a reference to the server control's naming container, which creates a unique namespace for differentiating between server controls with the same Control.ID property value. (Inherited from Control.) |
| OldValuesParameterFormatString | Gets or sets a format string to apply to the names of any parameters that are passed to the Delete or Update method. |
| Page | Gets a reference to the Page instance that contains the server control. (Inherited from Control.) |
| Parent | Gets a reference to the server control's parent control in the page control hierarchy. (Inherited from Control.) |
| ProviderName | Gets or sets the name of the .NET Framework data provider that the SqlDataSource control uses to connect to an underlying data source. |
| SelectCommand | Gets or sets the SQL string that the SqlDataSource control uses to retrieve data from the underlying database. |
| SelectCommandType | Gets or sets a value indicating whether the text in the SelectCommand property is an SQL query or the name of a stored procedure. |
| SelectParameters | Gets the parameters collection that contains the parameters that are used by the SelectCommand property from the SqlDataSourceView object that is associated with the SqlDataSource control. |
| Site | Gets information about the container that hosts the current control when rendered on a design surface. (Inherited from Control.) |
| SkinID | Gets the skin to apply to the DataSourceControl control. (Inherited from DataSourceControl.) |
| SortParameterName | 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 | Gets or sets a semicolon-delimited string that indicates which databases and tables to use for the Microsoft SQL Server cache dependency. |
| TemplateControl | Gets or sets a reference to the template that contains this control. (Inherited from Control.) |
| TemplateSourceDirectory | Gets the virtual directory of the Page or UserControl that contains the current server control. (Inherited from Control.) |
| UniqueID | Gets the unique, hierarchically qualified identifier for the server control. (Inherited from Control.) |
| UpdateCommand | Gets or sets the SQL string that the SqlDataSource control uses to update data in the underlying database. |
| UpdateCommandType | Gets or sets a value indicating whether the text in the UpdateCommand property is an SQL statement or the name of a stored procedure. |
| UpdateParameters | Gets the parameters collection that contains the parameters that are used by the UpdateCommand property from the SqlDataSourceView control that is associated with the SqlDataSource control. |
| Visible | Gets or sets a value indicating whether the control is visually displayed. (Inherited from DataSourceControl.) |
| Name | Description | |
|---|---|---|
| Adapter | Gets the browser-specific adapter for the control. (Inherited from Control.) |
| ChildControlsCreated | Gets a value that indicates whether the server control's child controls have been created. (Inherited from Control.) |
| ClientIDSeparator | Gets a character value representing the separator character used in the ClientID property. (Inherited from Control.) |
| Context | Gets the HttpContext object associated with the server control for the current Web request. (Inherited from Control.) |
| DesignMode | Gets a value indicating whether a control is being used on a design surface. (Inherited from Control.) |
| Events | Gets a list of event handler delegates for the control. This property is read-only. (Inherited from Control.) |
| HasChildViewState | Gets a value indicating whether the current server control's child controls have any saved view-state settings. (Inherited from Control.) |
| IdSeparator | Gets the character used to separate control identifiers. (Inherited from Control.) |
| IsChildControlStateCleared | Gets a value indicating whether controls contained within this control have control state. (Inherited from Control.) |
| IsTrackingViewState | Gets a value that indicates whether the server control is saving changes to its view state. (Inherited from Control.) |
| IsViewStateEnabled | Gets a value indicating whether view state is enabled for this control. (Inherited from Control.) |
| LoadViewStateByID | Gets a value indicating whether the control participates in loading its view state by ID instead of index. (Inherited from Control.) |
| ViewState | Gets a dictionary of state information that allows you to save and restore the view state of a server control across multiple requests for the same page. (Inherited from Control.) |
| ViewStateIgnoresCase | Gets a value that indicates whether the StateBag object is case-insensitive. (Inherited from Control.) |
Community Additions
ADD
Show: