有个递归算法，为什么同一级只能取一条记录？

[zwm945]

sub GetSubTree()
myCommand1 = New OleDb.OleDbCommand("select categoryID,categoryName from category where parentCategoryid='" & categoryID & "' and categoryclass='category' and [language]='" & radioLanguage.SelectedItem.Value & "' order by myorder", myConnection)
myDataReader1 = myCommand1.ExecuteReader
Do While myDataReader1.Read()
dropdownParentID.Items.Add(New ListItem(strT & "├ " & Trim(myDataReader1.Item("categoryName")).Replace(" ", " "), myDataReader1.Item("categoryID")))
getSubTree(myDataReader1.Item("categoryID"))
Loop
end sub

每次循环，先把记录加到一个dropdownlist里，然后对这条记录再递归，取出它所有的子节点，然后再子节点再递归....但要命的是为什么每一层只取第一条记录？即递归调用后没有返回？还是因为用了同一个mydatareader1？

[真相重于对错]

取出数据再递归

[cpp2017]

把数据读到datatable,然后在datatable中select

[zwm945]

在datatable中怎么select啊？有没有代码参考一下？

[haonanernet]

string str="Name = "+"'"+textBox.text+"'";
DataRow[] foundRows;
foundRows = myDataSet.Tables["myDataTable"].Select(str);