树视图控件与编辑，更新，降级和添加 [英] Tree view control with edit, update, delate and add

问题描述

创建树视图控件，从database.now绑定的节点值我要动态添加，编辑更新和删除。使用按钮或链接按钮任何东西。帮助我



我尝试过的事情：

Created tree view control,node values binded from database.now i want to add,edit update and delete dynamically.Using buttons or link buttons any thing.help me

What I have tried:

<pre>  protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            tvwItems.Nodes.Clear();
            BindRoots();
        }

    }
    private void BindRoots()
    {
        try
        {
            Page.Header.Title = "Treeview";

            string str = "Select id as ID , sitename  From  recipe_site where isactive=1";
            SqlDataReader reader = GetData(str);

            while (reader.Read())
            {
                TreeNode rootNode = new TreeNode(reader[1].ToString(), reader[0].ToString());
                tvwItems.Nodes.Add(rootNode);
            }
            reader.Close();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }

    private void BindChilds(TreeNode node, int id)
    {

        string str = "Select site as ID , title   From recipe_category where site=" + id;
        SqlDataReader reader = GetData(str);
        while (reader.Read())
        {
            TreeNode childNode = new TreeNode(reader[1].ToString(), reader[0].ToString());
            node.ChildNodes.Add(childNode);
        }
        reader.Close();
    }


    protected void tvwItems_SelectedNodeChanged(object sender, EventArgs e)
    {
        if (!(tvwItems.SelectedNode.ChildNodes.Count > 0))
        {
            BindChilds(tvwItems.SelectedNode, Convert.ToInt32(tvwItems.SelectedNode.Value));
            tvwItems.SelectedNode.Expand();
        }
     
    }

    private SqlDataReader GetData(string commandText)
    {
        //string strConnection = "server=cel38;database=HRMIS010710;user id=sa; connection timeout=60";
        SqlConnection conRecipes = new SqlConnection(ConfigurationManager.ConnectionStrings["constrRecipes"].ConnectionString);
        SqlConnection conUpdb = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
 
        //SqlConnection con = new SqlConnection(strConnection);
        conRecipes.Open();
        SqlCommand sqlcmd = new SqlCommand(commandText, conRecipes);
        SqlDataReader dr = sqlcmd.ExecuteReader();

        return dr;
    }

推荐答案

ASTreeView - 免费的ASP.NET TreeView控件

这篇关于树视图控件与编辑，更新，降级和添加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！