This documentation is archived and is not being maintained.
SqlDataSource Members
Visual Studio 2008
Represents an SQL database to data-bound controls.
The SqlDataSource type exposes the following members.
| Name | Description | |
|---|---|---|
|
SqlDataSource | Overloaded. Initializes a new instance of the SqlDataSource class. |
| 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.) |
|
ApplyStyleSheetSkin | Applies the style properties that are defined in the page style sheet to the control. (Inherited from DataSourceControl.) |
|
BuildProfileTree | Infrastructure. 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. |
|
DataBindChildren | Binds a data source to the server control's 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.) |
|
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.) |
|
Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
|
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
|
FindControl | Overloaded. Searches the current naming container for the specified server control. |
|
Focus | Sets input focus to the control. (Inherited from DataSourceControl.) |
|
GetDbProviderFactory | Returns the DbProviderFactory object that is associated with the ADO.NET provider that is identified by the ProviderName property. |
|
GetDesignModeState | Infrastructure. Gets design-time data for a control. (Inherited from Control.) |
|
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
|
GetType | Gets the type of the current instance. (Inherited from Object.) |
|
GetView | Gets the named data source view that is associated with the data source control. (Overrides DataSourceControl::GetView(String).) |
|
GetViewNames | Gets a collection of names representing the list of view objects that are associated with the SqlDataSource control. (Overrides DataSourceControl::GetViewNames().) |
|
HasControls | Determines if the server control contains any child controls. (Inherited from DataSourceControl.) |
|
HasEvents | Returns a value indicating whether events are registered for the control or any child controls. (Inherited from Control.) |
|
Insert | Performs an insert operation using the InsertCommand SQL string and any parameters that are in the InsertParameters collection. |
|
IsLiteralContent | Infrastructure. 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 | Infrastructure. Loads the state of the properties in the SqlDataSource control that need to be persisted. (Overrides Control::LoadViewState(Object).) |
|
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 | Adds a LoadComplete event handler to the Page control that contains the SqlDataSource control. (Overrides Control::OnInit(EventArgs).) |
|
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. |
|
ResolveAdapter | Gets the control adapter responsible for rendering the specified control. (Inherited from Control.) |
|
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.) |
|
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 | Infrastructure. Saves the current view state of the SqlDataSource control. (Overrides Control::SaveViewState().) |
|
Select | Retrieves data from the underlying database by using the SelectCommand SQL string and any parameters that are in the SelectParameters collection. |
|
SetDesignModeState | Sets design-time data for a control. (Inherited from Control.) |
|
SetRenderMethodDelegate | Infrastructure. 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.) |
|
TrackViewState | Infrastructure. Tracks view state changes to the SqlDataSource control so that the changes can be stored in the System.Web.UI::StateBag object for the control. (Overrides Control::TrackViewState().) |
|
Update | Performs an update operation using the UpdateCommand SQL string and any parameters that are in the UpdateParameters collection. |
| Name | Description | |
|---|---|---|
|
FindDataSourceControl | Returns the data source that is associated with the data control for the specified control. (Defined by DynamicDataExtensions.) |
|
FindFieldTemplate | Returns the field template for the specified column within the specified control's naming container. (Defined by DynamicDataExtensions.) |
|
FindMetaTable | Returns the MetaTable object for the containing data control. (Defined by DynamicDataExtensions.) |
| 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.) |
|
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.) |
|
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. |
|
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.) |
|
Visible | Gets or sets a value indicating whether the control is visually displayed. (Inherited from DataSourceControl.) |
| 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. |
| Name | Description | |
|---|---|---|
|
IParserAccessor::AddParsedSubObject | For a description of this member, see IParserAccessor::AddParsedSubObject. (Inherited from Control.) |
|
IListSource::ContainsListCollection | Infrastructure. Indicates whether the data source control is associated with one or more lists of data. (Inherited from DataSourceControl.) |
|
IControlBuilderAccessor::ControlBuilder | For a description of this member, see IControlBuilderAccessor::ControlBuilder. (Inherited from Control.) |
|
IDataBindingsAccessor::DataBindings | For a description of this member, see IDataBindingsAccessor::DataBindings. (Inherited from Control.) |
|
IDataSource::DataSourceChanged | Infrastructure. Occurs when a data source control has changed in a way that affects data-bound controls. (Inherited from DataSourceControl.) |
|
IExpressionsAccessor::Expressions | For a description of this member, see IExpressionsAccessor::Expressions. (Inherited from Control.) |
|
IControlDesignerAccessor::GetDesignModeState | For a description of this member, see IControlDesignerAccessor::GetDesignModeState. (Inherited from Control.) |
|
IListSource::GetList | Infrastructure. Gets a list of data source controls that can be used as sources of lists of data. (Inherited from DataSourceControl.) |
|
IDataSource::GetView | Infrastructure. Gets the named DataSourceView object associated with the DataSourceControl control. Some data source controls support only one view, while others support more than one. (Inherited from DataSourceControl.) |
|
IDataSource::GetViewNames | Infrastructure. Gets a collection of names, representing the list of DataSourceView objects associated with the DataSourceControl control. (Inherited from DataSourceControl.) |
|
IDataBindingsAccessor::HasDataBindings | For a description of this member, see IDataBindingsAccessor::HasDataBindings. (Inherited from Control.) |
|
IExpressionsAccessor::HasExpressions | For a description of this member, see IExpressionsAccessor::HasExpressions. (Inherited from Control.) |
|
IControlDesignerAccessor::SetDesignModeState | For a description of this member, see IControlDesignerAccessor::SetDesignModeState. (Inherited from Control.) |
|
IControlDesignerAccessor::SetOwnerControl | Infrastructure. For a description of this member, see IControlDesignerAccessor::SetOwnerControl. (Inherited from Control.) |
|
IControlDesignerAccessor::UserData | For a description of this member, see IControlDesignerAccessor::UserData. (Inherited from Control.) |
Show: