Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    25

    Unanswered: DropDownList Items

    I just got my page to work, but there still is a problem. My drop down list is not populated by the EmployeeID's that it should be. Rather, "System.Data.Common.DbDataRecord" appears muliple times. Any clue how to get the EmployeeID's to show?

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Not without seeing your code. Can you post it?
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    And one way to not have something appear multiple times even though it might be stored in multiple records is to use the word DISTINCT in the SQL statement:

    strSQL = "SELECT DISTINCT EmpID FROM MyTable ORDER BY EmpID"
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •