|
|
Default
|
|
|
|
|
Web part control ID:
|
Serves as an identifier for the web part. This ID must be unique within the context of each page template. The value of this property may only contain alphanumeric characters and the underscore character ( _ ).
|
|
|
|
Web part title:
|
Title of the web part displayed on the Design tab of CMS Desk and in on-site editing mode. If empty, the value of the Web part control ID property is used for this purpose.
|
|
| | | |
|
|
Connection
|
|
|
|
|
Server name:
|
Sets the name of the database server from which the data should be loaded. If both the Server name and Connection string properties are empty, the application connection string is used by default (this connects to the Kentico CMS database).
|
|
|
|
Authentication mode:
|
Selects which authentication mode is used to connect to the SQL server (SQL server authentication or Windows authentication).
|
|
|
|
Database name:
|
Specifies the name of the source database.
|
|
|
|
User name:
|
User name to be used for SQL server authentication.
|
|
|
|
Password:
|
Password to be used for SQL server authentication.
|
|
|
|
Timeout:
|
Sets the time to wait (in seconds) for the connection to successfully open.
|
|
|
|
Language:
|
Specifies the language of the connection. (English by default)
|
|
| | | |
|
|
Connection string
|
|
|
|
|
Connection string:
|
Can be used to enter a complete connection string for the database connection. If both the Server name and Connection string properties are empty, the application connection string is used by default (this connects to the Kentico CMS database).
|
|
| | | |
|
|
Query
|
|
|
|
|
Query type:
|
Selects the type of the used query. It can be either a standard SQL query or a stored procedure.
|
|
|
|
Query text:
|
The text of the query that will be used to retrieve the data.
|
|
| | | |
|
|
System settings
|
|
|
|
|
Cache item name:
|
Sets the name of the cache key used for the content of the web part. If not specified, this name is generated automatically based on the site, document path, Web part control ID and current user. A cache key can be shared between multiple web parts with the same content on different pages in order to avoid keeping redundant data in the memory.
|
|
|
|
Cache minutes:
|
Sets the number of minutes for which the content of the web part should remain cached before its latest version is reloaded from the database. If left empty, the value entered into the Site Manager -> Settings -> System -> Performance -> Cache content (minutes) setting will be used instead. If set to 0, caching will be disabled for the web part.
|
|
|
|
Cache dependencies:
|
Contains a list of cache keys on which the partial cache of the web part depends. When the specified cache items change, the partial cache of the web part is deleted. Each line may contain a single item only. If the 'Use default cache dependencies' box is checked, the default dependencies will be used, which include all possible object changes that could affect the specific web part.
|
|
| | | |
|
|
Performance
|
|
|
|
|
Disable view state:
|
Indicates if view state should be disabled for this web part.
|
|
|
|
Disable macros:
|
If checked, macros contained in the values of the web part's properties will no longer be resolved.
|
|
| | | |
Help URL: http://devnet.kentico.com/docs/webparts/index.html?SQLDataSource_properties.htm
