Hello,
I have a tree(tree view) where nodes are added dynamically from database.
Now i want to open different pages on those node click at runtime on TreeView_SelectedNodeChanged Event.
How can i manage that in that tree.
This is XML code for treeview
<asp:TreeView ID="TreeView1" runat="server"
ImageSet="BulletedList2" ShowLines="True" CssClass="container" ExpandDepth="1" OnSelectedNodeChanged="TreeView1_SelectedNodeChanged">
<ParentNodeStyle Font-Bold="False" />
<HoverNodeStyle Font-Underline="True" ForeColor="#5555DD" />
<SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD"
HorizontalPadding="0px" VerticalPadding="0px" />
<NodeStyle Font-Names="Verdana" Font-Size="8pt" ForeColor="Black"
HorizontalPadding="5px" NodeSpacing="0px" VerticalPadding="0px" />
</asp:TreeView>
This codebehind in C# which generates treenode dynamically
private void LoadData()
{
con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConString"].ConnectionString);
cmd = new SqlCommand("SELECT Project_Code, Project_Name FROM tablename WHERE Project_Id=1", con);
con.Open();
reader = cmd.ExecuteReader();
arrCountry = new string[100, 2];
int ctr = 0;
while (reader.Read())
{
arrCountry[ctr, 0] = reader["Project_Code"].ToString();
arrCountry[ctr, 1] = reader["Project_Name"].ToString();
ctr++;
}
reader.Close();
con.Close();
for (int i = 0; i < ctr; i++)
{
TreeNode Country = new TreeNode();
Country.Value = arrCountry[i, 0];
Country.Text = arrCountry[i, 1];
cmd = new SqlCommand("SELECT Design_Code, Design_Name FROM tablename1 WHERE Project_Code=@Project_Code", con);
cmd.Parameters.AddWithValue("@Project_Code", arrCountry[i, 0]);
con.Open();
reader = cmd.ExecuteReader();
arrState = new string[100, 2];
int ctr2 = 0;
while (reader.Read())
{
arrState[ctr2, 0] = reader["Design_Code"].ToString();
arrState[ctr2, 1] = reader["Design_Name"].ToString();
ctr2++;
}
reader.Close();
con.Close();
for (int j = 0; j < ctr2; j++)
{
TreeNode state = new TreeNode();
state.Value = arrState[j, 0];
state.Text = arrState[j, 1];
Country.ChildNodes.Add(state);
cmd = new SqlCommand("SELECT Shell_Code, Shell_Name FROM tblShellDetails WHERE Design_Code=@Design_Code", con);
cmd.Parameters.AddWithValue("@Design_Code", arrState[j, 0]);
con.Open();
reader = cmd.ExecuteReader();
arrCity = new string[100, 2];
int ctr3 = 0;
while (reader.Read())
{
arrCity[ctr3, 0] = reader["Shell_Code"].ToString();
arrCity[ctr3, 1] = reader["Shell_Name"].ToString();
ctr3++;
}
reader.Close();
con.Close();
for (int l = 0; l < ctr3; l++)
{
TreeNode city = new TreeNode();
city.Value = arrCity[l, 0];
city.Text = arrCity[l, 1];
state.ChildNodes.Add(city);
cmd = new SqlCommand("SELECT Shell_Code, Shell_Name FROM tablename3 WHERE Shell_Code=@Shell_Code", con);
cmd.Parameters.AddWithValue("@Shell_Code", arrCity[l, 0]);
con.Open();
reader = cmd.ExecuteReader();
arrabc = new string[100, 2];
int ctr4 = 0;
while (reader.Read())
{
arrabc[ctr4, 0] = reader["Shell_Code"].ToString();
arrabc[ctr4, 1] = reader["Shell_Name"].ToString();
ctr4++;
}
reader.Close();
con.Close();
for (int m = 0; m < ctr4; m++)
{
TreeNode abc = new TreeNode(arrabc[m, 1], arrabc[m, 0]);
city.ChildNodes.Add(abc);
}
}
}
TreeView1.Nodes.Add(Country);
}
}
Thanks for your help