myRead循环怎么写啊?~

Question

DropDownList myDDunit=DetailsViewMove.FindControl("DropDownListUnitList") as DropDownList;
        string connectionString = ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString;
        SqlConnection myConnection = new SqlConnection(connectionString);
        myConnection.Open();
        String SQLconn = "select * from department where unitid=" + myDDunit.SelectedValue.ToString();
        SqlCommand myCommand = new SqlCommand(SQLconn, myConnection);
        SqlDataReader myReader = myCommand.ExecuteReader();
        myReader.Read(); DropDownList myDD = DetailsViewMove.FindControl("DropDownListDepartmentList") as DropDownList;
        if (myDD != null)
        {
            myDD.Items.Clear();
            myDD.Items.Add(new ListItem(myReader["部门名称"].ToString()));
        }求各位指点!!

Answer 1

DropDownList myDD = DetailsViewMove.FindControl("DropDownListDepartmentList") as DropDownList;
        if (myReader.Read())
        {
            myDD.Items.Clear();
            myDD.Items.Add(new ListItem(myReader["部门名称"].ToString()));
        }

Answer 2

        while(myReader.Read())
        {
            myDD.Items.Clear();
            myDD.Items.Add(new ListItem(myReader["部门名称"].ToString()));
        }

Answer 3

int i = 0;
 while(myReader.Read())
        {
            myDD.Items.Clear();
            myDD.Items.Add(new ListItem(myReader["部门名称"].ToString()));            i++;
        }