ASP.NET

<br />
 protected void Page_Load(object sender, EventArgs e)<br />
   {<br />
        if (!IsPostBack)<br />
       {<br />
           PopulateRootLevel();<br />
       }<br />
}<br />
<br />
void PopulateRootLevel()<br />
   {<br />
<br />
       SqlConnection SqlCon = new SqlConnection("Data<br />
Source=biswa;Initial Catalog=rwsNew;User ID=sa;Password=biswa007");<br />
       // SqlConnection SqlCon = new SqlConnection("Data<br />
Source=;Initial Catalog=rwsNew;User ID=;Password=");<br />
       SqlCon.Open();<br />
       SqlCommand SqlCmd = new SqlCommand("SELECT modulename,moduleid<br />
FROM module_master WHERE delflag='ACTIVE' ORDER BY modulename ",<br />
SqlCon);<br />
       SqlDataReader Sdr = SqlCmd.ExecuteReader();<br />
       SqlCmd.Dispose();<br />
       string[,] ParentNode = new string[100, 2];<br />
       int count = 0;<br />
       while (Sdr.Read())<br />
       {<br />
           ParentNode[count, 0] =<br />
Sdr.GetValue(Sdr.GetOrdinal("moduleid")).ToString();<br />
           ParentNode[count++, 1] =<br />
Sdr.GetValue(Sdr.GetOrdinal("modulename")).ToString();<br />
       }<br />
       Sdr.Close();<br />
       for (int loop = 0; loop < count; loop++)<br />
       {<br />
           TreeNode root = new TreeNode();<br />
           root.Text = ParentNode[loop, 1];<br />
           root.Target = "_blank";<br />
           //root.NavigateUrl = "Default.aspx";<br />
           SqlCommand Module_SqlCmd = new SqlCommand("SELECT<br />
compid,componentname FROM module_component WHERE (moduleid = '" +<br />
ParentNode[loop, 0] + "') ", SqlCon);<br />
           SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader();<br />
           while (Module_Sdr.Read())<br />
           {<br />
               TreeNode child = new TreeNode();<br />
               child.Text =<br />
Module_Sdr.GetValue(Module_Sdr.GetOrdinal("componentname")).ToString();<br />
               child.Target = "_blank";<br />
               //child.NavigateUrl = "Default.aspx";<br />
               root.ChildNodes.Add(child);<br />
           }<br />
           Module_Sdr.Close();<br />
           TvMenu.Nodes.Add(root);<br />
       }<br />
<br />
       TvMenu.CollapseAll();<br />
       SqlCon.Close();<br />
   }<br />