C#

XDocument doc = XDocument.Load("YourXMLHere.xml");

var distinctBlocks = from rec in doc.Descendants()
                       where rec.Name.ToString().StartsWith("Block")
                       select rec;

 var results = from rec in distinctBlocks.Descendants("REC")
               select rec;

 var output = (from rec in results
              group rec by rec.Parent.Name into g
              select new {Block = g.Key, Count = g.Count()}).ToList();

 //dataGridView1.DataSource = output;

GrgBalden wrote:

I don't suppose you have the c# code?

public class BlockCount
{
    private int count = 0;
    public int Count
    {
        get { return count; }
        set { count = value; }
    }

    private string block;
    public string Block
    {
        get { return block; }
        set { block = value; }
    }
}

private void button1_Click(object sender, EventArgs e)
    {
        XmlDocument doc = new XmlDocument();
        doc.Load("Abs.xml");

        //get the requestNodes
        XmlNodeList requests = doc.GetElementsByTagName("Request");

        if (requests != null && requests.Count > 0)
        {
            blocks = new List<BlockCount>();
            //now get the blocks nodes
            foreach (XmlNode nd in requests)
            {
                foreach (XmlNode blck in nd.ChildNodes)
                {
                    //create a new instance of the class
                    BlockCount c = new BlockCount();
                    //set the name of the block
                    c.Block = blck.Name;
                    foreach (XmlNode rec in blck.ChildNodes)
                    {
                        c.Count++;
                    }
                    blocks.Add(c);
                }
            }
        }
        //this is just for testing the results witch are fine by the way
        dataGridView1.DataSource = blocks;
    }
}

[StructLayout(LayoutKind.Sequential)]
private struct NMHDR
{
    public IntPtr hwndFrom;
    public int idFrom;
    public int code;
} //NMHDR

[StructLayout(LayoutKind.Sequential)]
private struct NMHDR2
{
    public IntPtr hwndFrom;
    public int idFrom;
    public int code;
    public int coder;
} //NMHDR

using System;
using System.Drawing;
using System.Runtime.InteropServices;
using System.Windows.Forms;

namespace Listview_Colum_header_checkbox
{
    class CCehckBox2 : CheckBox
    {
        public CCehckBox2()
        {
            Width = 14;
            Height = 14;
        }
    }

    class CustomChechBox2 : Control
    {
        readonly CCehckBox2 _chb = new CCehckBox2();
        public CustomChechBox2()
        {
            Size = new Size(16, 16);
            _chb.Location = new Point(0, 0);
            Controls.Add(_chb);
        }
    }

    class CListview2 : ListView
    {
        public delegate void MessageNeedsSendingCallback(string message, Color color);
        public event MessageNeedsSendingCallback OnMessageNeedsSending;


        //private readonly CCehckBox _cCehckBox = new CCehckBox();
        private readonly CustomChechBox2 _cCehckBox = new CustomChechBox2();
 
        private readonly ColumnHeader _header1, _header2, _header3 = new ColumnHeader();
        #region  PInvoke Declarations

        [DllImport("User32", CallingConvention = CallingConvention.Cdecl)]
        private static extern uint RealGetWindowClass(IntPtr hwnd, System.Text.StringBuilder pszType, int cchType);

        [DllImport("user32")]
        private static extern IntPtr SetParent(IntPtr hWndChild, IntPtr hWndNewParent);

        [DllImport("user32.dll")]
        private static extern IntPtr SendMessage(IntPtr hWnd, int Msg, IntPtr wParam, IntPtr lParam);

        #endregion

        public CListview2()
        {
            View = View.Details;
            //this.HeaderStyle = ColumnHeaderStyle.Nonclickable;
            //_header1.
            _header1 = Columns.Add("");
            _header1.Width = (Location.X + 5) + 12;
            //_header1.AutoResize(ColumnHeaderAutoResizeStyle.ColumnContent);
            _header1.Name = "CheckBox";
            _header1.DisplayIndex = 0;

            _header2 = Columns.Add("bah");
            _header2.Width = 50;

            _header3 = Columns.Add("boh");
            _header3.Width = 50;

            var wijd = _cCehckBox.Width;
            var hoog = _cCehckBox.Height;
            _cCehckBox.Location = new Point((Location.X + 5), (Location.Y + 5));
        }
        protected override void OnHandleCreated(EventArgs e)
        {
            SetParent(_cCehckBox.Handle, Handle);
            base.OnHandleCreated(e);
        }

        [StructLayout(LayoutKind.Sequential)]
        private struct NMHDR
        {
            public IntPtr hwndFrom;
            public int idFrom;
            public int code;
            public int coder;
        } //NMHDR

        private const int WM_NOTIFY = 0x4E;
        private const int CCM_FIRST = 8192; //				# Common control shared messages
        private const int CCM_SETBKCOLOR = (CCM_FIRST + 1);//		# lParam is bkColor
        private const int CCM_SETCOLORSCHEME = (CCM_FIRST + 2);//	# lParam is color scheme
        private const int CCM_GETCOLORSCHEME = (CCM_FIRST + 3);//	# fills in COLORSCHEME pointed to by lParam
        private const int CCM_GETDROPTARGET = (CCM_FIRST + 4);//
        private const int CCM_SETUNICODEFORMAT = (CCM_FIRST + 5);//
        private const int CCM_GETUNICODEFORMAT = (CCM_FIRST + 6);//

        private const int HDN_FIRST = (0 - 300);
        private const int HDM_FIRST = 4608;
        private const int HDM_HITTEST = (HDM_FIRST + 6);
        private const int HDM_GETITEMRECT = (HDM_FIRST + 7);
        private const int HDM_SETIMAGELIST = (HDM_FIRST + 8);
        private const int HDM_GETIMAGELIST = (HDM_FIRST + 9);
        private const int HDM_ORDERTOINDEX = (HDM_FIRST + 15);
        private const int HDM_CREATEDRAGIMAGE = (HDM_FIRST + 16); // # wparam = which item (by index)
        private const int HDM_GETORDERARRAY = (HDM_FIRST + 17);
        private const int HDM_SETORDERARRAY = (HDM_FIRST + 18);
        private const int HDM_SETHOTDIVIDER = (HDM_FIRST + 19);
        private const int HDM_SETUNICODEFORMAT = CCM_SETUNICODEFORMAT;
        private const int HDM_GETUNICODEFORMAT = CCM_GETUNICODEFORMAT;
        private const int HDN_ITEMCHANGINGA = (HDN_FIRST - 0);
        private const int HDN_ITEMCHANGINGW = (HDN_FIRST - 20);
        private const int HDN_ITEMCHANGEDA = (HDN_FIRST - 1);
        private const int HDN_ITEMCHANGEDW = (HDN_FIRST - 21);
        private const int HDN_ITEMCLICKA = (HDN_FIRST - 2);
        private const int HDN_ITEMCLICKW = (HDN_FIRST - 22);
        private const int HDN_ITEMDBLCLICKA = (HDN_FIRST - 3);
        private const int HDN_ITEMDBLCLICKW = (HDN_FIRST - 23);
        private const int HDN_DIVIDERDBLCLICKA = (HDN_FIRST - 5);
        private const int HDN_DIVIDERDBLCLICKW = (HDN_FIRST - 25);
        private const int HDN_BEGINTRACKA = (HDN_FIRST - 6);
        private const int HDN_BEGINTRACKW = (HDN_FIRST - 26);
        private const int HDN_ENDTRACKA = (HDN_FIRST - 7);
        private const int HDN_ENDTRACKW = (HDN_FIRST - 27);
        private const int HDN_TRACKA = (HDN_FIRST - 8);
        private const int HDN_TRACKW = (HDN_FIRST - 28);
        private const int HDN_GETDISPINFOA = (HDN_FIRST - 9);
        private const int HDN_GETDISPINFOW = (HDN_FIRST - 29);
        private const int HDN_BEGINDRAG = (HDN_FIRST - 10);
        private const int HDN_ENDDRAG = (HDN_FIRST - 11);
        private const int HDN_ITEMCHANGING = HDN_ITEMCHANGINGA;
        private const int HDN_ITEMCHANGED = HDN_ITEMCHANGEDA;
        private const int HDN_ITEMCLICK = HDN_ITEMCLICKA;
        private const int HDN_ITEMDBLCLICK = HDN_ITEMDBLCLICKA;
        private const int HDN_DIVIDERDBLCLICK = HDN_DIVIDERDBLCLICKA;
        private const int HDN_BEGINTRACK = HDN_BEGINTRACKA;
        private const int HDN_ENDTRACK = HDN_ENDTRACKA;
        private const int HDN_TRACK = HDN_TRACKA;
        private const int HDN_GETDISPINFO = HDN_GETDISPINFOA;

        private const int NM_FIRST = 0;
        private const int NM_OUTOFMEMORY = (NM_FIRST - 1);
        private const int NM_CLICK = (NM_FIRST - 2);//# uses NMCLICK struct
        private const int NM_DBLCLK = (NM_FIRST - 3);
        private const int NM_RETURN = (NM_FIRST - 4);
        private const int NM_RCLICK = (NM_FIRST - 5);//# uses NMCLICK struct
        private const int NM_RDBLCLK = (NM_FIRST - 6);
        private const int NM_SETFOCUS = (NM_FIRST - 7);
        private const int NM_KILLFOCUS = (NM_FIRST - 8);
        private const int NM_CUSTOMDRAW = (NM_FIRST - 12);
        private const int NM_HOVER = (NM_FIRST - 13);
        private const int NM_NCHITTEST = (NM_FIRST - 14);//# uses NMMOUSE struct
        private const int NM_KEYDOWN = (NM_FIRST - 15);//# uses NMKEY struct
        private const int NM_RELEASEDCAPTURE = (NM_FIRST - 16);
        private const int NM_SETCURSOR = (NM_FIRST - 17);//# uses NMMOUSE struct
        private const int NM_CHAR = (NM_FIRST - 18);

        protected override void WndProc(ref Message message)
        {
            bool callBase = true;

            switch (message.Msg)
            {
                case WM_NOTIFY:

                    NMHDR nmhdr = (NMHDR)message.GetLParam(typeof(NMHDR));
                    OnMessageNeedsSending("code: " + nmhdr.code + ", hwndFrom: " + nmhdr.hwndFrom + ", idFrom: " + nmhdr.idFrom + ", coder: " + nmhdr.coder, Color.Black);
                    switch (nmhdr.coder)
                    {
                        case HDN_BEGINTRACKA:  //Process both ANSI and
                            OnMessageNeedsSending("HDN_BEGINTRACKA " + message, Color.Black);
                            break;
                        case HDN_BEGINTRACKW:  //UNICODE versions of the message.
                            OnMessageNeedsSending("HDN_BEGINTRACKW " + message, Color.Black);
                            break;
                        case HDN_ENDTRACKW:
                            OnMessageNeedsSending("HDN_ENDTRACKW " + message, Color.Black);
                            break;
                        case HDN_ITEMCLICKA:
                            OnMessageNeedsSending("HDN_ITEMCLICKA " + message, Color.Black);
                            break;
                        case HDN_ITEMDBLCLICKW:
                            OnMessageNeedsSending("HDN_ITEMDBLCLICKW " + message, Color.Black);
                            break;
                        case HDN_ITEMCLICKW:
                            OnMessageNeedsSending("HDN_ITEMCLICKW " + message, Color.Black);
                            break;
                        case HDN_ITEMCHANGINGW:
                            OnMessageNeedsSending("HDN_ITEMCHANGINGW " + message, Color.Black);
                            break;
                        case HDN_ITEMCHANGEDA:
                            OnMessageNeedsSending("HDN_ITEMCHANGEDA " + message, Color.Black);
                            break;
                        case HDN_ITEMCHANGEDW:
                            OnMessageNeedsSending("HDN_ITEMCHANGEDW " + message, Color.Black);
                            break;
                        case NM_HOVER:
                            OnMessageNeedsSending("NM_HOVER " + message, Color.Black);
                            break;
                        case NM_RELEASEDCAPTURE:
                            OnMessageNeedsSending("NM_RELEASEDCAPTURE" + message, Color.Black);
                            break;
                        case NM_CUSTOMDRAW:
                            //lpNMCustomDraw = (LPNMLVCUSTOMDRAW)lParam;
                            callBase = false;
                            //OnMouseHover(EventArgs.Empty);
                            OnMessageNeedsSending("NM_CUSTOMDRAW" + message, Color.Black);
                            _cCehckBox.BringToFront();

                            _cCehckBox.Invalidate();
                            break;
                        default:
                            OnMessageNeedsSending("code: " + nmhdr.code + ", hwndFrom: " + nmhdr.hwndFrom + ", idFrom: " + nmhdr.idFrom + ", coder: " + nmhdr.coder, Color.Black);
                            break;

                    } //switch

                    break;
            } //switch


            if (callBase)
            {
                // pass messages on to the base control for processing

                base.WndProc(ref message);
            } //if
        }
    }
}

label5.Refresh();