IE Webcontrol Dropdownlist

Discussion in 'ASP .Net Web Controls' started by freddie, Oct 31, 2003.

  1. freddie

    freddie Guest

    I am trying to populate a dropdownlist with data from two
    fields with cod like the following:

    "select OrderNo + ' - ' +OrderName as OrderName from
    Orders "

    This works fine as long as OrderNo and OrderName are both
    Varchar, but OrderNo must now be of type Integer.

    How do I still get both into one dropdownlist?
     
    freddie, Oct 31, 2003
    #1
    1. Advertising

  2. freddie

    Teemu Keiski Guest

    Hi,

    convert the OrderNo to (n)varchar in the query. Then you could concatenate
    it with other (n)varchar value.

    --
    Teemu Keiski
    MCP, Microsoft MVP (ASP.NET), AspInsiders member
    ASP.NET Forum Moderator, AspAlliance Columnist


    "freddie" <> wrote in message
    news:073801c39f8f$3820cfc0$...
    > I am trying to populate a dropdownlist with data from two
    > fields with cod like the following:
    >
    > "select OrderNo + ' - ' +OrderName as OrderName from
    > Orders "
    >
    > This works fine as long as OrderNo and OrderName are both
    > Varchar, but OrderNo must now be of type Integer.
    >
    > How do I still get both into one dropdownlist?
    >
     
    Teemu Keiski, Oct 31, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    2
    Views:
    755
  2. Luis Ramírez.

    Can a webcontrol (webcontrol.dll) have a configuration file?

    Luis Ramírez., Jul 5, 2004, in forum: ASP .Net Building Controls
    Replies:
    2
    Views:
    218
    Luis Ramírez
    Jul 6, 2004
  3. Kasabaarde Sumta

    WebControl inside of WebControl and attaching events

    Kasabaarde Sumta, Dec 13, 2004, in forum: ASP .Net Building Controls
    Replies:
    0
    Views:
    212
    Kasabaarde Sumta
    Dec 13, 2004
  4. Fabricio

    Custom webcontrol that references another webcontrol

    Fabricio, Sep 21, 2005, in forum: ASP .Net Building Controls
    Replies:
    0
    Views:
    201
    Fabricio
    Sep 21, 2005
  5. Peter Morris [Air Software Ltd]

    WebControl with non-WebControl property

    Peter Morris [Air Software Ltd], Dec 7, 2004, in forum: ASP .Net Web Controls
    Replies:
    1
    Views:
    148
    Peter Morris [Air Software Ltd]
    Dec 7, 2004
Loading...

Share This Page