TreeView

   nodeid(节点id),nodename（节点名字）,parentid（父节点id）这是数据库设计的，下面代买如何修改下 
private void SaveTree(TreeNode treeNode)
        {
            TreeNode parentNode = treeNode.Parent;
            
            string strNodeName = treeNode.Text.ToString();
            if (parentNode==null)
            {
                //string sql1 = "select id from tree";
                //cmd = new SqlCommand(sql1,conn);
                iNodeParentID = -1;
                iNodeID = 1;
            }
            else
            {
                iNodeParentID = iNodeID;
                iNodeID++;    
                while (parentNode!=null)
                {
                    parentNode = parentNode.Parent;
                }
            }
            string sql = "insert into tree (NodeID,NodeName,NodeParentID) values ("+iNodeID+", '"+strNodeName+"', "+iNodeParentID+")";
            cmd = new SqlCommand(sql,conn);
            cmd.ExecuteNonQuery();
           
   
            foreach (TreeNode tn in treeNode.Nodes)
            {
                SaveTree(tn);
            }
         }