Populate and Merge DataSet to form an XML

[Nauman Ahmed]

Hi,

I need to populate and merge DataSet to make an XML in the following format:

<?xml version="1.0" standalone="yes "?>
<CompanyOrder s>
<CompanyProfile >
<CompanyID>Test </CompanyID>
<CompanyName>Th e Company</CompanyName>
</CompanyProfile>
<OrderInformati on>
<BuyerInformati on>
<OrderNo>0000 1</OrderNo>
</BuyerInformatio n>
</OrderInformatio n>
</CompanyOrders>

So far I am able to come up with this code:

DataSet dsCompanyOrders = new DataSet("Compan yOrders");
DataTable dt = dsCompanyOrders .Tables.Add("Co mpanyProfile");
DataColumn dcCompanyID = new DataColumn("Com panyID");
DataColumn dcCompanyName = new DataColumn("Com panyName");
dt.Columns.AddR ange(new DataColumn[]
{
dcCompanyID,dcC ompanyName
}
);
DataRow drCompanyProfil e = dt.NewRow();
drCompanyProfil e["CompanyID"] = "Test";
drCompanyProfil e["CompanyNam e"] = "The Company";
dt.Rows.Add(drC ompanyProfile);

DataSet dsOrderInformat ion = new DataSet("OrderI nformation");
DataTable dtBuyerInformat ion =
dsOrderInformat ion.Tables.Add( "BuyerInformati on");
DataColumn dcOrderNo = new DataColumn("Ord erNo");
dtBuyerInformat ion.Columns.Add (dcOrderNo);
DataRow drOrderInformat ion = dtBuyerInformat ion.NewRow();
drOrderInformat ion["OrderNO"] = "00001";
dtBuyerInformat ion.Rows.Add(dr OrderInformatio n);
dsCompanyOrders .Merge(dsOrderI nformation,fals e,MissingSchema Action.Add);

dsCompanyOrders .WriteXml("c:\\ test.xml",XmlWr iteMode.IgnoreS chema);

The problem is that I cant create the parent node <OrderInformati on> and the
XML that is created is as follows:

<?xml version="1.0" standalone="yes "?>
<CompanyOrder s>
<CompanyProfile >
<CompanyID>Test </CompanyID>
<CompanyName>Th e Company</CompanyName>
</CompanyProfile>
<BuyerInformati on>
<OrderNo>0000 1</OrderNo>
</BuyerInformatio n>
</CompanyOrders>

Need some help with this :S

Thanks, Nauman.