[thelist] ASP.NET dropdownlist error

[Joel D Canfield]

> 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
DeptID.

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

joel