How to drop down 2 columns in a combo box in  (such as item and description)

Posted on 2004-11-16
Last Modified: 2010-04-23
How to drop down 2 columns in a combo box in  (such as item and description)
Totally, I want 3 columns load from a table in sqlServer2000.  The first column is hidden, and use for primary key,  displaying the second column is an item, displaying
the 3rd column is an item description.  when the user clicks the drop down, I want
to get the first column value and display the 2nd and the 3rd column for the user.
Please show the code.  Thanks.
Question by:dotnetdu
    LVL 25

    Accepted Solution

    LVL 27

    Assisted Solution


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now