Kentico CMS 6.0 Controls

Configuration

Configuration

Previous topic Next topic Mail us feedback on this topic!  

Configuration

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

The following properties of the UniGrid control can be set or used in the API:

 

Property Name

Description

Sample Value

Columns

Specifies the columns that should be loaded from the data source specified in the DataSource property.

 

By default, the values of the first column are passed as the actionArgument parameter of the OnAction event handler. This can be overridden in the definition by specifying a column name in the commandargument attribute of individual <action> elements.

 

CompleteWhereCondition

Can be used to get the used WHERE clause including any modifications applied by the filter.

 

DataSource

Can be used to gets or set an object (DataSet or DataTable) containing the data to be displayed by the UniGrid control.

 

DelayedReload

If enabled, data will not be loaded automatically during the Load event of the page and the ReloadData() method must be called manually instead.

 

FilterDirectoryPath

Path to the control (.ascx file) that should be used instead of the default filter. The default relative path is ~/CMSAdminControls/UI/UniGrid/Filters/.

 

FilteredZeroRowsText

Text to be shown when no rows are displayed after the filter is applied.

 

FilterLimit

Determines the minimum amount of rows that must be displayed in the UniGrid before a filter is shown. The default value is read from the CMSDefaultListingFilterLimit web.config key.

 

GridName

Contains the name of an external XML file that defines the structure and behaviour of the UniGrid control. For more information, please refer to the UniGrid definition topic.


GridView

Can be used to access the GridView control encapsulated by the UniGrid.

 

HideControlForZeroRows

Indicates whether the control should be hidden when no rows are loaded. The control is not hidden if the filter causes zero rows to be displayed.

 

ImageDirectoryPath

Path to the directory that contains images used by the control. The default value is ~/App_Themes/Default/Images/Design/Controls/UniGrid/Actions.

 

NamedColumns

Gets a dictionary mapping custom names to DataControlField objects that represent the columns of the UniGrid.

 

The names of columns can be specified in the UniGrid's definition through the name attribute of individual <column> elements.

 

This can be used to access the grid's columns in your code.

 

For example:

 

[C#]

 

UniGrid.NamedColumns["column1"].Visible = false;

 

When executed, this code would hide the column named column1.

 

ObjectType

Can be used to define the data class of the objects that should be loaded as the data source and displayed by the UniGrid control. A list of all available data classes and related information can be found in the CMS_Class database table.

 

Alternatively, the same can be defined in the UniGrid's definition through the <objecttype> element as described in the following topic.

 

Please note that this approach is not supported for classes representing document types (i.e. those whose value in the ClassIsDocumentType column is 1). In these cases, you can load the required data by specifying an appropriate query through the Query property.

 

OrderBy

The ORDER BY clause used to determine how the UniGrid rows are sorted when the page is first loaded.

 

Pager

Can be used to access the UniGridPager control used for paging.


PageSize

This setting can be used to override the default values offered by the page size selection drop‑down list. Values must be separated by commas.

 

The ##ALL## macro can be used as a value to indicate that all rows should be displayed.

 

The default value is “25,50,100,##ALL##”.

"10,20,##ALL##"

Query

Can be used to specify the name of the query that should be used to retrieve data from the Kentico CMS database to be displayed by the UniGrid control. The name is entered in format <class name>.<query name>.

 

Alternatively, the same can be defined in the definition through the <query> element as described in the following topic.

"cms.user.selectallview"

SelectedItems

Gets (as an ArrayList) or sets the currently selected rows from the UniGrid.

 

ShowActionsMenu

Indicates whether the header of the actions column should contain a context menu that provides the option to export the data displayed in the grid into various other formats (Excel, CSV or XML).

 

ShowObjectMenu

Indicates if an action providing a context menu with object actions should automatically be added to the displayed grid. This requires the data source of the UniGrid to be an object type, specified either through the <objecttype> element or the ObjectType property.

 

This menu provides options that can be used to Export, Backup, Restore or Destroy individual listed objects. Some types of objects may not have all menu options available.

 

This action is not added if there is another action specified that has a contextmenu attribute or in cases where there are no actions at all defined for the grid.

 

The default value is true.

 

SortDirect

The ORDER BY clause reflecting the current row sorting being used by the UniGrid.

 

TopN

Specifies the maximum amount of rows that should be selected.

 

WhereCondition

Can be used to get the used WHERE clause without modifications applied by the filter.

 

ZeroRowsText

Text to be shown when the control is hidden by the HideControlForZeroRows property.

 

 

The following events of the UniGrid control are available:

 

Event Name

Description

OnAction

Occurs when one of the actions of the control is used. The name of the given action is passed as a parameter to the handlers of the event. An example of how it is used can be found in the tutorial found in the Getting started topic.

OnExternalDataBound

Occurs after data is loaded. It is used to implement a custom design or functionality for UniGrid columns, including the action column. An example of how it is used can be found in the Implementing custom functionality topic.

OnBeforeDataReload

This event can be used to perform any actions before the ReloadData() method is executed.

OnAfterDataReload

This event can be used to perform any actions after the ReloadData() method is executed.