This datatype provides a dropdown with customizable source.
You can use this if you need to choose from a list with data from the database in a content page.
I needed to choose one customer from the company list of customers.
Download the dll, upload it into your bin folder, add a new datatype and choose DropDownWithSqlSource as Render control. Save and enter the sql query. Add this datatype to a Document Type. In the Content page, you'll see a dropdownlist filled with the results of the sql query.
If you want to cache the items, download the source code and uncomment the lines from 45 to 55 in DropDownWithSource,cs file.
It works in Umbraco 4.5.
Version 1.1 has new features:
- Supports mandatory properties.
- The database type can be chosen.