6/13/2013 11:44:51 AM
Display data from non-Kentico SQL database through a structured document
Let me set up the structure I have on my site so that this is more understandable. I have a SQL database that is not the Kentico database that I store information in. I have a series of structured documents that share a single template, therefore the webparts on the template carry over to each structured document. I have a need to display differing information from the SQL database on each of these structured pages. I know I can use query repeaters to pull data from the database because I'm already doing that on other pages, however because these structured pages share a template the repeater would display the same information for each, whereas I need different information from the database on each page. I've tried figuring out if there is an attribute type and form control available through the structured document that will allow me to pull from the external SQL database, but have not found the solution that way. So my question is, can I pull and display different data pieces from a non-Kentico SQL database to display on a structured document that shares a single template with other structured documents?