Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Shaun 248 posts 475 karma points
    May 06, 2014 @ 18:12
    Shaun
    0

    Populating a datatype from a database

    Hi

    Does anyone know where I can find some documentation on creating and populating a dropdownlist datatype, where all of the items in the dropdown list are pulled from a table in my database?

    I'm using Umbraco 7 and can't see anything relevant to that.

    Any help gratefully recieved.

    Shaun

  • MK 429 posts 906 karma points
    May 06, 2014 @ 18:53
    MK
    1

    Hi,

    I’m not sure there is a built in datatype in umbraco 7.

    For older version of umbraco there is the uComponent SQL Dropdownlist:

    https://ucomponents.codeplex.com/wikipage?title=SQL%20DropDownList

    I think it should be easy to implement it using WebApi and PetaPoco.

    Have a look at the following links:

    Api: http://our.umbraco.org/documentation/Reference/WebApi/

    PetaPoco: http://creativewebspecialist.co.uk/2013/07/16/umbraco-petapoco-to-store-blog-comments/

    Regards

    Moshe

  • Shaun 248 posts 475 karma points
    May 07, 2014 @ 11:45
    Shaun
    0

    Hi Moshe

    Sadly it needs to be something I can use in V7, ideally AngularJS.

  • MK 429 posts 906 karma points
    May 08, 2014 @ 11:04
    MK
    2

    Hi Shaun,

    Ive created a quick package have a go at this one and let me know if its working ok.

    You can download it from here

    PLEASE BACKUP YOUR SITE AND DB (Nothing should happen but just incase).

    Regards,

    Moshe

  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    May 08, 2014 @ 11:25
    Hendy Racher
    100

    Hi Shaun,

    We've just migrated the Sql DropDownList from uComponents (mentioned above) into nuComponents for v7 - https://github.com/uComponents/nuComponents

     

    (it compiles up to a single dll, which just needs to be dropped into the /bin)

    HTH,

    Hendy

  • Shaun 248 posts 475 karma points
    May 08, 2014 @ 15:22
    Shaun
    0

    That is marvellous! You are a saint!

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies