How to specify XML output format when writing from a DataTable?

Question

In C #, I create an XML file from a DataTable using dataTable.WriteXml (filePath), and I get the following:

<?xml version="1.0" encoding="utf-8" ?> <ExperienceProfiles> <ExperienceProfile> <Col1>blah</Col1> <Col2>4ed397bf-a4d5-4ace-9d44-8c1a5cdb0f34</Col2> </ExperienceProfile> </ExperienceProfiles> 

How can I get him to write XML in the following format ?:

 <?xml version="1.0" encoding="utf-8" ?> <ExperienceProfiles> <ExperienceProfile Col1="blah" Col2="blah" ></ExperienceProfile> </ExperienceProfiles> 

Answer 1

What you want is a way to tell the DataSet the expected format of your data. You're in luck, DataSet only supports this feature.

You will need to create an XML schema for your data and load it into the DataSet before you select XML. In the diagram, define Col1 and Col2 as attributes of the ExperienceProfile element, and the DataSet will know how to format the output document to meet the requirements specified in the diagram.

If you are not comfortable creating a schema, you can create a sample XML file the way you want to format it, and then take a look at the XmlSchemaInference class within. This class can be used to automatically create your circuit, you may need to adjust the output a bit, but it can help if you are not familiar with XSD.

Answer 2

you can use the ColumnMapping function in the datatable column. .

 column.ColumnMapping = MappingType.Attribute 

Answer 3

Short answer: you cannot using the WriteXml of the DataTable method.

Long answer (which is not very long): Just scan your own.

Cancel my answer as above :)