Pages

Monday, January 9, 2012

Bind Treeview in asp.net c# using dataset

Bind Treeview in asp.net c# using dataset
Introduction : In this article i will show you how to bind treeview in c# using dataset . I have created complete code to bind the treeview and also table structure in image which require for the treeview control to bind in asp.net c# using dataset .
Table structure :
HTML code treeview in asp.net : 
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TreeViewControl.aspx.cs"
    Inherits="HamidSite.TreeViewControl" %>

<!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 runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TreeView ID="treeviwExample"  runat="server" ImageSet="Arrows">
            <HoverNodeStyle Font-Underline="True" ForeColor="#5555DD" />
            <NodeStyle Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" HorizontalPadding="5px" NodeSpacing="0px" VerticalPadding="0px" />
            <ParentNodeStyle Font-Bold="False" />
            <SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px" VerticalPadding="0px" />            
        </asp:TreeView>
    </div>
    </form>
</body>
</html>

C# Code treeview control in asp.net : 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace HamidSite
{
    public partial class TreeViewControl : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack) {
                BindTreeViewControl();
            }
        }
        private void BindTreeViewControl()
        {
            try
            {
                DataSet ds = GetDataSet("Select ProductId,ProductName,ParentId from ProductTable");
                DataRow[] Rows = ds.Tables[0].Select("ParentId IS NULL"); // Get all parents nodes
                for (int i = 0; i < Rows.Length; i++)
                {
                    TreeNode root = new TreeNode(Rows[i]["ProductName"].ToString(), Rows[i]["ProductId"].ToString());
                    root.SelectAction = TreeNodeSelectAction.Expand;
                    CreateNode(root, ds.Tables[0]);
                    treeviwExample.Nodes.Add(root);
                }
            } catch (Exception Ex) { throw Ex; }
        }

        public void CreateNode(TreeNode node , DataTable Dt)
        {
            DataRow[] Rows = Dt.Select("ParentId =" + node.Value);            
            if (Rows.Length == 0) { return; }
            for (int i = 0; i < Rows.Length; i++)
            {
                TreeNode Childnode = new TreeNode(Rows[i]["ProductName"].ToString(), Rows[i]["ProductId"].ToString());
                Childnode.SelectAction = TreeNodeSelectAction.Expand;
                node.ChildNodes.Add(Childnode);
                CreateNode(Childnode, Dt);
            }
        }
        private DataSet GetDataSet(string Query)
        {           
            DataSet Ds = new DataSet();
            try {
                string strCon = @"Data Source=Servername;Initial Catalog=Test;Integrated Security=True"; 
                SqlConnection Con = new SqlConnection(strCon);
                SqlDataAdapter Da = new SqlDataAdapter(Query, Con);
                Da.Fill(Ds);
            } catch (Exception) { }
            return Ds; 
        }
    }
}

For Check / Uncheck Checkboxes in treeview control using jquery you can visit following post :- Check / Uncheck Checkboxes in treeview control using jquery

Related Other posts

35 comments:

  1. arjun aroskarMay 24, 2012 at 2:12 AM

    i

    ReplyDelete
  2. AnonymousNovember 14, 2012 at 5:54 PM

    Hi All,

    I have a table as same with this article and I have a table another with ProductId as Foreign Key also as ParentId. Example:
    Table A
    Id(PK) | ParentId | Name
    1 0 Apple
    2 0 Dell
    3 0 Asus
    4 1 Apple 001
    5 1 Apple 002
    6 2 Dell 001
    7 2 Dell 002
    8 3 Asus 001
    9 3 Asus 002

    Table B
    Id(PK) | AId(FK) | Color
    1 4 Bule
    2 5 Black
    3 6 White
    4 7 Red
    5 8 Pink
    6 9 Yellow

    How can I Bind Treeview in asp.net c# using dataset?Thanks!

    ReplyDelete
  3. UnknownNovember 20, 2012 at 1:44 AM

    how to delete nodes from treeview on a button click bind to dataset??
    plzz can anyone help

    ReplyDelete
  4. UnknownNovember 20, 2012 at 1:45 AM

    i have used code from this example

    ReplyDelete
  5. UnknownFebruary 3, 2013 at 4:40 AM

    Hi,
    Well done,
    How do i change all parents check state when a child is selected(enable three state),
    like this http://www.jeasyui.com/tutorial/tree/tree4.php
    can anyone help me?
    thanks in advance.

    ReplyDelete
  6. AnonymousFebruary 4, 2013 at 10:45 PM

    Hey,really excellent article,it worked out, thanks a lot, more than 2 weeks i was struggling witha tree view , my problem got solved, keep it up, DUDE
    and to pass the values in #SelectedNodeChanged event
    just add this line:Childnode.SelectAction = TreeNodeSelectAction.Select;
    instead of expand give select;

    ReplyDelete
  7. UnknownMarch 13, 2013 at 5:23 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  8. AnonymousMarch 29, 2013 at 4:35 AM

    nice blog
    Dental treatment
    Dental implants in India
    Dental clinic in gurgaon
    Cosmetic dentist in gurgaon
    Gums treatment clinic in delhi
    root canal treatment

    ReplyDelete
  9. AnonymousMarch 30, 2013 at 1:03 AM

    Nice blog
    best dental treatment
    dental tourism in India
    best Dentist in gurgaon
    best cosmetic dentist
    root canal treatment in delhi
    bleeding gums treatment

    ReplyDelete
  10. UnknownAugust 3, 2013 at 12:43 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  11. kuldeepSeptember 18, 2013 at 3:22 AM

    Not working for me.

    ReplyDelete
  12. UnknownNovember 21, 2013 at 1:38 AM

    Thank u a lot..its very useful..

    ReplyDelete
  13. AnonymousJanuary 31, 2014 at 10:47 PM

    hi,
    thx a LoT
    its working smooth and fine

    ReplyDelete
  14. AnonymousMarch 25, 2014 at 8:45 PM

    C# binding TreeView to database table

    ReplyDelete
  15. AnonymousAugust 26, 2014 at 5:20 AM

    thank you so much, your code is working now ^_^

    ReplyDelete
  16. santoshJanuary 3, 2015 at 3:58 AM

    Hi,

    This was very help full to me.

    Thank you :)

    ReplyDelete
  17. UnknownJanuary 16, 2015 at 11:06 PM

    GOOD LOGIC FOR THE DEVELOPERS WHO WANT TO IMPLEMENT THIS STRATEGY :)

    ReplyDelete
  18. UnknownFebruary 24, 2015 at 6:02 AM

    is there any possibility that whn node get clicked we get the messagebox

    ReplyDelete
  19. UnknownFebruary 24, 2015 at 6:03 AM

    its really very urgent i have used this code but i get stucked in node event fired

    ReplyDelete
  20. AtulMarch 18, 2015 at 1:35 PM

    Thanx bro.... Please continue your posting...

    ReplyDelete
  21. عبدالله المعلاويSeptember 29, 2015 at 9:28 PM

    it is not work

    ReplyDelete
  22. mskrishnaNovember 14, 2015 at 7:49 AM

    thanks buddy..
    its really great...

    can anyone tell me that how can i get all childs nodes for particular parent....
    its urgent........

    ReplyDelete
  23. mskrishnaNovember 14, 2015 at 7:51 AM

    can anyone tell me that how can i get all childs nodes for particular parent....
    its urgent........

    ReplyDelete
  24. YashFebruary 25, 2016 at 3:55 AM

    I never expected such a fantastic response to this query. Your solution is far superior to mine--just what I was looking for.


    Packers and Movers Pondicherry

    ReplyDelete
  25. UnknownMarch 25, 2016 at 12:18 AM

    Kabera Global hair transplant is providing
    The Best Hair Transplant in Delhi at best cost available in the Capital city. We have top hair transplant surgeons in our panel in Delhi.

    ReplyDelete
  26. UnknownMarch 25, 2016 at 12:35 AM

    This comment has been removed by the author.

    ReplyDelete
  27. UnknownMarch 25, 2016 at 12:38 AM

    Hair Transplant In Chandigarh Kabera global provide Hair Transplant service in Chandigarh at Affordable price.It gives treatment nearby your location. It provide best solution according to your budget and requirement.

    ReplyDelete
  28. AnonymousNovember 7, 2017 at 11:52 PM

    Love it , it helped me a lot, thanks

    ReplyDelete
  29. AsifMarch 21, 2018 at 7:13 AM

    Where we find that control HamidSite.TreeViewControl

    ReplyDelete
  30. Ion IacobDecember 18, 2018 at 10:26 PM

    Good post, do you have any others on this topic?
    Hair Transplant in Delhi

    ReplyDelete
  31. seoApril 22, 2019 at 1:42 AM

    Hair transplant in pune It is a good article post.Thanks for sharing.

    ReplyDelete
  32. Mais India Medical DevicesJanuary 29, 2021 at 9:46 PM

    Buy the different sizes of iv cannula like 14g to 26g from mais india, For more details visit our website -https://maisindia.com/ivcannula
    Mais India | IV Cannula | Safety IV Cannula

    ReplyDelete
  33. UnknownAugust 12, 2021 at 7:41 AM

    marsbahisbetboo
    sultanbet
    marsbahis
    betboo
    sultanbet

    ReplyDelete
  34. saasOctober 10, 2021 at 7:07 AM

    binance güvenilir mi
    instagram takipçi satın al
    takipçi satın al
    instagram takipçi satın al
    shiba coin hangi borsada
    shiba coin hangi borsada
    tiktok jeton hilesi
    is binance safe
    is binance safe

    ReplyDelete
  35. AnonymousMay 26, 2022 at 5:01 PM

    smm panel
    SMM PANEL
    isilanlariblog.com
    instagram takipçi satın al
    HİRDAVATCİ
    Https://www.beyazesyateknikservisi.com.tr/
    servis
    TİKTOK HİLE İNDİR

    ReplyDelete

Subscribe to: Post Comments (Atom)