Setup Custom Data Source

The Centralpoint Data Source returns rows and columns which represent Data Table.
You can setup a custom data source by following those steps:
Create CustomDataSource.cs file and move that file into Root/App_code/Custom directory

using Centralpoint.Web;
using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data;
using System.Web;

namespace Centralpoint.WebSite
{
    /// <remarks>
    /// This class is used to execute scripts.
    /// </remarks>
    public partial class CpScripting
	{
        public static DataTable CustomDataSource(Page page, string parameters)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("AutoNumber", typeof(int));
            dt.Columns.Add("DataId", typeof(Guid));
            dt.Columns.Add("Title", typeof(string));
            dt.Columns.Add("AudienceSystemName", typeof(string));
            dt.Columns.Add("Parameters", typeof(string));

            string audienceSystemName = page.AudienceInfo.SystemName;

            dt.Rows.Add(1, Guid.NewGuid(), "Sample Record 1", audienceSystemName, parameters);
            dt.Rows.Add(2, Guid.NewGuid(), "Sample Record 2", audienceSystemName, parameters);
            dt.Rows.Add(3, Guid.NewGuid(), "Sample Record 3", audienceSystemName, parameters);
            dt.Rows.Add(4, Guid.NewGuid(), "Sample Record 4", audienceSystemName, parameters);
            return dt;
        }
    }
}

Navigate to Console > Design > Data Sources
Click add new
Data Source Select custom
in Method Name set CustomDataSource
in Parameters type Sample
Click Formatting Tab
Formatting Options Set to Raw HTML
Item Content paste the following code

<div>
 [cp:scripting key='Column' name='Title' /]<br>
 [cp:scripting key='Column' name='AutoNumber' /]<br>
 [cp:scripting key='Column' name='DataId' /]<br>
 [cp:scripting key='Column' name='Parameters' /]<br>
 [cp:scripting key='Column' name='AudienceSystemName' /]<br>
</div>

As you can see the columns set in the dataTable match the names used in the Colum cp:script.
Save Data Source
Click Preview Link in the Console grid

- Code Examples