This documentation is archived and is not being maintained.
SqlDataSource Properties
Visual Studio 2010
The SqlDataSource type exposes the following members.
| Name | Description | |
|---|---|---|
|
Adapter | Gets the browser-specific adapter for the control. (Inherited from Control.) |
|
AppRelativeTemplateSourceDirectory | Gets or sets the application-relative virtual directory of the Page or UserControl object that contains this control. (Inherited from Control.) |
|
BindingContainer | Infrastructure. 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 nullptr. |
|
ChildControlsCreated | Gets a value that indicates whether the server control's child controls have been created. (Inherited from Control.) |
|
ClientID | Gets the server control identifier generated by ASP.NET. (Inherited from DataSourceControl.) |
|
ClientIDMode | This property is not used for data source controls. (Inherited from DataSourceControl.) |
|
ClientIDSeparator | Gets a character value representing the separator character used in the ClientID property. (Inherited from Control.) |
|
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. |
|
Context | Gets the HttpContext object associated with the server control for the current Web request. (Inherited from Control.) |
|
Controls | Gets a ControlCollection object that represents the child controls for a specified server control in the UI hierarchy. (Inherited from DataSourceControl.) |
|
DataItemContainer | Gets a reference to the naming container if the naming container implements IDataItemContainer. (Inherited from Control.) |
|
DataKeysContainer | Gets a reference to the naming container if the naming container implements IDataKeysControl. (Inherited from Control.) |
|
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. |
|
DesignMode | Gets a value indicating whether a control is being used on a design surface. (Inherited from 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.) |
|
Events | Gets a list of event handler delegates for the control. This property is read-only. (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. |
|
HasChildViewState | Gets a value indicating whether the current server control's child controls have any saved view-state settings. (Inherited from Control.) |
|
ID | Gets or sets the programmatic identifier assigned to the server control. (Inherited from Control.) |
|
IdSeparator | Infrastructure. Gets the character used to separate control identifiers. (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. |
|
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.) |
|
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. |
|
RenderingCompatibility | Gets a value that specifies the ASP.NET version that rendered HTML will be compatible with. (Inherited from Control.) |
|
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. |
|
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.) |
|
ViewStateMode | Gets or sets the view-state mode of this control. (Inherited from Control.) |
|
Visible | Gets or sets a value indicating whether the control is visually displayed. (Inherited from DataSourceControl.) |
| Name | Description | |
|---|---|---|
|
IControlBuilderAccessor::ControlBuilder | For a description of this member, see IControlBuilderAccessor::ControlBuilder. (Inherited from Control.) |
|
IControlDesignerAccessor::UserData | For a description of this member, see IControlDesignerAccessor::UserData. (Inherited from Control.) |
|
IDataBindingsAccessor::DataBindings | For a description of this member, see IDataBindingsAccessor::DataBindings. (Inherited from Control.) |
|
IDataBindingsAccessor::HasDataBindings | For a description of this member, see IDataBindingsAccessor::HasDataBindings. (Inherited from Control.) |
|
IExpressionsAccessor::Expressions | For a description of this member, see IExpressionsAccessor::Expressions. (Inherited from Control.) |
|
IExpressionsAccessor::HasExpressions | For a description of this member, see IExpressionsAccessor::HasExpressions. (Inherited from Control.) |
|
IListSource::ContainsListCollection | Infrastructure. Indicates whether the data source control is associated with one or more lists of data. (Inherited from DataSourceControl.) |
Show: