Writing dataview as XML

[Amos]

Is it possible to write the data in a dataview as XML? I use the dataview to
filter data from a dataset but I need to write that filtered data in the
dataview as an XML file.

Thanks,
Amos

 

[William Ryan eMVP]

There's no inherent method but you can walk through the dataview adding the
values to another datatable and then serialize it. Or you use iterate
through it and build the XML as you walk through it. I have the code to
iterate throug a dataview here:
http://www.knowdotnet.com/articles/dataviews1.html

 

[Amos]

Thanks for the help.

Would it be possible to create the datatable with the same column names as
another datatable in the dataset? The data in datatable Y (the new one)
would be a subset of the data in datatable A, so Y is exactly the same as A.
But these datatables have more than 30 columns, meaning I'd have to add 30+
columns to the new table.

Thanks.