数据库与递归搭配的技巧

\2]Up;l }:c9L0public partial class _Default : System.Web.UI.Page {protected void Page_Load(object sender, EventArgs e){ if (!IsPostBack){String sqlString = "SELECT * FROM BooksCat ";SqlConnection sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CBooksConnectionString"].ToString());SqlCommand sqlCmd = new SqlCommand(sqlString, sqlConn);51Testing软件测试网2J+?XtB|:Z
DataSet dataSet = new DataSet();
#a'N(Ty1gM8Y P0SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCmd);

51Testing软件测试网(Y@lZ|@
sqlDataAdapter.Fill(dataSet);51Testing软件测试网w%As I*\IC
DataTable dt = dataSet.Tables[0];51Testing软件测试网(@8O*`@;r5?2CI
SetTreeViewNode(dt, "0000", null);
1w)z Q8@ Jx#e3C0}51Testing软件测试网|v8D5gg"b
}
SD
em2^`?P~0private void SetTreeViewNode(DataTable dt  ,51Testing软件测试网ke-V {n@D/N$@
X
string parentID ,
!jd-~~'x0TreeNode treeNode)
*_8k-fm6pZ)fd S0{
`L,Q0tR~Tk0DataView dv = dt.DefaultView;51Testing软件测试网,t&_Y%B"b3P{
dv.Sort = "bookCatIDParent";51Testing软件测试网|{ s/Km"v*T+O/} s/e
DataRowView[] drvs =  dv.FindRows(parentID);
x-`U(ghZzAc;]/Y0if (drvs.Length > 0)
3C$TFU3~0{51Testing软件测试网0p%_QFi^A/G
foreach (DataRowView drv in drvs)
,xdF]7E
c*]b8?0Oa0{             
%y ~/]a*g{5F2e0String bookCatIDParent = drv["bookCatID"].ToString();51Testing软件测试网oE6k%vc
String bookCatDesc = drv["bookCatDesc"].ToString();51Testing软件测试网-Al.z
?[:d'KA p
TreeNode newTreeNode = new TreeNode( bookCatDesc +
`#C Nm-rvvx8@)^'V+K0"[" + bookCatIDParent + "]" );
o3O;Ny5`s0SetTreeViewNode(dt, bookCatIDParent, newTreeNode);
&JC'{[?+[0SetTreeView(treeNode, newTreeNode);
Ks%a#B_|H#\0}
;s
D `:[#ns:\h/V0}51Testing软件测试网)ds!l)A4~8g#cTy\
}
L2~-r"q'L6?+q0private void SetTreeView(TreeNode treeNode, TreeNode newTreeNode)
|:V+Fur_!^0{
vo;F j.xj0if (treeNode == null)
}%Q;Qf7Xg0BookViewTreeView.Nodes.Add(newTreeNode);51Testing软件测试网)^-XKZ*Y5[?r6l
else51Testing软件测试网A KVrU DC'Q
treeNode.ChildNodes.Add(newTreeNode);      51Testing软件测试网c!XI_xMt$~{
}51Testing软件测试网0]%i%d:_N
}