Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > Connecting a BasicDataList to an external Microsoft SQL database View modes: 
User avatar
Member
Member
notoriousFab-hotmail - 10/29/2009 10:08:01 AM
   
Connecting a BasicDataList to an external Microsoft SQL database
Hello,

I would like to know if it is possible to connect a BasicDataList to a table of an external database ?

It seems that it has to use a Datasource Webpart but, if it's the right way to to that, I didn't find how ton configure my SQL connection and query on this datasource webpart.

Thanks for your help

notoriousFab

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 11/2/2009 3:37:46 PM
   
RE:Connecting a BasicDataList to an external Microsoft SQL database
Hello,

You can optionally create copy of BasicDataList web part and modify it to ensure required behavior. Basically you will need to write custom code that will get DataSet with required data from external DB and then bind this dataset to BasicDataList web part.

Best Regards,

Martin Dobsicek