asked on

C# XML File to Datatable

Hi, I have an XML file like this.

<?xml version="1.0" encoding="utf-8" ?>
<rootelement>
<titleform>
<formname>title</formname>
<controlname>tbxdescription</controlname>
<visible>true</visible>
<requiredfiled>true</requiredfiled>
</titleform>
<Memberform>
<formname>member</formname>
<controlname>tbxmemberid</controlname>
<visible>false</visible>
<requiredfiled>false</requiredfiled>
</Memberform>
</rootelement>

now in C# I need output as follows. I Should be able to pass the form name through code and desired output should result in datatable. Example: If I pass formname as title, member should not appear in datatable. How do I do this ?

FormName      ControlName      RequiredField      Visible
title             tbxtitle        true             true
Member             tbxmemberid       false             false

Meir Rivkin

 using System.Data;
using System.Linq;
using System.Xml.Linq;

 class Program
    {
        static void Main(string[] args)
        {
DataTable dt = new DataTable();
            var root = XElement.Load(@"c:\temp\1.xml");
            dt.Columns.AddRange(root.Elements().FirstOrDefault().Elements().Select(n => new DataColumn { ColumnName = n.Name.LocalName }).ToArray());
            var rows = root.Elements().Select(n => n.Elements().Select(y => y.Value).ToArray());

            foreach (var row in rows)
            {
                dt.Rows.Add(row);
            }
}
}

Open in new window

GRChandrashekar

ASKER

This is not answered

Example: If I pass formname as title, member should not appear in datatable. How do I do this ?

Meir Rivkin

i don't understand.
what do u mean u pass formname as titleform?

GRChandrashekar

ASKER

Refer this.

<titleform>
<formname>title</formname>
<controlname>tbxdescription</controlname>
<visible>true</visible>
<requiredfiled>true</requiredfiled>
</titleform>

I should be able to pass title as input. Then output should be

FormName ControlName RequiredField Visible
title tbxtitle true true

Meir Rivkin

so if the value of formname element is "title" then it shouldn't be included in the datatable?

GRChandrashekar

ASKER

If the value for formname element is "title" then "member" should not be included in datatable
If the value for formname element is "member" then "title" should not be included in datatable

Meir Rivkin

sorry u gotta be more clear.
there are 2 elements in your xml: titleform and Memberform.
now please describe the use cases.
which element is not suppose to be insert to the datatable? and when?

GRChandrashekar

ASKER

from C# if i pass value as titleform, then output should be

FormName ControlName RequiredField Visible
title tbxtitle true true

from C# if i pass value as memberform, then output should be

FormName ControlName RequiredField Visible
Member tbxmemberid false false

Meir Rivkin

>>from C# if i pass value as titleform
what is that mean?
pass where?

GRChandrashekar

ASKER

should be something like

var root = XElement.Load(@"c:\temp\1.xml\title");

I mean pass to XML

Meir Rivkin

U cant pass variable to xml like this.
U can have a function which accept either title or member, and the function will populate datatable accordingly.
What i failed to understand is what should the results.

GRChandrashekar

ASKER

Result is here

from C# if i pass value as titleform, then output should be

FormName ControlName RequiredField Visible
title tbxtitle true true

from C# if i pass value as memberform, then output should be

FormName ControlName RequiredField Visible
Member tbxmemberid false false

ASKER CERTIFIED SOLUTION

Meir Rivkin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GRChandrashekar

ASKER

These lines (rows[1]); (rows[0]);in resharper says Co-variant conversion from string to object can cause run time exception on write operation

Meir Rivkin

according to the xml u posted u have 2 inner elements, one for titleform and one for memberform.