发布者：admin 发布时间：2010-7-28 所属栏目：软件工程

---

SqlConnection ConnSql = new SqlConnection("server=.;database=Employess;uid=sa;pwd=123");
            try
            {
                ConnSql.Open();
                SqlCommand Cmd = new SqlCommand("select *from tabitems", ConnSql);
                SqlDataReader reader = Cmd.ExecuteReader();
                //定义对象数组
                TreeNode[] myNodes = new TreeNode[100];

                //初始化对象数组
                for (int i = 0; i < myNodes.Length; i++)
                {
                    myNodes[i] = new TreeNode();
                }

                //从表中取数据
                while (reader.Read())
                {
                    int iParentNodeId = (int)reader["T_ParentNodeID"];
                    int iMyNodeId = (int)reader["T_NodeID"];

                    if (iParentNodeId != 0)
                    {
                        myNodes[iMyNodeId].Text = reader["T_NodeName"].ToString();
                        myNodes[iMyNodeId].NavigateUrl = "#";
//绑定超连接。如果要绑定超链接请在数据库中加一个存放URL的字段
                        myNodes[iParentNodeId].ChildNodes.Add(myNodes[iMyNodeId]);
                    }
                    else
                    {
                        myNodes[iMyNodeId].Text = reader["T_NodeName"].ToString();
                        myNodes[iMyNodeId].SelectAction = TreeNodeSelectAction.None;
                        TreeView1.Nodes.Add(myNodes[iMyNodeId]);
                    }
                }
            }

            catch (System.Exception sqle)
            {
                sqle.ToString().Replace("\n", "<br>");
                Response.Write(sqle);
            }
            finally
            {
                ConnSql.Close();
            }

 

---

评价等级：0 用户对这篇文章进行评级
阅读次数：这篇文章已被阅读 133 次
标签：北大青鸟名师

---

一星 二星 三星 四星 五星

---