Kentico CMS 7.0 Controls

Overview

Overview

Previous topic Next topic Mail us feedback on this topic!  

Overview

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

The QueryDataGrid control displays document data from the Kentico CMS database in a customizable table without the need to write any extra code. Additionally, it allows you to specify the query used to retrieve data through its QueryName property. Only queries stored in the CMS_Query table of the Kentico CMS database can be selected, so if you wish to use a custom query, you must create it there or edit an existing one. The queries can be managed through the administration interface at Site Manager -> Development -> Document types / System tables / Custom tables -> ... Edit (Edit) object ... -> Queries.

 

The QueryDataGrid is derived from the BasicDataGrid control.

 

The standard DataGrid designer can be used to set up QueryDataGrid style and behaviour.

 

Please refer to the Using control properties to set query clauses topic to find information about using properties such as WhereCondition with this control.

 

The portal engine equivalent of the QueryDataGrid control is the Listings and viewers -> Grid with custom query web part.

 

 

 

Please note

 

If you only wish to display data from a specific part of the content tree, please consider using the CMSDataGrid control instead.

 

 

The following topics are available to help you familiarize yourself with the QueryDataGrid control:

 

Getting started - contains a step-by-step tutorial that allows you to learn the basics of using the control

Configuration - describes and explains the properties that can be set for the control

Appearance and styling - describes how the design of the control can be modified