select tree node to display gridview

Hi Deva,


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Treenode_to_display_gridview._Default" %>





   


   

   

        BorderColor="#336699" ForeColor="Black" NodeIndent="10"
    onselectednodechanged="trvw_SelectedNodeChanged">              
   
   



   

   

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Treenode_to_display_gridview
{
    public partial class _Default : System.Web.UI.Page
    {
       
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com = new SqlCommand();
        SqlDataAdapter da = new SqlDataAdapter();
        DataTable dt = new DataTable();
        TreeNode PNode = new TreeNode();
        string query;
        int cnt;
        DataRow dr;
        protected void Page_Load(object sender, EventArgs e)
        {
          
            trvw.Nodes.Clear();
            query = "Select * from treeexample";
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            com = new SqlCommand(query, con);
            da = new SqlDataAdapter(com);
            da.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                for (cnt = 0; cnt <= dt.Rows.Count - 1; cnt++)
                {
                    dr = dt.Rows[cnt];
                    switch (dr["id"].ToString())
                    {
                        case "1":
                            PNode = new TreeNode(dr["valuename"].ToString().Trim(), dr["valuename"].ToString().Trim());
                            this.trvw.Nodes.Add(PNode);
                            break;
                        case "2":
                            PNode.ChildNodes.Add(new TreeNode(dr["valuename"].ToString().Trim(), dr["valuename"].ToString().Trim()));
                            break;
                    }
                    PNode.ExpandAll();
                }
            }
            con.Close();
        }

        protected void trvw_SelectedNodeChanged(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            com = new SqlCommand("select * from clrtbl where clr='" + trvw.SelectedNode.Text + "'", con);
            da = new SqlDataAdapter(com);
            dt = new DataTable();
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
            con.Close();
        }
    }
}




Thanks