c# - Creating XML using DataSet.WriteXml. How to change the node name?

Question

Is there any way to change the DataSet default node name? I am creating XML from a DataTable.

This is my code:

DataSet dataSet = new DataSet("Products");
dataSet.Tables.Add(tbl);
dataSet.WriteXml(@"D:Temp	est.xml");

This is the XML I'm getting:

 <Products>
    <Table1>
      <product_name>McWilliams Hanwood Chardonnay 750mL</product_name>      
      <id>121385</id>
      <price>7.60</price>
    </Table1>
    <Table1>
        ...
    </Table1>
    <Table1>
        ...
    </Table1>
</Products>

Is there a way to change Table1 to Product like:

<Products>
 <Product>
 ....
 </Product>
  <Product>
 ....
 </Product>
</Products>

Answer 1

The name that appears is the name of the DataTable. You can change its name using the TableName property like this:

DataSet dataSet = new DataSet("Products");
tbl.TableName = "Product";
dataSet.Tables.Add(tbl);
dataSet.WriteXml(@"D:Temp	est.xml");

You can also pass the "Product" name when you construct the table:

var tbl = new DataTable("Product");