OA 实现treeview单击显示下级节点

Question

ParentNodeId为父节点编号，DisplayOrder为显示顺序，parentNodeId为父节点编号，按照图中数据结构将数据读到TreeView中。为了提高可扩展性，采用递归方法进行无限极添加。

为了提高网站性能，采用用户单击一个一级节点调用相应方法获取该节点下全部子节点的方法来提升网站性能。

怎么才能做到用户单击一个一级节点调用相应方法获取该节点下全部子节点的方法来提升网站性能

---

please verify my account

Answer 1

Hi lctk,

When you click the node,you can get the nodeid in the server side,then in the server side,you can build sql query to get the data,

then assign the data into treeview.

About how to get get hierarchical data in sql server,i suggest that you can refer to the links below:

http://msdn.microsoft.com/en-us/library/ms186243(v=sql.105).aspx

http://blog.sqlauthority.com/2012/04/24/sql-server-introduction-to-hierarchical-query-using-a-recursive-cte-a-primer/

Best Regards,

Kevin Shen.

Answer 2

答案找到了