Need help converting DataTable to XML VB.NET

[Affeceunsoche]

I need help converting DataTable to XML. I have done it using LINQ but I can't get exactly as I have to. I made a picture so that you can easily understand. The XML needs to be in certain format like below so I can't just use dt.writexml(). Artist ID needs to auto number. Songs are groupped by Artist. Prefer a solution in Linq coz that's what I have used throughout the project but I coundn't manage to get what I want here. The columns names are known so you can use something like this in the code. row.Field(Of String)("title")Thanks a lot . I mean it. Sorry for poor english.

CreateDatatable - this simple code should create a datatable\[code\] Dim dTable As New DataTable dTable.Columns.Add("Title") dTable.Columns.Add("Artist") dTable.Columns.Add("Album") dTable.Rows.Add("Baby one more time", "Britney Spears", "Baby one more time") dTable.Rows.Add("Crazy", "Britney Spears", "Best of") dTable.Rows.Add("Every time", "Britney Spears", "Best of") dTable.Rows.Add("Black and White", "Michael Jackson", "Best of") dTable.Rows.Add("You are not alone", "Michael Jackson", "Best of") dTable.Rows.Add("Smile", "Michael Jackson", "Best of")\[/code\]what I have at the moment. It will convert it datatable to xml without the groupping and album index.\[code\] Dim xmlDoc As New XDocument( From row In dt.Rows Select XElement("SONG", From column In dt.Columns Select New XAttribute(column.Name, row.Item(column.Name)) ) )\[/code\]well .. i also have some more code .. that will query first created xml and do the grouping but still having album="albumname" in the song element as attribute. And it should be just one query from datatable to xml .. i hate having to query against xml again to just refomat it.\[code\] Dim replacement = New XDocument(New XElement("root", original.Descendants("Song") .GroupBy(Function(x) Convert.ToString(x.Element("artist").value)) .[Select](Function(songsForArtist, index) New XElement("artist", New XAttribute("id", index + 1), New XAttribute("name", songsForArtist.Key), songsForArtist))))\[/code\]