DrpDownList資料繫結方法

1,
SqlDataReader dr = comm.ExecuteReader();
   //迴圈dr，給dListParent添加條目
   while(dr.Read())
   {
      dListChild.Items.Add(new ListItem(dr[1].ToString(),dr[0].ToString()));
    //也可以這樣
    //dListParent.Items.Add(new ListItem(dr["phone_text"].ToString(),dr["phone_value"].ToString()));
   }

這樣綁定效能高點,且靈活的添加特殊的條目如在while前加:
dListChild.Items.Add(new ListItem("全部選擇","0"));

2,
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
     DataTable dt = new DataTable();
     myAdapter.Fill(dt);

     // 資料繫結 DropDownList 控制項
     DropDownList1.DataSource = dt;
     DropDownList1.DataTextField = "ProductName";
     DropDownList1.DataValueField = "UnitPrice";
     DropDownList1.DataBind();