I have data in sql table that data will be convert in to xml format inside tag

Question

3.67/5 (2 votes)

See more:

Hi,

I have data table in that table have a data that data will be convert in to xml format like
inside tag

example

XML

<CPSMSStateSchemeMapping>
             <StateCode>27</StateCode>
             <FinancialYear>2013</FinancialYear>
             <DepartmentCode>G</DepartmentCode>
             <BudgetCode>0040000000000</BudgetCode>
             <StateSchemeCode>24016241</StateSchemeCode>
             < CPSMSSchemeCode>0404</CPSMSSchemeCode >
            <CreatedDate >22/03/2013</CreatedDate>
  </CPSMSStateSchemeMapping>

Posted 28-Jan-14 20:04pm

manuel_joseph

Add a Solution

Comments

Tejas Vaishnav 29-Jan-14 2:07am

can you provide your sample data ..

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Avunoori · Accepted Answer · 2014-01-28T20:36:00

Hi,

Here is the solution.

C#

// By using this method we can convert datatable to xml
public string ConvertDatatableToXML(DataTable dt)
{
MemoryStream str = new MemoryStream();
dt.WriteXml(str, true);
str.Seek(0, SeekOrigin.Begin);
StreamReader sr = new StreamReader(str);
string xmlstr;
xmlstr = sr.ReadToEnd();
return (xmlstr);
}

Just pass the Datatable as the parameter to this method you will be getting data in xml format.

Ahmed Jubayer · Accepted Answer · 2014-01-28T21:09:00

Solution 2

you can try this link:

http://stackoverflow.com/questions/1564541/how-to-convert-records-in-a-table-to-xml-format-using-t-sql[^]

http://stackoverflow.com/questions/18353250/convert-sql-table-to-xml[^]

Posted 28-Jan-14 21:09pm

Ahmed Jubayer

I have data in sql table that data will be convert in to xml format inside tag

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

I have data in sql table that data will be convert in to xml format inside tag

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us