how to write xml? [modified]

[Member 2321293]

Hi, Is anyone can tell me how to write a xml file that can return me a result look like this: <?xml version="1.0"?> <Items> <Appointment Start="07/12/2008 11:05:00" End="07/12/2008 14:30:00" .../> <Appointment Start="07/14/2008 08:15:00" End="07/16/2008 16:40:00" .../> </Items> Above is my expected look of my xml file. These data <Appointment start=".... /> are set EXACTLY THE SAME into a dataset and the table name is "xmldata" And before it is generated I try to loop this dataset and hope to generate a xml look like above. but i alway fail to get a correct format. its comes like this: <?xml version="1.0" standalone="yes"?> <Items> <xmldata> <Data>Appointment Start='07/12/2008 11:05:00' End='07/12/2008 14:30:00' Description='Rent this car ' Label='2' Location='city' ResourceId='1' Status='3' Subject='Mr.Brown' </Data> </xmldata> <xmldata> <Data>Appointment Start='07/14/2008 08:15:00' End='07/16/2008 16:40:00' Description='Scheduled repair of this car' Label='4' Location='Service Center' ResourceId='1' Status='2' Subject='Repair' </Data> </xmldata> </Items> XML above by using: ldt_ds.Tables["xmldata"].WriteXml(sourcePath2, false); Hope someone can help on this. Thank you. by CS Tan

modified on Saturday, November 7, 2009 12:06 PM

[Not Active]

You have several options. If you are using SQL Server, you can use the FOR XML clause in the stored proc you are using to query the data. You can use XSLT or Linq to XML to transform the given XML into the desired format. You can use a combination of Linq To XML and Linq to SQL to created the required output.

---

I know the language. I've read a book. - _Madmatt

[PIEBALDconsult]

Never expect an automated tool to produce what you want. I'd use an XmlDocument to do that.