Export (0) Print
Expand All

SqlDataSource Properties

(see also Protected Properties )
  Name Description
Public property AppRelativeTemplateSourceDirectory  Gets or sets the application-relative virtual directory of the Page or UserControl object that contains this control. (inherited from Control)
Public property BindingContainer  Gets the control that contains this control's data binding. (inherited from Control)
Public property CacheDuration Gets or sets the length of time, in seconds, that the data source control caches data that is retrieved by the Select method.
Public property 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.
Public property 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.
Public property 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).
Public property ClientID  Gets the server control identifier generated by ASP.NET. (inherited from DataSourceControl)
Public property 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.
Public property ConnectionString Gets or sets the ADO.NET provider–specific connection string that the SqlDataSource control uses to connect to an underlying database.
Public property Controls  Gets a ControlCollection object that represents the child controls for a specified server control in the UI hierarchy. (inherited from DataSourceControl)
Public property DataSourceMode Gets or sets the data retrieval mode that the SqlDataSource control uses to fetch data.
Public property DeleteCommand Gets or sets the SQL string that the SqlDataSource control uses to delete data from the underlying database.
Public property 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.
Public property 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.
Public property EnableCaching Gets or sets a value indicating whether the SqlDataSource control has data caching enabled.
Public property EnableTheming  Gets a value indicating whether this control supports themes. (inherited from DataSourceControl)
Public property 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)
Public property FilterExpression Gets or sets a filtering expression that is applied when the Select method is called.
Public property FilterParameters Gets a collection of parameters that are associated with any parameter placeholders that are in the FilterExpression string.
Public property ID  Gets or sets the programmatic identifier assigned to the server control. (inherited from Control)
Public property InsertCommand Gets or sets the SQL string that the SqlDataSource control uses to insert data into the underlying database.
Public property 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.
Public property 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.
Public property 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)
Public property OldValuesParameterFormatString Gets or sets a format string to apply to the names of any parameters that are passed to the Delete or Update method.
Public property Page  Gets a reference to the Page instance that contains the server control. (inherited from Control)
Public property Parent  Gets a reference to the server control's parent control in the page control hierarchy. (inherited from Control)
Public property ProviderName Gets or sets the name of the .NET Framework data provider that the SqlDataSource control uses to connect to an underlying data source.
Public property SelectCommand Gets or sets the SQL string that the SqlDataSource control uses to retrieve data from the underlying database.
Public property 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.
Public property 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.
Public property Site  Gets information about the container that hosts the current control when rendered on a design surface. (inherited from Control)
Public property SkinID  Gets the skin to apply to the DataSourceControl control. (inherited from DataSourceControl)
Public property 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.
Public property SqlCacheDependency Gets or sets a semicolon-delimited string that indicates which databases and tables to use for the Microsoft SQL Server cache dependency.
Public property TemplateControl  Gets or sets a reference to the template that contains this control. (inherited from Control)
Public property TemplateSourceDirectory  Gets the virtual directory of the Page or UserControl that contains the current server control. (inherited from Control)
Public property UniqueID  Gets the unique, hierarchically qualified identifier for the server control. (inherited from Control)
Public property UpdateCommand Gets or sets the SQL string that the SqlDataSource control uses to update data in the underlying database.
Public property 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.
Public property 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.
Public property Visible  Gets or sets a value indicating whether the control is visually displayed. (inherited from DataSourceControl)
Top

  Name Description
Protected property Adapter  Gets the browser-specific adapter for the control. (inherited from Control)
Protected property ChildControlsCreated  Gets a value that indicates whether the server control's child controls have been created. (inherited from Control)
Protected property ClientIDSeparator  Gets a character value representing the separator character used in the ClientID property. (inherited from Control)
Protected property Context  Gets the HttpContext object associated with the server control for the current Web request. (inherited from Control)
Protected property DesignMode  Gets a value indicating whether a control is being used on a design surface. (inherited from Control)
Protected property Events  Gets a list of event handler delegates for the control. This property is read-only. (inherited from Control)
Protected property HasChildViewState  Gets a value indicating whether the current server control's child controls have any saved view-state settings. (inherited from Control)
Protected property IdSeparator  Gets the character used to separate control identifiers. (inherited from Control)
Protected property IsChildControlStateCleared  Gets a value indicating whether controls contained within this control have control state. (inherited from Control)
Protected property IsTrackingViewState  Gets a value that indicates whether the server control is saving changes to its view state. (inherited from Control)
Protected property IsViewStateEnabled  Gets a value indicating whether view state is enabled for this control. (inherited from Control)
Protected property LoadViewStateByID  Gets a value indicating whether the control participates in loading its view state by ID instead of index. (inherited from Control)
Protected property 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)
Protected property ViewStateIgnoresCase  Gets a value that indicates whether the StateBag object is case-insensitive. (inherited from Control)
Top

Community Additions

ADD
Show:
© 2015 Microsoft