5 votes

DropDown with Sql Source

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. 

Installation

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.

 

Screenshots

Package owner

Mirela Budaes

Mirela Budaes

Mirela has 94 karma points

Package Compatibility

This package is compatible with the following versions as reported by community members who have downloaded this package:
Untested or doesn't work on Umbraco Cloud
8.1.x (untested)
8.0.x (untested)
7.14.x (untested)
7.13.x (untested)
7.12.x (untested)
7.11.x (untested)
7.10.x (untested)
7.9.x (untested)
7.8.x (untested)
7.7.x (untested)
7.6.x (untested)
7.5.x (untested)
7.4.x (untested)
7.3.x (untested)
7.2.x (untested)
7.1.x (untested)
7.0.x (untested)
6.1.x (untested)
6.0.x (untested)

You must login before you can report on package compatibility.

Package Information

  • Package owner: Mirela Budaes
  • Created: 08/06/2010
  • Current version 1.1
  • License MIT
  • Downloads: 1720

External resources