c# mvc 5 convert datatable to xml data string

c# mvc 5 convert datatable to xml data string

We can convert data-table to XML data string using MVC 5 C# .Net. The given below code-sample is might help you to converting the same.

Table of Contents

1. Create string builder object.
2. Set the table name.
3. Append row data and table name.

//Convert data table in to XML data string method
public string ConvertDataTableToXMLDataString(DataTable dataTbl)
{
      StringBuilder XMLString = new StringBuilder();

         if (string.IsNullOrEmpty(dataTbl.TableName))
                dataTbl.TableName = "DataTable";
            XMLString.AppendFormat("<{0}>", dataTbl.TableName);

            DataColumnCollection tableColumns = dataTbl.Columns;
            foreach (DataRow row in dataTbl.Rows)
            {
                XMLString.AppendFormat("<RowData>");
                foreach (DataColumn column in tableColumns)
                {
                    XMLString.AppendFormat("<{1}>{0}</{1}>", row[column].ToString(), column.ColumnName);
                }
                XMLString.AppendFormat("</RowData>");
           }
            XMLString.AppendFormat("</{0}>", dataTbl.TableName);
            return XMLString.ToString();
}


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
My Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.