SQL query in an ASPX "Expressions Web" page to a database (beginner)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • toddwerts
    New Member
    • Mar 2007
    • 1

    SQL query in an ASPX "Expressions Web" page to a database (beginner)

    I have an aspx page with some form controls in it. They all work fine except for one thing, the control (list) that is populated based on the selected item in the first control (dropdownlist1) is only showing the element ID, not the "name" which I want.

    So, I think I just need a pretty simple join query to get the name property.

    I need to get the Capability name (capability_nam e) from the Capability Table where the capabilityid in the Capability table matches the capabilityid in the Cap_Cap_Hierarc hy_Rel Table AND parentid in the Cap_Cap_Hierarc hy_Rel Table = dropdownlist1.s elected (selected capability in the dropdown in the form)


    Thank you!!!!
Working...