How to create attribute based xml in c#

Question

How to create attribute based xml in c# from stored procedure returning result

Stored Procedure contains:

Select * from Patients

I want XML:

<Patient patientid =”1”  domainid =”1” domainname =” Test Domain”/>

I am getting this:

<Patient>
    <patientid>1</patientid>
    <domainid>1</domainid>
    <domainname>Test Domain</domainname>
  </Patient>

StuartLC · Accepted Answer · 2015-06-17 06:20:51Z

2

The easiest would be to change your proc to return an xml string generated by FOR XML AUTO

Select * 
FROM  Patients AS Patient
FOR XML AUTO;

SqlFiddle here

edited Jun 17, 2015 at 6:20

answered Jun 17, 2015 at 5:57

StuartLC

108k18 gold badges225 silver badges294 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hari Prasad · Accepted Answer · 2015-06-17 05:55:56Z

1

Assuming you are getting result as DataSet from Stored Procedure.

You can setColumnMapping, and then write to xml. .

DataTable dt ; // Patients information retrieved from db.

foreach (DataColumn column in dt.Columns)
{
    column.ColumnMapping = MappingType.Attribute;
}

dt.WriteXml(@"C:\Patients.xml");

Hope this helps !!

answered Jun 17, 2015 at 5:55

Hari Prasad

17k4 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to create attribute based xml in c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related