Treeview (Classic recursive algorithm)

Last Update:2018-12-03 Source: Internet

Author: User

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

Front-end

<% @ Page Language = "C #" autoeventwireup = "true" codefile = "test_treeview.aspx.cs" inherits = "test_test_treeview" %>
<! Doctype HTML public "-// W3C // dtd xhtml 1.0 transitional // en" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML xmlns = "http://www.w3.org/1999/xhtml">
<Head runat = "server">
<Title> No title page </title>
</Head>
<Body>
<Form ID = "form1" runat = "server">
<Div>
<Asp: Treeview id = "treeview1" runat = "server">
</ASP: Treeview>
</Div>
</Form>
</Body>
</Html>

Background

Using system;
Using system. Data;
Using system. configuration;
Using system. collections;
Using system. Web;
Using system. Web. Security;
Using system. Web. UI;
Using system. Web. UI. webcontrols;
Using system. Web. UI. webcontrols. webparts;
Using system. Web. UI. htmlcontrols;
Using system. Data. sqlclient;
Public partial class test_test_treeview: system. Web. UI. Page
{
Private datatable tblsetorginfo = new datatable (); // store read data
Protected void page_load (Object sender, eventargs E)
{
BIND ();
}
Private void BIND ()
{
String connstr = configurationmanager. connectionstrings ["hrmbookconnectionstring"]. tostring ();
Sqlconnection conn = new sqlconnection (connstr );
Try
{
Conn. open ();
String sqlstr = "select internal Number, category, absindex, itemindex, itemlevel, parentindex, category number, unit number ,"
+ "Organization name, Pinyin code, Organization address, organization phone number, account bank, account, full name of account opening from organization code table order by absindex ";
Sqldataadapter da = new sqldataadapter (sqlstr, Conn );
Da. Fill (tblsetorginfo );
Datatable tempdatatable = tblsetorginfo. Copy (); // save another copy of the Organization table as tempdatatable
Dataview viewsetorginfo = new dataview (tempdatatable); // create a data view
Viewsetorginfo. rowfilter = "itemlevel = 0 ";
// Add all records in the dataset to the tree table one by one based on their relationships
If (viewsetorginfo. Count> 0)
{
Foreach (datarowview myrow in viewsetorginfo)
{
String strenterprisename = myrow ["unit name"]. tostring (). Trim ();
// Add the first node "Provincial Pharmaceutical Group"
This. treeview1.nodes. Add (New treenode (strpolicisename ));
// The initialization parameter here is the first node "Provincial/Pharmaceutical Group", and then this function recursively adds all subnodes
Populatetreeview (strpolicisename, treeview1.nodes [0], myrow );
// Treeview1.selectednode = treeview1.nodes [0]; // select the first node
}
}
}
Catch (exception ex)
{
Response. Write (ex. tostring ());
}
Finally
{
Conn. Close ();
}
}
// --------------- Recursively call the input node information to add all nodes -----------------------
Private void populatetreeview (string parentpart, treenode parentnode, datarowview parentrow)
{
String strenterprisename = "";
Datatable tempdatatable = tblsetorginfo. Copy ();
Dataview viewsetorginfo = new dataview (tempdatatable );
// Filter the child items of the currently passed nodes and add them to the tree chart.
// The judgment method is that if parentindex is equal to the absindex of the passed node, It is the subitem of the node.
Viewsetorginfo. rowfilter = "parentindex = '" + parentrow ["absindex"]. tostring (). Trim () + "'";
// Recursively add all subnodes of each node
Foreach (datarowview myrow in viewsetorginfo)
{
Strenterprisename = myrow ["unit name"]. tostring (). Trim ();
Treenode mynode = new treenode (strenterprisename );
Parentnode. childnodes. Add (mynode );
// Recursive function call. All nodes are added in order.
Populatetreeview (strpolicisename, mynode, myrow );
}
}
}

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More

Treeview (Classic recursive algorithm)

Contact Us

What's Trending

Top 10 Tags

Top 10 Keywords

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support