Drop down list selected index

[J. Babe]

I am populating a drop down list with a privilege levels from a table
called "Privilege" with the fields "PrivilegeID" and "PrivilegeName".
In a table named "Users", their is a corresponding column
"PrivilegeID" that has a value from the "PrivilegeID" field in the
"Privilege" table.
First I populate the drop down with all the records in "Privilege"
table, setting the .DataValueField property to the "PrivilegeID", then
I want to set the selected index of the dropdown to match the value of
the "PrivilegeID" in the "Users" table. I am wondering what the
easiest way to do this is (or any way that works).

 

[Steve C. Orr, MCSD]

myddl.Items.FindByValue(iPrivilegeID).Selected = True