Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • vladzebu 59 posts 346 karma points
    Mar 24, 2012 @ 16:36
    vladzebu
    0

    Sql DropDown List UComponents

    Hi there , 

    can you tell me how i can use Sql DrowDownList from UComponents . 

    I try with : 

    SqlExpresseion: select id  from Database 

    and connectionString is :

    server=server ;database=myDatabase;user id=userId;password=passwordID; 

    but it's not working . What i'm doing wrong ? 

     

    Copy Link
  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    Mar 24, 2012 @ 17:03
    Hendy Racher
    0

    Hi Vladzebu,

    The connection string is optional (it'll use the current Umbraco database if nothing is specifed), and the SELECT statement must return two fields 'Text' and 'Value'.

    Can you confirm that your conection string & SQL expression are working via SQL Management Studio ?

    Thanks,

    Hendy

    Copy Link
  • vladzebu 59 posts 346 karma points
    Mar 24, 2012 @ 19:33
    vladzebu
    1

    Yes , i resolved the problem . 

    I used something like : 

      select field1 as Text , field2  as Value  from Database  . 

    It's works with my  connection string .Problem was with Sql Expression . 

    Cheers , Vlad . 

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft