从数据库里取数据的DropDownList

 1public static void PhoneList(ref DropDownList ddl, int seatNo)
 2        {
 3            System.Web.UI.WebControls.ListItem oList;
 4            ddl.Items.Clear();
 5            Z_PhoneCollection oPhones = Z_Phone.LoadCollection();     //查出集合
 6            foreach (Z_Phone oPhone in oPhones)　//循环取数据
 7            {
 8                oList = new System.Web.UI.WebControls.ListItem();
 9                oList.Text    = oPhone.PhoneName;
10                oList.Value = oPhone.PhoneId.ToString();
11                if (oPhone.SeatNumber == seatNo) oList.Selected = true;
12                ddl.Items.Add(oList);
13            }
14        }