各位大侠，小弟急需一个能连接数据库的树型下拉列表框源码，js或c#的都可以。我定会高分相送

各位大侠，小弟急需一个能连接数据库的树型下拉列表框源码，js或c#的都可以。

解决方案 »

  1.   

    date.jsp 
     
    <%@ page contentType="application/javascript;charset=UTF-8" %>var jsTreeData = [
    <%
    String branch = "0";
    String leaf = "1";//String[][] data = null;
    //查询数据库
    //...String[][] data = {
    {"1","桂林路","0",branch},
    {"2","千岛湖","1",branch},
    {"3","千岛湖ＮＯＤＥＢ","2",branch},
    {"4","上海师大小区","3",leaf},
    {"5","桂林路公园","3",leaf},
    {"6","桂林路口","3",leaf},
    {"7","好又多超市","2",leaf},
    {"8","田林路口","1",leaf},
    {"9","虹桥机场","0",leaf}
    };for (int i = 0; i < data.length-1; i++) {
    %>
    {id:'<%=data[i][0]%>',content:'<%=data[i][1]%>',parent:'<%=data[i][2]%>',type:<%=data[i][3]%>},
    <%
    }
    %>
    {id:'<%=data[data.length-1][0]%>',content:'<%=data[data.length-1][1]%>',parent:'<%=data[data.length-1][2]%>',type:<%=data[data.length-1][3]%>}
    ]
    *index.jsp
    <!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>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>JsTree Example</title>
    <script type="text/javascript" src="scripts/prototype-mini.js"></script>
    <script type="text/javascript" src="scripts/jstree.js"></script>
    <link href="styles/jstree.css" rel="stylesheet" type="text/css" />
    </head>
    <body>
    <div id='tree1'></div>
    </body>
    </html>
    <script type="text/javascript">
    var jsTree = new JsTree.TreeView({element:'tree1',imagePath:'styles/images/'});
    jsTree.load('data.jsp');
    </script>
      

  2.   

    小弟是初学者，所以请求各位大侠相助。
    我需要的是一个连接数据库的下拉树，是从数据库中取数据的，可以使sql中系统数据库northwind等为例