Find XML child nodes of specific node and insert it in DataTable

Question

I have this Style XML:

<Style Name="TextBox2" Type="TEXT">
        <Alignment>LEFT</Alignment>
        <BorderColor>blue</BorderColor>
        <BorderStyle>Solid</BorderStyle>
        <BackGroundColor>red</BackGroundColor>
        <Options>VISIBLE</Options>
        <TextColor>Black</TextColor>
        <TextSize>10</TextSize>
        <MaxCharacterLength>50</MaxCharacterLength>

I want to write a function which enables me to search for a Name (e.g. Checkbox2) and returns us corresponding names and values of child nodes (Alignment=Center, Bordercolor=red etc.) Should I use datatable or Dataset? Or any suggestion will be much appreciated

Andy, what is the end use of these values? Do you want to retrieve all values? — A3006, Oct 10 '16 at 04:21
Because each control will come with a different set of values...or you want only common ones? — A3006, Oct 10 '16 at 04:23
create common model for style properties and load it in list Ex: http://stackoverflow.com/a/16098093/842112 — Santhosh Nayak, Oct 10 '16 at 04:26

score 0 · Answer 1 · answered Oct 10 '16 at 09:32

Try something like this to get only one object

            string xml =
            "<Root>" +
                "<Style Name=\"TextBox2\" Type=\"TEXT\">" +
                    "<Alignment>LEFT</Alignment>" +
                    "<BorderColor>blue</BorderColor>" +
                    "<BorderStyle>Solid</BorderStyle>" +
                    "<BackGroundColor>red</BackGroundColor>" +
                    "<Options>VISIBLE</Options>" +
                    "<TextColor>Black</TextColor>" +
                    "<TextSize>10</TextSize>" +
                    "<MaxCharacterLength>50</MaxCharacterLength>" +
                "</Style>" +
            "</Root>";

            XDocument doc = XDocument.Parse(xml);

            var style = doc.Descendants("Style").Where(x => (string)x.Attribute("Name") == "TextBox2").Select(x => new
            {
                type = (string)x.Attribute("Type"),
                alignment = (string)x.Element("Alignment"),
                borderColor = (string)x.Element("BorderColor"),
                borderStyle = (string)x.Element("BorderStyle"),
                background = (string)x.Element("BackGroundColor"),
                options = (string)x.Element("Options"),
                textColor = (string)x.Element("TextColor"),
                textSize = (string)x.Element("TextSize"),
                maxCharacters = (int)x.Element("MaxCharacterLength"),
            }).FirstOrDefault();

Find XML child nodes of specific node and insert it in DataTable

1 Answers1