[thelist] ASP.NET dropdownlist error

Joel D Canfield joel at streamliine.com
Wed Sep 26 10:52:47 CDT 2007

> modify your query as to select dept id too
> *SELECT DeptId,DeptName FROM Departments ORDER BY DeptId
> *

Tried that; as stated in my first post, the original query was

    select id, DeptName from Departments order by DeptName

and DataValueField was set to id

I also tried aliasing id as DeptID in both places.

Then, I added it to the overall query for this row of data, aliased as

In every case, however I combine it, if I include Departments.id the
page fails; if I only use Departments.deptname, it works.


More information about the thelist mailing list