public static void jiedian(TreeView tv)
{
string sql = "select ware_sort from ware_item_setup";
string sql1 = "select i.ware_sort,w.item_name from ware_item_setup i join ware_setup w on i.sort_id= w.sort_id";
SqlDataReader sr = DAL.Dxadd.getadd_datareader(sql);
SqlDataReader st1 = DAL.Dxadd.getadd_datareader(sql1);
while(sr.Read())
{
string Ware_sort = sr["ware_sort"].ToString();
TreeNode tr = new TreeNode(Ware_sort);
tv.Nodes.Add(tr);
while (st1.Read())
{
string ware_sort = st1["ware_sort"].ToString(); if (Ware_sort == ware_sort)
{
TreeNode ctr = tr.Nodes.Add(st1["item_name"].ToString()); }
}
最后一个while只能读取一次就读取不进去了..如图显示的..该怎么改?一定要用数组么?
{
string sql = "select ware_sort from ware_item_setup";
string sql1 = "select i.ware_sort,w.item_name from ware_item_setup i join ware_setup w on i.sort_id= w.sort_id";
SqlDataReader sr = DAL.Dxadd.getadd_datareader(sql);
SqlDataReader st1 = DAL.Dxadd.getadd_datareader(sql1);
while(sr.Read())
{
string Ware_sort = sr["ware_sort"].ToString();
TreeNode tr = new TreeNode(Ware_sort);
tv.Nodes.Add(tr);
while (st1.Read())
{
string ware_sort = st1["ware_sort"].ToString(); if (Ware_sort == ware_sort)
{
TreeNode ctr = tr.Nodes.Add(st1["item_name"].ToString()); }
}
最后一个while只能读取一次就读取不进去了..如图显示的..该怎么改?一定要用数组么?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货