I am trying to leverage ADO.NET 2.0 DataTable WriteXML method and serialize
datatable as an XML file..

dataTable.WriteXml(xmlFile)

Unfortunately, root node of the output file is always DocumentElement. Is
there way to control the name of the root node for the XML output?

Haven't looked at that yet but what happens when
you programmatically/manually define the table name
in the DataTable class?

--
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.masterado.net





"Yitzhak" <(E-Mail Removed)> wrote in message
news:956AFA96-52FF-4E1E-825A-(E-Mail Removed)...
>I am trying to leverage ADO.NET 2.0 DataTable WriteXML method and serialize
> datatable as an XML file..
>
> dataTable.WriteXml(xmlFile)
>
> Unfortunately, root node of the output file is always DocumentElement. Is
> there way to control the name of the root node for the XML output?
>

Table name creates a placeholder for each row in the resultset.
Root name still stays named as a DocumentElement.
So you will get something like this:
<DocumentElement>
<TableName>
<column1> </column1>
<column2> </column2>
etc.
</TableName>
<TableName>
<column1> </column1>
<column2> </column2>
etc.
</TableName>
</DocumentElement>

"Robbe Morris [C# MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Haven't looked at that yet but what happens when
> you programmatically/manually define the table name
> in the DataTable class?
>
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.masterado.net
>
>
>
>
>
> "Yitzhak" <(E-Mail Removed)> wrote in message
> news:956AFA96-52FF-4E1E-825A-(E-Mail Removed)...
>>I am trying to leverage ADO.NET 2.0 DataTable WriteXML method and
>>serialize
>> datatable as an XML file..
>>
>> dataTable.WriteXml(xmlFile)
>>
>> Unfortunately, root node of the output file is always DocumentElement. Is
>> there way to control the name of the root node for the XML output?
>>
>
>