Hi,

My program uses a web service to return data from sql database.It returns data in xml format.In this case, 2 rows of results are in node 3 & the remaining in node 4.
Using vb.net, I need to read the returned XML & create my own xml so that all the above results are stored within one node to be read into a single datatable.
How do i do this. Any help?

The easiest way to do this is by writing an XSLT transformation.

Or perhaps you knew that already, it's not clear. If so, you need to explain where you're having difficulty.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference