SqlDataSource Members
.NET Framework 3.0
Represents an SQL database to data-bound controls.
The following tables list the members exposed by the SqlDataSource type.
| Name | Description | |
|---|---|---|
| SqlDataSource | Overloaded. Initializes a new instance of the SqlDataSource class. |
(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) |
(see also
Protected Methods
)
Top
| Name | Description | |
|---|---|---|
| ApplyStyleSheetSkin | Applies the style properties that are defined in the page style sheet to the control. (inherited from DataSourceControl) |
| DataBind | Overloaded. Binds a data source to the invoked server control and all its child controls. (inherited from Control) |
| Delete | Performs a delete operation using the DeleteCommand SQL string and any parameters that are in the DeleteParameters collection. |
| Dispose | Enables a server control to perform final clean up before it is released from memory. (inherited from Control) |
| Equals | Overloaded. Determines whether two Object instances are equal. (inherited from Object) |
| FindControl | Overloaded. (inherited from DataSourceControl) |
| Focus | Sets input focus to the control. (inherited from DataSourceControl) |
| GetHashCode | Serves as a hash function for a particular type. (inherited from Object) |
| GetType | Gets the Type of the current instance. (inherited from Object) |
| HasControls | Determines if the server control contains any child controls. (inherited from DataSourceControl) |
| Insert | Performs an insert operation using the InsertCommand SQL string and any parameters that are in the InsertParameters collection. |
| ReferenceEquals | Determines whether the specified Object instances are the same instance. (inherited from Object) |
| RenderControl | Overloaded. (inherited from DataSourceControl) |
| ResolveClientUrl | Gets a URL that can be used by the browser. (inherited from Control) |
| ResolveUrl | Converts a URL into one that is usable on the requesting client. (inherited from Control) |
| Select | Retrieves data from the underlying database using the SelectCommand SQL string and any parameters that are in the SelectParameters collection. |
| SetRenderMethodDelegate | Assigns an event handler delegate to render the server control and its content into its parent control. (inherited from Control) |
| ToString | Returns a String that represents the current Object. (inherited from Object) |
| Update | Performs an update operation using the UpdateCommand SQL string and any parameters that are in the UpdateParameters collection. |
| Name | Description | |
|---|---|---|
| AddedControl | Called after a child control is added to the Controls collection of the Control object. (inherited from Control) |
| AddParsedSubObject | Notifies the server control that an element, either XML or HTML, was parsed, and adds the element to the server control's ControlCollection object. (inherited from Control) |
| BuildProfileTree | Gathers information about the server control and delivers it to the Trace property to be displayed when tracing is enabled for the page. (inherited from Control) |
| ClearChildControlState | Deletes the control-state information for the server control's child controls. (inherited from Control) |
| ClearChildState | Deletes the view-state and control-state information for all the server control's child controls. (inherited from Control) |
| ClearChildViewState | Deletes the view-state information for all the server control's child controls. (inherited from Control) |
| CreateChildControls | Called by the ASP.NET page framework to notify server controls that use composition-based implementation to create any child controls they contain in preparation for posting back or rendering. (inherited from Control) |
| CreateControlCollection | Creates a collection to store child controls. (inherited from DataSourceControl) |
| CreateDataSourceView | Creates a data source view object that is associated with the data source control. |
| DataBind | Overloaded. Binds a data source to the invoked server control and all its child controls. (inherited from Control) |
| DataBindChildren | Binds a data source to the server control's child controls. (inherited from Control) |
| EnsureChildControls | Determines whether the server control contains child controls. If it does not, it creates child controls. (inherited from Control) |
| EnsureID | Creates an identifier for controls that do not have an identifier assigned. (inherited from Control) |
| Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (inherited from Object) |
| FindControl | Overloaded. Searches the current naming container for the specified server control. (inherited from Control) |
| GetDbProviderFactory | Returns the DbProviderFactory object that is associated with the ADO.NET provider that is identified by the ProviderName property. |
| GetDesignModeState | Gets design-time data for a control. (inherited from Control) |
| GetView | Overridden. Gets the named data source view that is associated with the data source control. |
| GetViewNames | Overridden. Gets a collection of names representing the list of view objects that are associated with the SqlDataSource control. |
| HasEvents | Returns a value indicating whether events are registered for the control or any child controls. (inherited from Control) |
| IsLiteralContent | Determines if the server control holds only literal content. (inherited from Control) |
| LoadControlState | Restores control-state information from a previous page request that was saved by the SaveControlState method. (inherited from Control) |
| LoadViewState | Overridden. Loads the state of the properties in the SqlDataSource control that need to be persisted. |
| MapPathSecure | Retrieves the physical path that a virtual path, either absolute or relative, maps to. (inherited from Control) |
| MemberwiseClone | Creates a shallow copy of the current Object. (inherited from Object) |
| OnBubbleEvent | Determines whether the event for the server control is passed up the page's UI server control hierarchy. (inherited from Control) |
| OnDataBinding | Raises the DataBinding event. (inherited from Control) |
| OnInit | Overridden. Adds a LoadComplete event handler to the Page control that contains the SqlDataSource control. |
| OnLoad | Raises the Load event. (inherited from Control) |
| OnPreRender | Raises the PreRender event. (inherited from Control) |
| OnUnload | Raises the Unload event. (inherited from Control) |
| OpenFile | Gets a Stream used to read a file. (inherited from Control) |
| RaiseBubbleEvent | Assigns any sources of the event and its information to the control's parent. (inherited from Control) |
| RaiseDataSourceChangedEvent | Raises the DataSourceChanged event. (inherited from DataSourceControl) |
| RemovedControl | Called after a child control is removed from the Controls collection of the Control object. (inherited from Control) |
| Render | Sends server control content to a provided HtmlTextWriter object, which writes the content to be rendered on the client. (inherited from Control) |
| RenderChildren | Outputs the content of a server control's children to a provided HtmlTextWriter object, which writes the content to be rendered on the client. (inherited from Control) |
| RenderControl | Overloaded. Outputs server control content and stores tracing information about the control if tracing is enabled. (inherited from Control) |
| ResolveAdapter | Gets the control adapter responsible for rendering the specified control. (inherited from Control) |
| SaveControlState | Saves any server control state changes that have occurred since the time the page was posted back to the server. (inherited from Control) |
| SaveViewState | Overridden. Saves the current view state of the SqlDataSource control. |
| SetDesignModeState | Sets design-time data for a control. (inherited from Control) |
| TrackViewState | Overridden. Tracks view state changes to the SqlDataSource control so that the changes can be stored in the cSystem.Web.UI.StateBag object for the control. |
| Name | Description | |
|---|---|---|
| DataBinding | Occurs when the server control binds to a data source.(inherited from Control) |
| Deleted | Occurs when a delete operation has completed. |
| Deleting | Occurs before a delete operation. |
| Disposed | Occurs when a server control is released from memory, which is the last stage of the server control lifecycle when an ASP.NET page is requested.(inherited from Control) |
| Filtering | Occurs before a filter operation. |
| Init | Occurs when the server control is initialized, which is the first step in its lifecycle.(inherited from Control) |
| Inserted | Occurs when an insert operation has completed. |
| Inserting | Occurs before an insert operation. |
| Load | Occurs when the server control is loaded into the Page object.(inherited from Control) |
| PreRender | Occurs after the Control object is loaded but prior to rendering.(inherited from Control) |
| Selected | Occurs when a data retrieval operation has completed. |
| Selecting | Occurs before a data retrieval operation. |
| Unload | Occurs when the server control is unloaded from memory.(inherited from Control) |
| Updated | Occurs when an update operation has completed. |
| Updating | Occurs before an update operation. |
Community Additions
ADD
Show: