«

Howdy,

I'm using VB.Net 2.0. Is there an easy object to use to handle XML?
Basically, i am collecting a ton of info from SQL, from various
Tables/Views/Procs, adding some data on the fly then I need to output the
entire thing to XML. I know i can create a string object and simply create
an XML string but that's messy. I know there's a XMLDocument object but I
can't seem to get it to work. Ideally, i'd like to have an XML object of
some sort and then work through it's elements/nodes and populate the
information as needed. If you could provide some sample script that'd be
great.

Thanks!
David Lozzi

To write xml, look at the XmlWriter

http://www.c-sharpcorner.com/UploadF...XmlWriter.aspx

or google it.

I think it is your "lightest weight" object for writing needs.

If you have an EXISTING xml doc, then you need to use the XmlDocument,
because you'll have to use something like

SelectNodes
SelectSingleNode

to navigate the tree, and find the correct place to insert/update data.



"David Lozzi" <> wrote in message
news:...
> Howdy,
>
> I'm using VB.Net 2.0. Is there an easy object to use to handle XML?
> Basically, i am collecting a ton of info from SQL, from various
> Tables/Views/Procs, adding some data on the fly then I need to output the
> entire thing to XML. I know i can create a string object and simply create
> an XML string but that's messy. I know there's a XMLDocument object but I
> can't seem to get it to work. Ideally, i'd like to have an XML object of
> some sort and then work through it's elements/nodes and populate the
> information as needed. If you could provide some sample script that'd be
> great.
>
> Thanks!
> David Lozzi

If you manipulated data can end in a DataSet then

Dim YourDataSetThatHasAllTheMinipulatedData as
System.Data.DataSet

YourDataSetThatHasAllTheMinipulatedData.WriteXml(" XMLFile.xml")

This might help you?


"David Lozzi" <> wrote in message
news:...
> Howdy,
>
> I'm using VB.Net 2.0. Is there an easy object to use to handle XML?
> Basically, i am collecting a ton of info from SQL, from various
> Tables/Views/Procs, adding some data on the fly then I need to output the
> entire thing to XML. I know i can create a string object and simply create
> an XML string but that's messy. I know there's a XMLDocument object but I
> can't seem to get it to work. Ideally, i'd like to have an XML object of
> some sort and then work through it's elements/nodes and populate the
> information as needed. If you could provide some sample script that'd be
> great.
>
> Thanks!
> David Lozzi

http://www.aspnettutorials.com/tutor...se/XML-vb.aspx

"David Lozzi" <> wrote in message
news:...
> Howdy,
>
> I'm using VB.Net 2.0. Is there an easy object to use to handle XML?
> Basically, i am collecting a ton of info from SQL, from various
> Tables/Views/Procs, adding some data on the fly then I need to output the
> entire thing to XML. I know i can create a string object and simply create
> an XML string but that's messy. I know there's a XMLDocument object but I
> can't seem to get it to work. Ideally, i'd like to have an XML object of
> some sort and then work through it's elements/nodes and populate the
> information as needed. If you could provide some sample script that'd be
> great.
>
> Thanks!
> David Lozzi

On Sep 27, 9:01 pm, "David Lozzi" <dlo...@nospam.nospam> wrote:
> Howdy,
>
> I'm using VB.Net 2.0. Is there an easy object to use to handle XML?
> Basically, i am collecting a ton of info from SQL, from various
> Tables/Views/Procs, adding some data on the fly then I need to output the
> entire thing to XML. I know i can create a string object and simply create
> an XML string but that's messy. I know there's a XMLDocument object but I
> can't seem to get it to work. Ideally, i'd like to have an XML object of
> some sort and then work through it's elements/nodes and populate the
> information as needed. If you could provide some sample script that'd be
> great.
>
> Thanks!
> David Lozzi

e.g. XmlTextWriter

StringWriter sw = new StringWriter();
XmlTextWriter writer = new XmlTextWriter(sw);
writer.WriteStartElement("...");
writer.WriteEndElement();
writer.Flush();
writer.Close();
sw.Close();