binding dropdownlist to reader

Question

Is it possible to bind the dropdownlist with a OledbDataReader as: dropdownlist.datasource=myDataReader; dropdownlist.datavaluefield=myvaluefield; dropdownlist.datatextfield=mytextfield; Thanx in advance.

mohdali81comp · Answer

yes its possible but you have to loop throught the values so each row can has its display value and member value. ex. while (myDataReader.Read()) { dropdownlist.datavaluefield = myDataReader.GetString(0); dropdownlist.datatextfield = myDataReader.GetString(1); }