如下函数,请问这样操作,在执行完该函数之后能不能自动关闭dr 和connection?public ArrayList SelectAllPictureSorts(){
using(SqlConnection connection = new SqlConnection(connectionString)) { PictureSort pictureSort=null;
ArrayList pictureSorts = new ArrayList();
using (SqlDataReader dr = SqlHelper.ExecuteReader(connection,CommandType.StoredProcedure,"PictureSortSelectAll")) {
while (dr.Read()){
pictureSort=new PictureSort();
pictureSort.SortID=Convert.ToInt32(dr["SortID"]);
pictureSort.ParentID=Convert.ToInt32(dr["ParentID"]);
pictureSort.SortName=Convert.ToString(dr["SortName"]);
pictureSort.SortLevel=Convert.ToInt32(dr["SortLevel"]);
pictureSort.Descript=Convert.ToString(dr["Descript"]);
pictureSorts.Add(pictureSort);
}
}
return pictureSorts;
}
}