Is this really the version you are looking for? Kentico Xperience 9 Documentation is no longer updated. Use the switcher in the header to choose your product version.
The system provides a set of web parts that allow you to display data from custom tables on the pages of your website.
Custom table web parts | Description |
|---|---|
Custom table data source | A separate component that loads data stored in custom tables. To display the data, you need to connect the data source to a Basic repeater, Basic datalist or Basic universal viewer web part. |
Custom table datagrid | Loads data from a custom table, and displays selected columns in a table. Contains a built-in custom table data source. You can modify the design of the web part using standard ASP.NET skins. |
Custom table repeater | Load data from a custom table, and display the records in a format based on transformations. Contain a built-in custom table data source. See Writing transformations for custom tables for more information and examples. |
Custom table form | Allows users to manage the data of a custom table on the live site (add new data records or edit existing ones). |
Open the Pages application.
Select the page where you want to display the data.
Switch to the Design tab.
Add one of the web parts that loads custom table data. The Web part properties dialog opens.
Choose the Custom table that you want to display.
Assign a transformation that defines the output format of individual custom table records (skip this step for the web part).
Note: If you are using a separate Custom table data source, you need to set the transformation for the connected basic listing web part.
Click OK.
The web part loads the data from the custom table, and displays the information on the page. The appearance of the data depends on the type of the web part and the assigned transformation.
In addition to creating lists of data, you can use the custom table web parts to display detailed views of individual custom table records. Detail views are useful if the records in your table contain more information than you can display in a list. The web parts identify selected custom table items using a query string URL parameter.
The following steps describe how to extend a list of custom table data to allow users to select and view individual records:
Open the Pages application.
Select the page containing your custom table list.
Configure (double-click) the web part that loads the custom table data.
Enter a name for the selection URL parameter into the Selected item query string key name property (for example itemid).
Type the Field name of the custom table's identifier field (primary key) into the Selected item database column name property.
Set the Selected item validation type according to the data type of the table's identifier field (number, text, or GUID).
Edit the custom table's list transformation and add a detail link into the content. The link's target is the same page, with the addition of the selection query string parameter. Load the parameter's value from the table's identifier field. For example:
<a href='?itemid=<%# Eval("TableID") %>'>View details</a>Create and assign a Selected item transformation that defines the content of the detail view for custom table items.
When a user views the custom table list and clicks the detail link for one of the items:
Tip
You can use URL wildcards to convert the query string parameter in the selection URL into a more user friendly format. For example:
<domain>/CustomTableList.aspx?itemID=10
to:
<domain>/CustomTableList/10.aspx