471,337 Members | 1,357 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

ADO.NET and XML Schemas: Generating the XML using the DataSet


I have to prepare a XML file in the following format:

<CompanyName>The Company</CompanyName>

This information will come from one table CustomerOrder. Here are my

1. I suspect I will have to create multiple data adapter as
<CustomerEMailInformation> exist outside the <BuyerInformation>.
2. The code that I have written untile now:

DataSet dsOrders = new DataSet("CompanyOrders");
SqlDataAdapter sdaOrder = new SqlDataAdapter(this.strSQL,conn);
this.dsOrders.WriteXml("C:\\test.xml",XmlWriteMode .IgnoreSchema);

And the XML output is as follows:

<MI />

I need the information contained in the
<OrderInformation></OrderInformation> tags to be contained in
<BuyerInformation></BuyerInformation> tags as it is defined in the DTD. Any

Thanks, Nauman.
Jul 21 '05 #1
0 849

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jack Notarangelo | last post: by
2 posts views Thread by AlexS | last post: by
3 posts views Thread by Anthony | last post: by
1 post views Thread by Leon_Amirreza | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.