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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.