As follows
CS Code
usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespacetreeview{ Public Partial classFrmtreeview:form {BOOLIsshow =false; PublicFrmtreeview () {InitializeComponent (); TVTREE.NODES.ADD ("Hunan Province"); } Private voidTsmshowadd_click (Objectsender, EventArgs e) { if(!isshow) {DataSet DS=Databasehelper.getdataset (); Addtreenode (DS,"Cf0dbde5-14d6-44be-9f71-4e5d302afc99", Tvtree.topnode); Isshow=true; } } Private voidAddtreenode (DataSet ds,stringFatherkey,treenode Nodes) { varResults = fromResultinchDs. tables[0]. AsEnumerable ()whereResult. field<string> ("Sys_fatherkey") ==FatherkeySelectresult; foreach(varIteminchresults) {TreeNode node=NewTreeNode (); Node. Text= Item. field<string> ("Sys_name"); if(Nodes = =NULL) {tvTree.Nodes.Add (Nodes); } Else{NODES.NODES.ADD (node); } addtreenode (DS, item. Field<string> ("Sys_key"), node); } } }}
View Code
C # Linq Query database (DataSet) generates Tree