treeview 增删改

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using System.Xml;
using Microsoft.Web.UI.WebControls;
using System.Data.SqlClient;

namespace passworddemo
{
 /// <summary>
 /// **************************************************************
 /// 文件功能:
 /// 上级调用:
 /// 下级调用:
 /// 所用到表:
 /// 参    数: 
 /// 设计思路:
 /// 作    者: xuhu
 /// 开发日期: 2005/05/01
 /// 修改日期:
 /// 其它信息:
 /// **************************************************************
 /// </summary>
 public class WebForm5 : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.Button Button1;
  protected System.Web.UI.WebControls.TextBox role_name;
  protected System.Web.UI.WebControls.TextBox comm;
  protected System.Web.UI.WebControls.Button Button2;
  protected System.Web.UI.WebControls.Button Button3;
  protected Microsoft.Web.UI.WebControls.TreeView TreeView1;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   if(! this.Page.IsPostBack)
   {
    disAllTree(TreeView1);
   }
  }

  public void disAllTree(TreeView tvXmlList)
  {
   tvXmlList.Nodes.Clear();
   //添加根节点
   TreeNode root=new TreeNode();
   //root.ID="r10000";
   root.ID="R00001";
   root.Text="角色管理";
   root.ImageUrl="/webctrl_client/1_0/images/root.gif";
   tvXmlList.Nodes.AddAt(0,root);

   DataTable tb =  MyDB.gettable("SELECT * FROM sys_roletable ORDER BY sj_id"); 
   for(int k=0;k<tb.Rows.Count;k++)
   {
    TreeNode tnCurrent=new TreeNode();
    tnCurrent.ID= tb.Rows[k][0].ToString().Trim();
    tnCurrent.Text= tb.Rows[k][1].ToString().Trim();
   
    if(tb.Rows[k][3].ToString().Trim() == tvXmlList.Nodes[0].ID)
    {    
     tvXmlList.Nodes[0].Nodes.Add(tnCurrent);
    }
    else
    {   
     MyXml.addSubNode(tvXmlList.Nodes[0],tnCurrent,tb.Rows[k][3].ToString().Trim());
    }
   } 

  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.TreeView1.SelectedIndexChange += new Microsoft.Web.UI.WebControls.SelectEventHandler(this.TreeView1_SelectedIndexChange);
   this.Button1.Click += new System.EventHandler(this.Button1_Click);
   this.Button2.Click += new System.EventHandler(this.Button2_Click);
   this.Button3.Click += new System.EventHandler(this.Button3_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void Button1_Click(object sender, System.EventArgs e)
  {//添加
   string fromindex = TreeView1.SelectedNodeIndex;
   try
   {   
    MyData.roletableAdd(TreeView1.GetNodeFromIndex(fromindex).ID,
     role_name.Text,
     comm.Text);
   }
   catch(System.Exception)
   {
    throw new System.Exception("添加失败！");
   }
   disAllTree(TreeView1);
   TreeView1.SelectedNodeIndex = fromindex;   
  }
  
  private void TreeView1_SelectedIndexChange(object sender, Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs e)
  {//节点改变时
    string sqlstring = "SELECT * FROM sys_roletable WHERE (role_id = '"+TreeView1.GetNodeFromIndex(TreeView1.SelectedNodeIndex).ID+"')";
   SqlDataReader rd = MyDB.DataReader(sqlstring);
   if(rd.Read())
   {
    this.role_name.Text = (string)rd["role_name"];
    this.comm.Text = (string)rd["comm"];
   }
  }

  private void Button2_Click(object sender, System.EventArgs e)
  {//删除
      MyData.sys_roletableDelete(TreeView1.GetNodeFromIndex(TreeView1.SelectedNodeIndex).ID);
   TreeView1.GetNodeFromIndex(TreeView1.SelectedNodeIndex).Remove();

  
  }

  private void Button3_Click(object sender, System.EventArgs e)
  { //修改
   string fromindex =  TreeView1.SelectedNodeIndex;
   try
   {   
    MyData.sys_roletableUpdate(
     TreeView1.GetNodeFromIndex(fromindex).ID,
     role_name.Text,
     comm.Text);
    this.Response.Write("<script>alert('数据处理成功！');</script>");
   }
   catch(System.Exception)
   {
    throw new System.Exception("edit失败！");
   }
   disAllTree(TreeView1);
   TreeView1.SelectedNodeIndex = fromindex;   
  }
 }
}