Add Data to Tree View from Database in asp.net (C#)

BTW, here is the example of the code:

private void fill_Tree()

/*

SqlConnection SqlCon = new SqlConnection(connection);

/*

SqlCommand SqlCmd = new SqlCommand("Select * from PrentTable", SqlCon);

/*

SqlDataReader Sdr = SqlCmd.ExecuteReader();

/*

/*

string[,] ParentNode = new string[100, 2];

int count = 0;

while (Sdr.Read())

ParentNode[count, 0] = Sdr.GetValue(Sdr.GetOrdinal("PKinParentTbl")).ToString();

ParentNode[count++, 1] = Sdr.GetValue(Sdr.GetOrdinal("ColumValue")).ToString();

for (int loop = 0; loop < count; loop++)

TreeNode root = new TreeNode();

/*

root.NavigateUrl = "~/TreeView.aspx";

SqlCommand Module_SqlCmd = new SqlCommand("Select * from ChildTable where ID =" + ParentNode[loop, 0] + "ORDER BY Description ASC", SqlCon);

SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader();

while (Module_Sdr.Read())

TreeNode child = new TreeNode();

child.Text = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("Description")).ToString();

child.Target = "_blank";

//get the url

string url = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("ChildColValue")).ToString();

if (url != null)

// Add root node to TreeView

/*

Hi,

I have did similar thing on one of my page, where I build the "tree view" from the database.

In my case, I have 2 tables (parent table nad child table) and read them in using SQLDataReader, and then loop through it to fill out the tree.