select tree node to display gridview

Question

select tree node to display gridview . i have two tables with ID . when i select a tree node to display a related data in a girdview in a tree nodes are fetch in a table

Satyapriya Nayak · Answer

Hi Deva, Untitled Page 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 { 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

ClonecMr cool · Answer

What about this ? private void treeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { TreeNode theNode = this.treeView1.GetNodeAt(e.X, e.Y); string yyy = this.treeView1, theNode.Tag.ToString(); //and you find the value from dataGrid dataGridView1.SelectedDataKey.Values["yyy"].toString(); } In My Code : *I used one Dataset for that TreeView and that DataGridView *I used Node.Tag to get a Value that have relationship. *The Node tag is value from column name of DataRow to read. hope this help..

select tree node to display gridview

Answers (2)