converting datatable to xml using linq

Question

..

I need help converting datatable to xml using Linq. I could do it with hardcoded column names as you can see in my code .. but i need it without hardcoding it ... hope could someone point me out how to do that .. thanks a alot

Example datatable ..

enter image description here

My linq query ..

    Dim xmlDoc As New XDocument(                           
             From row In dt.AsEnumerable()
                From row In dt.AsEnumerable()
                    Select New XElement("PUPIL",
                    New XAttribute("FIRSTNAME", row.Field(Of String)("First Name")),
                    New XAttribute("LASTNAME", row.Field(Of String)("Last Name")),
                    New XAttribute("DOB", row.Field(Of String)("Date of Birth")),
                    New XAttribute("Gender", row.Field(Of String)("Gender")),
                    New XAttribute("City", row.Field(Of String)("City"))
              ))

Is there a specific reason why you wouldn't simply use DataTable.WriteXml instead? — Filburt
– Filburt, Commented Apr 24, 2012 at 9:01
No .. I just love linq and want to improve my skills on it .. — Laurence
– Laurence, Commented Apr 24, 2012 at 12:59

McGarnagle · Accepted Answer · 2012-04-24 09:18:16Z

3

Why not just load the columns from the row the same way you loaded the rows from the table?

Dim xmlDoc As New XDocument(
    From row In dt.Rows
        Select XElement("PUPIL",
            From column In dt.Columns
                Select
                    New XAttribute(column.Name, row.Item(column.Name))
         )
)

edited Apr 24, 2012 at 9:18

answered Apr 24, 2012 at 9:12

McGarnagle

103k31 gold badges235 silver badges264 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Laurence Over a year ago

This is brilliant Mr dbaseman ... Thanks so much ... just one more thing, how to improve my Linq skill ? any book or website you recommand ?

McGarnagle Over a year ago

@LaurenceNyein this MSDN page has a ton of info (but it's MSDN, so a bit dry): msdn.microsoft.com/en-us/library/bb384508(v=vs.90).aspx

Collectives™ on Stack Overflow

converting datatable to xml using linq

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related