Dynamic list based on DB-values

Tobias Gladh

Vote:

Is there a way to make a Dynamic list property to be based on information that we currently have in a customer database? What I'm trying to accomplish is displaying certain data from the customers database based on what the editor sets on the page and to elminate problems that editors fill in the wrong values I would like the Dynamic list data to be based on information from the database.

Example:

Table1: Persons | Columns: Id, Name

Table2: PersonInformation | Columns with different information.

What I want to accomplish i so that the Dynamic list data i based on values in Table1: Persons and then the page list the information for that person based on the id-value set in the Dynamic list.

Is there a solution for this?

#45757

Nov 16, 2010 14:30

Magnus Rahl

Vote:

You can do that with a custom property and/or dynamic content. Let the user select the person/persons in a dropdown or checkboxlist and then perform whatever logic you need to render the corresponding list.

#45760

Nov 16, 2010 15:22

David Knipe

Vote:

You could use page providers to pull the information into the EPiServer page tree. Editors can then select a page that represents the customer and use the information in the page provider page to display. Obviously depending on the number of customers you will need to structure the tree appropriately.

http://world.episerver.com/Articles/Items/Introducing-Page-Providers/

#45772

Nov 16, 2010 21:48

Tobias Gladh

Vote:

My basic thought was to create a custom property. Though I was hoping that there could be a simpler way, perhaps by using attributes on a class that just returned a collection with (string, string) items to be used the same way as you would set in the config.

#45791

Nov 17, 2010 11:09