convert List<List<>> to XML in c#

venkat

8y10.3kLearn iOS Programming

Hi All,

I have List of List and need to convert as xmlelement please any one help.

I have Tried like this. Below is my code.

insertDetails.BulkrefTableList is the List of List data. (i mean. List> )

foreach (var RefData in insertDetails.BulkrefTableList)

{

XDocument RefDataDetails = new XDocument(new XDeclaration("1.0", "UTF - 8", "yes"),

new XElement(insertDetails.TableName,

from RefDetails in RefData

select new XElement(insertDetails.TableName,

new XElement("ColumnNames", RefDetails.ColumnNames),

new XElement("ColumnValues", RefDetails.ColumnValues),

new XElement("IsPrimary", RefDetails.IsPrimary.ToString()))));

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ruchi Sharavat8y ago
Accepted answer
Hi venkat,

I always use generic method to convert model list to xml. Here is code with example of List of List of string. If it could help you. Here tf is List of List of string.
List<string> t= new List<string>();
           t.Add("a");t.Add("b");t.Add("c");t.Add("d");
            List<string> t1= new List<string>();
           t1.Add("a1");t1.Add("b1");t1.Add("c1");t1.Add("d1");
            List<string> t2= new List<string>();
           t2.Add("a2");t2.Add("b2");t2.Add("c2");t2.Add("d2");
           Liststring>> tf= new Liststring>>();
           tf.Add(t);tf.Add(t1);tf.Add(t2);
           string xml = null;
           using (StringWriter sw = new StringWriter())
            {
                XmlSerializer xs = new XmlSerializer(typeof( Liststring>>));

                xs.Serialize(sw, tf);

                try
                {
                    xml = sw.ToString();

                }
                catch (Exception e)
                {
                    throw e;
                }
            }

           Console.WriteLine("Hello, world!"+xml);
The output of this code is here:
xml version="1.0" encoding="utf-16"?>
<ArrayOfArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ArrayOfString>
    <string>astring>
    <string>bstring>
    <string>cstring>
    <string>dstring>
  ArrayOfString>
  <ArrayOfString>
    <string>a1string>
    <string>b1string>
    <string>c1string>
    <string>d1string>
  ArrayOfString>
  <ArrayOfString>
    <string>a2string>
    <string>b2string>
    <string>c2string>
    <string>d2string>
  ArrayOfString>
ArrayOfArrayOfString>
Here when you will you any class, node will be replaced by actual property of that class.
Also if you are using SQL- Server to send this xml, this might help you:

https://www.c-sharpcorner.com/blogs/save-array-or-list-of-records-as-xml-data-to-sql-server-in-one-call
+1
venkat8y ago
This is exactly what am expecting and working fine for me. thank you so much
Ruchi Sharavat.
0
venkat8y ago
These all are showing single List to XML only. But my Input is below like that and BulkrefTableList contain Count 2.that count i need to convert as a XML.

0
Sanwar Ranwa8y ago
Hello Venkat,

Please these links

http://www.dotnetcurry.com/ShowArticle.aspx?ID=428

http://www.techcognition.com/post/convert-list-object-into-xml-in-c

https://www.c-sharpcorner.com/article/convert-generic-list-into-xml-in-Asp-Net-mvc/
0