Click or drag to resize
SQLDataSource Properties

The SQLDataSource type exposes the following members.

Properties
  NameDescription
Public propertyAuthenticationMode
Gets or sets the server authentication mode.
Protected propertyBaseProperties
Data properties
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyCacheDependencies
Cache dependencies, each cache dependency on a new line.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyCacheItemName
Name of the cache item the control will use.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyCacheMinutes
Number of minutes the retrieved content is cached for. Zero indicates that the content will not be cached.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyComponentName
Component name
(Inherited from AbstractUserControl.)
Public propertyConnectionString
Gets or sets complete connection string.
Public propertyControlContext
Control context.
(Inherited from CMSBaseDataSource.)
Public propertyCurrentDocument
Current document
(Inherited from AbstractUserControl.)
Public propertyCurrentPageInfo
Current page info
(Inherited from AbstractUserControl.)
Public propertyCurrentSite
Current site
(Inherited from AbstractUserControl.)
Public propertyCurrentUser
Current user
(Inherited from AbstractUserControl.)
Public propertyDatabaseName
Gets or sets database name.
Public propertyDataSource
Gets or sets source with data.
(Inherited from CMSBaseDataSource.)
Public propertyDisableFilterCaching
Enables or disables filter caching.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyDocumentManager
Document manager control
(Inherited from AbstractUserControl.)
Public propertyEditedObject
Control's edited object
(Inherited from AbstractUserControl.)
Public propertyFilterControl
Data filter control.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyFilterControlPath
Gets or sets the path of the filter control.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyFilteredControl
Filtered control.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyFilterChanged
Property to set and get the Filter changed.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyFilterIsSet
Property to get if the filter is set.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyFilterMode
Allow to set filter mode (useful if same filter is used to filter different items)
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyFilterName
Property to set and get the Filter name.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyHeaderActions
Header actions control
(Inherited from AbstractUserControl.)
Public propertyIsLiveSite
Indicates if control is used on live site.
(Inherited from AbstractUserControl.)
Public propertyIsSelected
Gets or sets the value that indicates whether current data source contains selected item.
(Inherited from CMSBaseDataSource.)
Public propertyLanguage
Gets or sets connection language.
Public propertyLoadPagesIndividually
If true, each page is loaded individually in case of paging.
(Inherited from CMSBaseDataSource.)
Protected propertyMaxRecords
Maximum number of records to get from the database.
(Inherited from CMSBaseDataSource.)
Public propertyMessagesPlaceHolder
Placeholder for messages
(Inherited from AbstractUserControl.)
Protected propertyOffset
Offset where the data retrieved from database should start.
(Inherited from CMSBaseDataSource.)
Public propertyOrderBy
Property to set and get the OrderBy.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyPagerDataItem
Pager data item object.
(Inherited from CMSBaseDataSource.)
Public propertyPagerForceNumberOfResults
Gets or sets the number of result. Enables proceed "fake" datasets, where number of results in the dataset is not correspondent to the real number of results This property must be equal -1 if should be disabled
(Inherited from CMSBaseDataSource.)
Public propertyParameters
Hashtable with additional parameters.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyPassword
Gets or sets password.
Public propertyQueryParameters
Query parameters.
Public propertyQueryText
Gets or sets query text.
Public propertyQueryType
Gets or sets query type. (Standard query or stored procedure.).
Public propertyRelatedData
Related data.
(Inherited from CMSBaseDataSource.)
Public propertyCode exampleResourcePrefix
Prefix for the resource strings which are used for the localization by the control and its child controls.
(Inherited from AbstractUserControl.)
Public propertyResourcePrefixes
List of cached resource prefixes for the parent hierarchy
(Inherited from AbstractUserControl.)
Public propertySelectedColumns
Columns which should be selected.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertySelectedValue
This value is used to initialize filter control according to currently selected value.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyServerName
Gets or sets database server name.
Public propertyShortID
Short ID of the control.
(Inherited from AbstractUserControl.)
Public propertySiteID
Property to set and get the filter SiteID.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertySiteName
Property to set and get the SiteName.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertySourceFilterControl
Gets the source filter control.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertySourceFilterName
Gets or sets the source filter name.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyStopProcessing
Stop processing.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyTimeout
Gets or sets connection timeout (240 seconds by default).
Public propertyToggleAdvancedModeButton
Gets button used to toggle filter's advanced mode.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyTopN
Property to set and get the Top N property.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyTotalRecords
Total number of records.
(Inherited from CMSBaseDataSource.)
Public propertyUIContext
Control's UI Context
(Inherited from AbstractUserControl.)
Public propertyUniPagerControl
Pager control.
(Inherited from CMSBaseDataSource.)
Public propertyUserName
Gets or sets user name.
Public propertyUsesLocalMessagesPlaceHolder
Indicates if control uses local messages placeholder
(Inherited from AbstractUserControl.)
Public propertyValue
Filter value.
(Inherited from CMSAbstractBaseFilterControl.)
Public propertyWhereCondition
Property to set and get the WhereCondition.
(Inherited from CMSAbstractBaseFilterControl.)
Top
See Also