How to get Dataset form custom table using API in Kentico
Here are the sample codes for getting the Data(DataSet) from Custom Table:
************************************************************************
CMS.SiteProvider.CustomTableItemProvidertp = new
CMS.SiteProvider.CustomTableItemProvider(CMS.CMSHelper.CMSContext.CurrentUser);
DataSet ds = tp.GetItems("CustomTableCodeName", "whereCondition", "OrderBy");.
************************************************************************