Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > getting inf from DataSet View modes: 
User avatar
Member
Member
eagleag - 12/24/2009 6:18:13 AM
   
getting inf from DataSet
Hi,
I'm trying to get some info from a cutomtable.
everything work except the last part when I try and take the info out
of the DataSet.
After query this is what I have
DataSet ds = gn.ExecuteQuery(sql, null, CMS.IDataConnectionLibrary.QueryTypeEnum.SQLQuery, false);


how do I get the info out of there?

tried several way but no lock.
I'm using portal.

THANKS :)
User avatar
Member
Member
Alex Rybin - 12/24/2009 9:06:56 AM
   
RE:getting inf from DataSet
What is a problem with it? ds is empty or some exceptions?

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 12/29/2009 3:42:03 AM
   
RE:getting inf from DataSet
Hello,

could you please optionally try to use following code to get data from custom table:

CMS.SiteProvider.CustomTableItemProvider tp = new
CMS.SiteProvider.CustomTableItemProvider(CMS.CMSHelper.CMSContext.CurrentUser);
DataSet ds = tp.GetItems("CustomTableCodeName", "whereCondition", "OrderBy");

Best Regards,

Martin Dobsicek

Top