ASP.NET

public void PopXml()
   {
       TreeView1.Nodes.Clear();
       com = new OracleCommand();
       con = new OracleConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
       com.Connection = con;
       com.CommandText = "select a.meeting_no,a.meeting_no ||'-->' || a.meeting_desc comb,b.meet_no from tpc_meetings a,tpc_meets b where a.meeting_no=b.meeting_no and a.status='LIV' and b.status='LIV' order by a.meeting_no,b.meet_no";
       da = new OracleDataAdapter();
       ds = new DataSet();
       da.SelectCommand = com;
       da.Fill(ds, "Meets");
       object[] marr = GetDistinct(ds.Tables["Meets"], "meeting_no");//this function returns distinct meeting_nos
       foreach (object mval in marr)
       {
           string mcomb = ds.Tables["Meets"].Select("meeting_no='" + mval.ToString() + "'")[0]["comb"].ToString();
           TreeNode meetingnode = new TreeNode(mcomb, mcomb);
           meetingnode.SelectAction = TreeNodeSelectAction.None;
           TreeView1.Nodes.Add(meetingnode);
           DataRow[] children = ds.Tables["Meets"].Select("meeting_no='" + mval.ToString() + "'");
           foreach (DataRow drow in children)
           {
               TreeNode meetnode = new TreeNode(drow["meet_no"].ToString(), mval.ToString());
               meetnode.SelectAction = TreeNodeSelectAction.Select;
               meetingnode.ChildNodes.Add(meetnode);
           }
       }

   }