.net 中 DropDownList 以及select 控件 的填充方法

一. 如果仅仅填充TEXT属性,不填充值的话        

       String queryAllDesigner = "select desigener_name from desigener "; sqlCom.CommandText = queryAllDesigner; //ddl_designer 是一个DropDownList reader = sqlCom.ExecuteReader(); while(reader.Read()) { ddl_designer.Items.Add(reader["desigener_name"]+""); }

 

 

 

二.  值和TEXT同时填充

 

String queryAllDesigner = "select desigener_name from desigener "; sqlCom.CommandText = queryAllDesigner; reader = sqlCom.ExecuteReader(); while(reader.Read()) { ListItem item = new ListItem(reader["desigener_name"]+"", reader["desigener_name"]+""); ddl_designer.Items.Add(item); }