Back to discussion

Multiple columns for datalist/datacombo

Last post was 01 Oct 2001 at 08:26
databases United States
  • 19 years ago

    I don't know if I'm losing it or what but how do I create multiple columns in a datacombo or datalist like in Access where I can populate each column with a different field.  For example I receive from a query a list of two fields , ID and Name .  I want both to show up in the list and I want the controls to be bounded by let say ID.  How do I do that?

    Report abuse
  • 19 years ago


    use calculated field in your select statement.


    select (ID & NAME) as IDNAME from table

    Report abuse
  • 19 years ago

    I never thought of that thanks


    Mark

    Report abuse
  • 19 years ago

    if you create a calculated field, be sure you make all fields the same length, otherwise you get an ugly combo or data list.
    To have a combo like Access you need to use API to get the same result,
    an it is quite difficult.


    I had a piece of code, if the other solution doesn't fit, i'll look for it in my repository. let me know

    Report abuse
  • 19 years ago

    i have a combo box that act's like an access combo box.
    do you want it?


    [email protected]

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

Database forum discussion

Database tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“Owning a computer without programming is like having a kitchen and using only the microwave oven” - Charles Petzold