dropdown list not selecting record on page load

whyulil · September 8th, 2004, 02:20 AM

Hello again peeps,
I have a drop down list whose values are generated from a database using a datareader. when the employee is selected the page reloads and the form values are set. however the drop down list is not being set so when the update happens the wrong value is entered into the database, a bit annoying to say the least. Im not sure if im using the correct method, is this correct?

Code:

    While objRdr.Read()
        ddlDept.SelectedItem.Value = objRdr.Item("DepartmentID")
    End While

<joke>answers on a self addressed envelope to....</joke>

stu9820 · September 8th, 2004, 08:29 AM

You want to bind the ddl like this:

DropDown1.DataSource = objReader
DropDown1.DataBind