binding umbraco data to a dropdown control

Paul Griffiths 370 posts 1021 karma points

Feb 25, 2014 @ 11:48

Hello all,

I’m wondering if someone can help me with regards to binding umbraco data to a dropdown control.

I would like to create a datatype that dynamically populates the values of a dropdown list with member properties that are not standard umbraco fields.

I have a property type called Venue name and I would like to display the members name (is a standard field) and the venue name (not standard) in the list. For example

Paul Griffiths -- The Grosvenor

I have tried two methods to achieve this which are as follows. Firstly I installed uComponents and tried the SQL DropDownList datatytpe and using the following SQL I was able to query the database and join and fetch back both the Login name and Email (both standard umbraco fields)

SELECT (LoginName +' - '+ Email) as 'Text', Nodeid as 'Value' FROM cmsMember

INNER JOIN cmsMember2MemberGroup

ON cmsMember.Nodeid = cmsMember2MemberGroup.Member

WHERE cmsMember2MemberGroup.MemberGroup = '1134'

This works fine but I could do with replacing the email field with venue name but I don’t know where to find the data in the database.

With being unable to target the fields I wanted, for my second attempt I tried to create a user control and wrap it in the umbraco user control wrapper but still I have some issues. I have added the following code to user control

   <%@ Control Language="C#" AutoEventWireup="true" CodeFile="VenueOwners.ascx.cs" Inherits="UserControls_VenueOwners" %>


<asp:DropDownList ID="ddlVenueOwners" DataTextField="Name" DataValueField="Id" runat="server" AppendDataBoundItems="true">
    <asp:ListItem Text="Select Venue Owner" Value=""/>
</asp:DropDownList>


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using umbraco.editorControls.userControlGrapper;
using System.Web.UI.WebControls;
using System.Web.Security;
using umbraco.businesslogic;
using umbraco.cms.businesslogic.member;
using umbraco.cms.businesslogic.propertytype;

public partial class UserControls_VenueOwners : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {

            var memberGroup = MemberGroup.GetByName("Venue Owners");
            ddlVenueOwners.DataValueField = "Id";
            ddlVenueOwners.DataTextField = "Name";
            foreach (Member member in memberGroup.GetMembers())
            {
                ddlVenueOwners.DataSource = new[]
                {
                    new {Id = member.getProperty("Id"), Name = member.getProperty("Address")}
                };

            }
            ddlVenueOwners.DataBind();
    }

    public object value
    {
        get { return ddlVenueOwners.SelectedValue; }
        set
        {
            ddlVenueOwners.SelectedValue = (value != null) ? value.ToString() : string.Empty;
        }

    }
}

For testing purposes I have not yet wrapped this up in the umbraco user control wrapper and I have place a macro in a template to see if the user control rendered ok, which it does. However, with using this method I can’t get the fields to populate at all.

There is some material already on the our forum which I have tried to follow but maybe I’m missing something. Can someone please help me and maybe point out where I may be going wrong.

Sorry for the length of this post but I wanted to really make my problem clear.

Thanks in advance

Paul

Flag this post as spam?

Binding umbraco data to a dropdown control