Export (0) Print
Expand All

SqlDataSource Members

Represents an SQL database to data-bound controls.

The SqlDataSource type exposes the following members.

  NameDescription
Public method SqlDataSource Overloaded. Initializes a new instance of the SqlDataSource class.
Top

  NameDescription
Protected method AddedControl Called after a child control is added to the Controls collection of the Control object. (Inherited from Control.)
Protected method 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.)
Public method ApplyStyleSheetSkin Applies the style properties that are defined in the page style sheet to the control. (Inherited from DataSourceControl.)
Protected method 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.)
Protected method ClearChildControlState Deletes the control-state information for the server control's child controls. (Inherited from Control.)
Protected method ClearChildState Deletes the view-state and control-state information for all the server control's child controls. (Inherited from Control.)
Protected method ClearChildViewState Deletes the view-state information for all the server control's child controls. (Inherited from Control.)
Protected method 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.)
Protected method CreateControlCollection Creates a collection to store child controls. (Inherited from DataSourceControl.)
Protected method CreateDataSourceView Creates a data source view object that is associated with the data source control.
Public method DataBind Overloaded. Binds a data source to the invoked server control and all its child controls.
Protected method DataBindChildren Binds a data source to the server control's child controls. (Inherited from Control.)
Public method Delete Performs a delete operation using the DeleteCommand SQL string and any parameters that are in the DeleteParameters collection.
Public method Dispose Enables a server control to perform final clean up before it is released from memory. (Inherited from Control.)
Protected method EnsureChildControls Determines whether the server control contains child controls. If it does not, it creates child controls. (Inherited from Control.)
Protected method EnsureID Creates an identifier for controls that do not have an identifier assigned. (Inherited from Control.)
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method FindControl Overloaded. Searches the current naming container for the specified server control.
Public method Focus Sets input focus to the control. (Inherited from DataSourceControl.)
Protected method GetDbProviderFactory Returns the DbProviderFactory object that is associated with the ADO.NET provider that is identified by the ProviderName property.
Protected method GetDesignModeState Infrastructure. Gets design-time data for a control. (Inherited from Control.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the type of the current instance. (Inherited from Object.)
Protected method GetView Gets the named data source view that is associated with the data source control. (Overrides DataSourceControl.GetView(String).)
Protected method GetViewNames Gets a collection of names representing the list of view objects that are associated with the SqlDataSource control. (Overrides DataSourceControl.GetViewNames().)
Public method HasControls Determines if the server control contains any child controls. (Inherited from DataSourceControl.)
Protected method HasEvents Returns a value indicating whether events are registered for the control or any child controls. (Inherited from Control.)
Public method Insert Performs an insert operation using the InsertCommand SQL string and any parameters that are in the InsertParameters collection.
Protected method IsLiteralContent Infrastructure. Determines if the server control holds only literal content. (Inherited from Control.)
Protected method LoadControlState Restores control-state information from a previous page request that was saved by the SaveControlState method. (Inherited from Control.)
Protected method LoadViewState Infrastructure. Loads the state of the properties in the SqlDataSource control that need to be persisted. (Overrides Control.LoadViewState(Object).)
Protected method MapPathSecure Retrieves the physical path that a virtual path, either absolute or relative, maps to. (Inherited from Control.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Protected method OnBubbleEvent Determines whether the event for the server control is passed up the page's UI server control hierarchy. (Inherited from Control.)
Protected method OnDataBinding Raises the DataBinding event. (Inherited from Control.)
Protected method OnInit Adds a LoadComplete event handler to the Page control that contains the SqlDataSource control. (Overrides Control.OnInit(EventArgs).)
Protected method OnLoad Raises the Load event. (Inherited from Control.)
Protected method OnPreRender Raises the PreRender event. (Inherited from Control.)
Protected method OnUnload Raises the Unload event. (Inherited from Control.)
Protected method OpenFile Gets a Stream used to read a file. (Inherited from Control.)
Protected method RaiseBubbleEvent Assigns any sources of the event and its information to the control's parent. (Inherited from Control.)
Protected method RaiseDataSourceChangedEvent Raises the DataSourceChanged event. (Inherited from DataSourceControl.)
Protected method RemovedControl Called after a child control is removed from the Controls collection of the Control object. (Inherited from Control.)
Protected method Render Sends server control content to a provided HtmlTextWriter object, which writes the content to be rendered on the client. (Inherited from Control.)
Protected method 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.)
Public method RenderControl Overloaded. Outputs server control content and stores tracing information about the control if tracing is enabled.
Protected method ResolveAdapter Gets the control adapter responsible for rendering the specified control. (Inherited from Control.)
Public method ResolveClientUrl Gets a URL that can be used by the browser. (Inherited from Control.)
Public method ResolveUrl Converts a URL into one that is usable on the requesting client. (Inherited from Control.)
Protected method SaveControlState Saves any server control state changes that have occurred since the time the page was posted back to the server. (Inherited from Control.)
Protected method SaveViewState Infrastructure. Saves the current view state of the SqlDataSource control. (Overrides Control.SaveViewState().)
Public method Select Retrieves data from the underlying database by using the SelectCommand SQL string and any parameters that are in the SelectParameters collection.
Protected method SetDesignModeState Sets design-time data for a control. (Inherited from Control.)
Public method SetRenderMethodDelegate Infrastructure. Assigns an event handler delegate to render the server control and its content into its parent control. (Inherited from Control.)
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Protected method 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().)
Public method Update Performs an update operation using the UpdateCommand SQL string and any parameters that are in the UpdateParameters collection.
Top

  NameDescription
Public Extension Method FindDataSourceControl Returns the data source that is associated with the data control for the specified control. (Defined by DynamicDataExtensions.)
Public Extension Method FindFieldTemplate Returns the field template for the specified column within the specified control's naming container. (Defined by DynamicDataExtensions.)
Public Extension Method FindMetaTable Returns the MetaTable object for the containing data control. (Defined by DynamicDataExtensions.)
Top

  NameDescription
Protected property Adapter Gets the browser-specific adapter for the control. (Inherited from Control.)
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 Infrastructure. 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 null.
Protected property ChildControlsCreated Gets a value that indicates whether the server control's child controls have been created. (Inherited from Control.)
Public property ClientID Gets the server control identifier generated by ASP.NET. (Inherited from DataSourceControl.)
Protected property ClientIDSeparator Gets a character value representing the separator character used in the ClientID property. (Inherited from Control.)
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.
Protected property Context Gets the HttpContext object associated with the server control for the current Web request. (Inherited from Control.)
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.
Protected property DesignMode Gets a value indicating whether a control is being used on a design surface. (Inherited from 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.)
Protected property Events Gets a list of event handler delegates for the control. This property is read-only. (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.
Protected property HasChildViewState Gets a value indicating whether the current server control's child controls have any saved view-state settings. (Inherited from Control.)
Public property ID Gets or sets the programmatic identifier assigned to the server control. (Inherited from Control.)
Protected property IdSeparator Infrastructure. Gets the character used to separate control identifiers. (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.
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.)
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.
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.)
Public property Visible Gets or sets a value indicating whether the control is visually displayed. (Inherited from DataSourceControl.)
Top

  NameDescription
Public event DataBinding Occurs when the server control binds to a data source. (Inherited from Control.)
Public event Deleted Occurs when a delete operation has completed.
Public event Deleting Occurs before a delete operation.
Public event 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.)
Public event Filtering Occurs before a filter operation.
Public event Init Occurs when the server control is initialized, which is the first step in its lifecycle. (Inherited from Control.)
Public event Inserted Occurs when an insert operation has completed.
Public event Inserting Occurs before an insert operation.
Public event Load Occurs when the server control is loaded into the Page object. (Inherited from Control.)
Public event PreRender Occurs after the Control object is loaded but prior to rendering. (Inherited from Control.)
Public event Selected Occurs when a data retrieval operation has completed.
Public event Selecting Occurs before a data retrieval operation.
Public event Unload Occurs when the server control is unloaded from memory. (Inherited from Control.)
Public event Updated Occurs when an update operation has completed.
Public event Updating Occurs before an update operation.
Top

  NameDescription
Explicit interface implemetation Private method IParserAccessor.AddParsedSubObject For a description of this member, see IParserAccessor.AddParsedSubObject. (Inherited from Control.)
Explicit interface implemetation Private property IListSource.ContainsListCollection Infrastructure. Indicates whether the data source control is associated with one or more lists of data. (Inherited from DataSourceControl.)
Explicit interface implemetation Private property IControlBuilderAccessor.ControlBuilder For a description of this member, see IControlBuilderAccessor.ControlBuilder. (Inherited from Control.)
Explicit interface implemetation Private property IDataBindingsAccessor.DataBindings For a description of this member, see IDataBindingsAccessor.DataBindings. (Inherited from Control.)
Explicit interface implemetation Private event IDataSource.DataSourceChanged Infrastructure. Occurs when a data source control has changed in a way that affects data-bound controls. (Inherited from DataSourceControl.)
Explicit interface implemetation Private property IExpressionsAccessor.Expressions For a description of this member, see IExpressionsAccessor.Expressions. (Inherited from Control.)
Explicit interface implemetation Private method IControlDesignerAccessor.GetDesignModeState For a description of this member, see IControlDesignerAccessor.GetDesignModeState. (Inherited from Control.)
Explicit interface implemetation Private method IListSource.GetList Infrastructure. Gets a list of data source controls that can be used as sources of lists of data. (Inherited from DataSourceControl.)
Explicit interface implemetation Private method 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.)
Explicit interface implemetation Private method IDataSource.GetViewNames Infrastructure. Gets a collection of names, representing the list of DataSourceView objects associated with the DataSourceControl control. (Inherited from DataSourceControl.)
Explicit interface implemetation Private property IDataBindingsAccessor.HasDataBindings For a description of this member, see IDataBindingsAccessor.HasDataBindings. (Inherited from Control.)
Explicit interface implemetation Private property IExpressionsAccessor.HasExpressions For a description of this member, see IExpressionsAccessor.HasExpressions. (Inherited from Control.)
Explicit interface implemetation Private method IControlDesignerAccessor.SetDesignModeState For a description of this member, see IControlDesignerAccessor.SetDesignModeState. (Inherited from Control.)
Explicit interface implemetation Private method IControlDesignerAccessor.SetOwnerControl Infrastructure. For a description of this member, see IControlDesignerAccessor.SetOwnerControl. (Inherited from Control.)
Explicit interface implemetation Private property IControlDesignerAccessor.UserData For a description of this member, see IControlDesignerAccessor.UserData. (Inherited from Control.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft