Thaniks for Lisa's input.
Regarding on the problem you mentioned, I agree with Lisa that it is
recommend to preprocess the data earlier than databinding stage.
Dropdownlist is a simple databound control which doesn't provide many
powerful databinding related events(like GridView , DataGrid ..). I think
it will be better to filter or format the data at business or database
BTW, is it possible that you query the list from the database table(through
some select DISTINCT ...... query)? Thus, you can cache the query in
ASP.NET when bind to the dropdownlist and the list of items can match those
ones in database.
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
SelectedValue which is invalid because it does not exist in the list of