Pages

Saturday, January 28, 2012

Sorting, Paging, Add, Update, Delete in GridView asp.net c#

Sorting, Paging, Add, Update, Delete in GridView asp.net c#
Introduction : In this article i will show full functional Gridview with Sorting, Paging , Add ,Update ,delete operation .The GridView control is used to display the values of a data source in a table. It is very useful asp.net control .Here I have written the code for Sorting , Paging , Update , Delete , Add with footer row . 
The Code for All operations in GridVeiw that i have written is very easy understand and easy to implement in you application .

Html Code For Gridview with Sorting, Paging , Add ,Update ,delete operation In Asp.net: 
<table>
    <tr>
        <td>
            <asp:Label ID="lblmsg" runat="server" ForeColor="Red"></asp:Label>
        </td>
    </tr>
    <tr>
        <td>
            <asp:GridView AllowSorting="True" AllowPaging="True" PageSize="3" ID="GVCity" runat="server"
                AutoGenerateColumns="False" OnRowCommand="GVCity_RowCommand" OnPageIndexChanging="GVCity_PageIndexChanging"
                OnSorting="GVCity_Sorting" BackColor="White" BorderColor="#CC9966" BorderStyle="None"
                BorderWidth="1px" CellPadding="4">
                <Columns>
                    <asp:TemplateField HeaderText="City Name" SortExpression="Name" FooterStyle-Width="200px"
                        ItemStyle-Width="200px">
                        <ItemTemplate>
                            <asp:Label ID="lblCityName" Text='<%#Bind("Name")%>' runat="server"></asp:Label>
                            <asp:Label ID="lblCityId" Visible="false" Text='<%#Bind("CityId")%>' runat="server"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="txtEditCityName" Text='<%#Bind("Name")%>' runat="server"></asp:TextBox>
                            <asp:Label ID="lblCityIdEdit" Visible="false" Text='<%#Bind("CityId")%>' runat="server"></asp:Label>
                            <asp:RequiredFieldValidator ID="rfvEditCityname" ValidationGroup="Edit" runat="server"
                                SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtEditCityName"
                                ErrorMessage="Please , Enter City Name."></asp:RequiredFieldValidator>
                        </EditItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtFooterCityName" runat="server"></asp:TextBox>
                            <asp:RequiredFieldValidator ID="rfvFooterCityname" ValidationGroup="Footer" runat="server"
                                SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtFooterCityName"
                                ErrorMessage="Please , Enter City Name."></asp:RequiredFieldValidator>
                        </FooterTemplate>
                        <FooterStyle Width="200px"></FooterStyle>
                        <ItemStyle Width="200px"></ItemStyle>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="STD Code" SortExpression="STDCode" FooterStyle-Width="100px"
                        ItemStyle-Width="100px">
                        <ItemTemplate>
                            <asp:Label ID="lblSTDCOde" Text='<%#Bind("STDCode")%>' runat="server"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="txtEditSTDCOde" Text='<%#Bind("STDCode")%>' runat="server"></asp:TextBox>
                        </EditItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtFooterSTDCOde" runat="server"></asp:TextBox>
                        </FooterTemplate>
                        <FooterStyle Width="100px"></FooterStyle>
                        <ItemStyle Width="100px"></ItemStyle>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <HeaderTemplate>
                            Actions
                        </HeaderTemplate>
                        <FooterTemplate>
                            <table cellpadding="2">
                                <tr>
                                    <td>
                                        <asp:ImageButton ID="imgBtnAdd" CssClass="imgButton" ImageUrl="~/Images/save.png"
                                            runat="server" CommandName="AddSave" ValidationGroup="Footer" ToolTip="Save"
                                            CausesValidation="true" />
                                        <asp:ImageButton ID="ImageBtnCancel" CssClass="imgButton" runat="server" ImageUrl="~/Images/cancel.gif"
                                            CommandName="AddCancel" ToolTip="Cancel" CausesValidation="false" />
                                    </td>
                                </tr>
                            </table>
                        </FooterTemplate>
                        <EditItemTemplate>
                            <table cellpadding="2">
                                <tr>
                                    <td>
                                        <asp:ImageButton ID="imgBtnEditSave" AlternateText="Save" CssClass="imgButton" runat="server"
                                            CommandName="EditSave" ToolTip="Save" ValidationGroup="Edit" CausesValidation="true"
                                            ImageUrl="~/Images/save.png" />
                                        <asp:ImageButton ID="ImageEditCancel" AlternateText="Cancel" CssClass="imgButton"
                                            runat="server" CommandName="EditCancel" CausesValidation="false" ImageUrl="~/Images/cancel.gif"
                                            ToolTip="Cancel" />
                                    </td>
                                </tr>
                            </table>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <table cellpadding="2">
                                <tr>
                                    <td>
                                        <asp:ImageButton ID="imgLanEdit" ImageUrl="~/Images/edit.gif" CssClass="imgButton"
                                            runat="server" CommandName="CityEdit" ToolTip="Edit" />
                                        <asp:ImageButton ID="ImgBtnDelete" ImageUrl="~/Images/delete.gif" CssClass="imgButton"
                                            runat="server" CommandName="CityDelete" ToolTip="Delete" />
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
                <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
                <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
                <RowStyle BackColor="White" ForeColor="#330099" />
                <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                <SortedAscendingCellStyle BackColor="#FEFCEB" />
                <SortedAscendingHeaderStyle BackColor="#AF0101" />
                <SortedDescendingCellStyle BackColor="#F6F0C0" />
                <SortedDescendingHeaderStyle BackColor="#7E0000" />
            </asp:GridView>
        </td>
    </tr>
    <tr>
        <td>
            <asp:Button ID="imgExperiencetInsert" runat="server" Text="Insert Record" OnClick="imgExperiencetInsert_Click" />
        </td>
    </tr>
</table>
C# Code For Gridview with Sorting, Paging , Add ,Update ,delete operation 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 GridviewExample : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblmsg.Text = "";
            if (!IsPostBack)
            {
                BindGridView();
            }
        }
        private string SortDirection
        {
            get
            {
                if (ViewState["SortDirection"] != null)
                    return (String)ViewState["SortDirection"];
                else return "ASC";
            }
            set
            {
                ViewState["SortDirection"] = value;
            }
        }
        private string SortExpression
        {
            get
            {
                if (ViewState["SortExpression"] != null)
                    return ViewState["SortExpression"].ToString();
                else return null;
            }
            set
            {
                ViewState["SortExpression"] = value;
            }
        }
        private void BindGridView()
        {
            try
            {
                DataTable Dt = GetDataTable("Select Name ,stdcode ,Cityid from citytable");
                DataView DV = Dt.DefaultView;

                if (SortExpression != null)
                {
                    DV.Sort = SortExpression + " " + SortDirection;
                }

                GVCity.DataSource = DV;
                GVCity.DataBind();
                if (DV.Count == 0)
                {
                    imgExperiencetInsert.Visible = false;
                }
                else
                {
                    imgExperiencetInsert.Visible = true;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
        private DataTable GetDataTable(string Query)
        {
            DataSet Ds = new DataSet();
            try
            {
                string strCon = @"Data Source=Servername;Initial Catalog=Test;Integrated Security=True;";  //Conntection String
                SqlConnection Con = new SqlConnection(strCon);
                SqlDataAdapter Da = new SqlDataAdapter(Query, Con);
                Da.Fill(Ds);
            }
            catch (Exception) { }
            return Ds.Tables[0];
        }
        private int ExecuteQuery(string Query)
        {
            int RowAffected = 0;
            try
            {
                string strCon = @"Data Source=Servername;Initial Catalog=Test;Integrated Security=True;";  //Conntection String
                SqlConnection Con = new SqlConnection(strCon);
                Con.Open();
                SqlCommand cmd = new SqlCommand(Query, Con);
                RowAffected = (int)cmd.ExecuteNonQuery();
                Con.Close();
            }
            catch (Exception) { }
            return RowAffected;
        }
        /// 
        /// Edit , Update , Delete , Cancel in Gridview using RowCommand in c# Code.
        ///         
        protected void GVCity_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            switch (e.CommandName)
            {
                case "AddCancel":
                    GVCity.EditIndex = -1;
                    imgExperiencetInsert.Enabled = true;
                    GVCity.ShowFooter = false;
                    BindGridView();
                    break;
                case "AddSave":

                    GridViewRow grvAdd = ((GridViewRow)((DataControlFieldCell)((ImageButton)e.CommandSource).Parent).Parent);
                    TextBox txtFooterCityName = (TextBox)grvAdd.FindControl("txtFooterCityName");
                    TextBox txtFooterSTDCOde = (TextBox)grvAdd.FindControl("txtFooterSTDCOde");

                    string InsertQuery = "Insert into cityTable(Name,STDCode) Values('" + txtFooterCityName.Text.Trim() + "','" + txtFooterSTDCOde.Text.Trim() + "')";
                    if (ExecuteQuery(InsertQuery) > 0)
                    {
                        lblmsg.Text = "City Inserted Successfully";
                        imgExperiencetInsert.Enabled = true;
                    }

                    GVCity.ShowFooter = false;
                    BindGridView();

                    break;
                case "CityDelete":
                    GridViewRow grv = ((GridViewRow)((DataControlFieldCell)((ImageButton)e.CommandSource).Parent).Parent);

                    if (grv != null)
                    {
                        Label lblCityId = (Label)grv.FindControl("lblCityId");
                        String DeleteQuery = "Delete from cityTable where cityid =" + lblCityId.Text;
                        
                        if (ExecuteQuery(DeleteQuery) > 0)
                        {
                            lblmsg.Text = "City Deleted Successfully";

                        }
                        BindGridView();
                        break;
                    }

                    break;
                case "CityEdit":
                    GridViewRow grvEdit = ((GridViewRow)((DataControlFieldCell)((ImageButton)e.CommandSource).Parent).Parent);
                    GVCity.EditIndex = grvEdit.RowIndex;
                    BindGridView();
                    break;

                case "EditSave":
                    GridViewRow grvSaveEdit = ((GridViewRow)((DataControlFieldCell)((ImageButton)e.CommandSource).Parent).Parent);

                    TextBox txtEditCityName = (TextBox)grvSaveEdit.FindControl("txtEditCityName");
                    TextBox txtEditSTDCOde = (TextBox)grvSaveEdit.FindControl("txtEditSTDCOde");
                    Label lblCityIdEdit = (Label)grvSaveEdit.FindControl("lblCityIdEdit");

                    string queryUpdate = "update cityTable set Name = '" + txtEditCityName.Text.Trim() + "', STDCode ='" + txtEditSTDCOde.Text.Trim() + "' where cityid=" + lblCityIdEdit.Text;
                    if (ExecuteQuery(queryUpdate) > 0)
                    {
                        lblmsg.Text = "City Updated Successfully";
                        imgExperiencetInsert.Enabled = true;
                    }
                    
                    GVCity.EditIndex = -1;
                    BindGridView();

                    break;
                case "EditCancel":
                    GVCity.EditIndex = -1;
                    BindGridView();
                    break;
            }
        }
        protected void imgExperiencetInsert_Click(object sender, EventArgs e)
        {
            imgExperiencetInsert.Enabled = false;
            GVCity.ShowFooter = true;
            GVCity.EditIndex = -1;
            BindGridView();
        }
        protected void GVCity_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GVCity.PageIndex = e.NewPageIndex;
            BindGridView();
        }
        /// 
        /// Gridview Sorting Code in c#
        ///        
        protected void GVCity_Sorting(object sender, GridViewSortEventArgs e)
        {
            if (SortExpression != null)
            {
                if (SortExpression == e.SortExpression && SortDirection == "ASC")
                    SortDirection = "DESC";
                else
                    SortDirection = "ASC";
            }
            SortExpression = e.SortExpression;
            BindGridView();
        }
    }
}


Related Other posts

Wednesday, January 25, 2012

Pass arguments to String.Format method in c#

Pass arguments to String.Format method in c# 

Introduction : In this article i will show you how to pass the arguments to String.Format method in c# . You need to pass comma separated list of arguments to the string.Format method .There must be argument for each of the place holders .

Following is the example of String.Format in c# :
 
 string Name ="Seta Hamid ";
 string Country ="India";          
 Response.Write( String.Format("My Name is {0}. I am from {1}.", Name, Country));

Output of the string.Format C#.
 
My Name is Seta Hamid . I am from India. 


Related Other posts

Thursday, January 12, 2012

Get Recursive all childs by parentid in sql server

Get Recursive all childs by parentid in sql server 

Introduction : In this article i will show you how to get all recursive childs by parentid in sql server .To get all childs i have used recursive query using with CTE ( Common Table Expressions ) . It is very simple to with parentid and childId relationship table.I have written query for getting recursive child records in sql server is as follow .

Table design for Relationship : 

Query for get all childs by parentid in sql server : 
 
declare @ParentId as int;
set @ParentId =  1;

WITH RecursiveTable (ProductId, ParentId,ProductName, Level)
AS
(    
    SELECT      MaintTab.ProductId, 
                MaintTab.ParentId, 
                MaintTab.ProductName ,
                0 AS Level
    FROM ProductTable AS MaintTab
    WHERE ParentId = @ParentId
    
    UNION ALL
    
    SELECT  MaintTab.ProductId, 
                MaintTab.ParentId, 
                MaintTab.ProductName ,
                LEVEL + 1
    FROM ProductTable AS MaintTab
        INNER JOIN RecursiveTable Rtab ON
        MaintTab.ParentId = Rtab.ProductId
)
SELECT * FROM RecursiveTable

Output of query : 

Related Other posts

Wednesday, January 11, 2012

Chart Control in asp.net 4.0

Chart Control in asp.net 4.0  

Introduction : In this article i will show you how to add Chart control in asp.net 4.0 and how to bind chart control in asp.net with Dataset .You just need to drag the chart control in aspx page so following assembly will be register in your web page and corresponding httpHandlers will be added in web config too .

<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>
Code For Bind Chart Control In asp.net : I have following complete html and code behind code for binding Chart control in c# asp.net. I have here created Bar chart control in asp.net.

HTML Code For Chart Control In asp.net :
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ChartControl.aspx.cs" Inherits="HamidSite.ChartControl" %>

<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>
<!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:Chart ID="ChartControlTest" runat="server" Width="706px" Height="367px">
            <Series>
                <asp:Series Name="SeriesTest" IsValueShownAsLabel="true" Legend="LegendTest" ChartArea="ChartAreaTest"
                    XValueMember="MonthName" YValueMembers="Amount">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartAreaTest" Area3DStyle-LightStyle="Simplistic" AlignmentStyle="AxesView"
                    BorderDashStyle="Solid" Area3DStyle-Enable3D="true">
                </asp:ChartArea>
            </ChartAreas>            
        </asp:Chart>
    </div>
    </form>
</body>
</html>

C# Code For Chart 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 ChartControl : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindChartControl();
            }
        }
        private void BindChartControl()
        {
            DataSet Ds = GetDataSet("Select MonthName , Amount from OrderTable");
            ChartControlTest.DataSource = Ds; 
            ChartControlTest.DataBind(); 
        }
        private DataSet GetDataSet(string Query)
        {
            DataSet Ds = new DataSet();
            try
            {
                string strCon = @"Data Source=ServerName;Initial Catalog=Test;Integrated Security=True;";  //Conntection String
                SqlConnection Con = new SqlConnection(strCon);
                SqlDataAdapter Da = new SqlDataAdapter(Query, Con);
                Da.Fill(Ds);
            }
            catch (Exception) { }
            return Ds;
        }
    }
}
Related Other posts

Set hidden field's value on button's click in Jquery

Set hidden field's value on button's click in Jquery

Introduction : In this i will show you how to set value of hidden field's value on button click usinng Jquery . It is very easy to set value of hidden field's value using Jquery .I have written two way to set value of hidden field using Jquery . In first way you can write code in $(document).ready() function and second you can directly assign to on click of button .

HTML Code for Set hidden field's value on button's click in Jquery :

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="JqueryValidation.aspx.cs" Inherits="HamidSite.JqueryValidation" %>

<!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>
    <script src="Scripts/jquery-1.4.1-vsdoc.js" type="text/javascript"></script>
    <script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
    <script src="Scripts/jquery.validate.js" type="text/javascript"></script>
    <script type="text/javascript"  >
        $(document).ready(function () {
            $("#submit1").click(function () {
                $('#hiddenTest').val('Test-2');
                alert($('#hiddenTest').val());
            });
        });
  </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
            <input type="hidden" id="hiddenTest" value="" />
            <input id="submit" type="submit" value="test-1" onclick="$('#hiddenTest').val('Test-1');alert($('#hiddenTest').val());" runat="server" />            
            <input id="submit1" type="submit" value="test-2"  runat="server" />
    </div>
    </form>
</body>
</html>

Related Other posts

Tuesday, January 10, 2012

Check / Uncheck all checkbox in treeview using jquery in asp.net

Check / Uncheck all checkbox in treeview using jquery in asp.net

Introduction : In this article i will show you how check all checkboxes in treeview using Jquery in asp.net .It is very easy just you need add code and replace id as per treeview control . For the binding the Treeview control in asp.net you can visits my previous post bind treeview in-asp.net .
Jquery for check / uncheck all checkboxes in treeview in c# :

Following is jquery code for check or uncheck all checkboxes in treeview control and HTML code 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>
    <script src="Scripts/jquery-1.4.1-vsdoc.js" type="text/javascript"></script>
    <script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
    <script type="text/javascript" >

        $(document).ready(function () {

            $("div[id $= treeviwExample] input[type=checkbox]").click(function () {
                $(this).closest("table").next("div").find("input[type=checkbox]").attr("checked", this.checked);
            });

        });    
        
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TreeView ID="treeviwExample" ShowCheckBoxes="All"  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>


Related Other posts

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