python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions