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 () 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.

 

 

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