生成树的问题！！！

[zhangzb1016]

private void StudyBsForm_Load(object sender, System.EventArgs e)
{

StudentClass StuClass = new StudentClass();
SqlDbConn = StuClass.StudentConn();
Sqlcomm = new SqlCommand("select distinct convert(char(4),year(dtm_rxsj)) as rxsj from student order by rxsj",SqlDbConn);
SqlDataReader SqlDr =Sqlcomm.ExecuteReader();
while (SqlDr.Read())
{

TreeNode Tv = new TreeNode();
string TrDateStr = SqlDr["rxsj"].ToString();
Tv.Text = TrDateStr + "年入学的：";
treeView1.Nodes.Add(Tv);
AddSeTree(TrDateStr);

}
}
private void AddSeTree(string SqlQyer)
{

string SubStr = string.Format("select convert(char(2),int_class) as bj from student where convert(char(4),year(dtm_rxsj)) = '{0}'",SqlQyer);
SqlCommand Sqlcomm1 = new SqlCommand(SubStr,SqlDbConn);
SqlDataReader SqlDr1 = Sqlcomm1.ExecuteReader();

while (SqlDr1.Read())
{

treeView1.Nodes[i].Nodes.Add(new TreeNode(SqlDr1["bj"].ToString()));
i++;

}
Sqlcomm1.Dispose();
SqlDr1.Close();

}
}
请问在上面的代码中生成树时报 SqlDataReader 对象已经打开，请使用之前关闭！

此问题如何解结，有更好的办法吗？请告知！！！1

[reokok]

SqlDataReader SqlDr =Sqlcomm.ExecuteReader();
while (SqlDr.Read())
{

TreeNode Tv = new TreeNode();
string TrDateStr = SqlDr["rxsj"].ToString();
Tv.Text = TrDateStr + "年入学的：";
treeView1.Nodes.Add(Tv);
AddSeTree(TrDateStr);

}
SqlDr.Close();
我是才鸟

[lonk]

报错的是那个sqlDataReader?上面那个还是下面那个?
你上面的sqlDrl用完也把它close掉试试

[zhangzb1016]

不行，lonk！上面的sqldr报错，因为sqldr在循环体内，不能关的，要不然下次循环时就不能sqldr.read()了，你有好的办法吗？？