DataTable dtGroupName = Cheeli.DBUtility.DbHelperSQL.GetDataTable

("select distinct GroupName from SysRes");           

 foreach (DataRow rows in dtGroupName.Rows){ 

               string GroupName = rows["GroupName"].ToString();                     TreeNode root = new TreeNode(GroupName);                

tvPermissions.Nodes.Add(root);                

SqlParameter[] parameters = 

{ new SqlParameter("@GroupNameText", root.Text) };                

string sql = "select * from SysRes where GroupName=@GroupNameText";                 DataTable dt = Cheeli.DBUtility.DbHelperSQL.GetDataTable(sql, parameters);                

foreach (DataRow row in dt.Rows){                    

string PromiseName = row["PromiseName"].ToString();                    

TreeNode node = new TreeNode(PromiseName);                    

node.Name = row["Id"].ToString();                    

root.Nodes.Add(node);                

}            

}