parseing an xml string

[Keith Henderson]

I have an xml document loaded into a string that I need to parse. below is
the first few elements in the xml string.

<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice minOccurs="0" maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:sequence>
<xs:element name="CustomerS hortName">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CreateDat e" type="xs:dateTi me" />
.... there is more I didn't show......
I need to step through it and if you look closely you see 2 keys
identifying column names, CustomerShortNa me and CreateDate

they are defined as
<xs:element name="CustomerS hortName">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>

and

<xs:element name="CreateDat e" type="xs:dateTi me" />
I need to step through the entire xml document and retrieve out
CustomerShortNa me, string, 10
and
CreateDate, dateTime

can someone show me how to parse this?

[CJ Taylor]

If you need to "step through" XML you should use an SAX Parser. DOM Parsers
read in the entire document and then allow you to parse, SAX will actually
raise events for elements being read/parsed.

There is a free SAX Parser that comes with the Visual Basic Resource Kit I
believe.

-CJ

"Keith Henderson" <kh********@pro jectresources.n ospam.com> wrote in message
news:uQ******** ******@TK2MSFTN GP15.phx.gbl...

I have an xml document loaded into a string that I need to parse. below is the first few elements in the xml string.

<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice minOccurs="0" maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:sequence>
<xs:element name="CustomerS hortName">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CreateDat e" type="xs:dateTi me" />
.... there is more I didn't show......
I need to step through it and if you look closely you see 2 keys
identifying column names, CustomerShortNa me and CreateDate

they are defined as
<xs:element name="CustomerS hortName">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>

and

<xs:element name="CreateDat e" type="xs:dateTi me" />
I need to step through the entire xml document and retrieve out
CustomerShortNa me, string, 10
and
CreateDate, dateTime

can someone show me how to parse this?

[Tom Shelton]

In article <uQ************ **@TK2MSFTNGP15 .phx.gbl>, Keith Henderson wrote:

I have an xml document loaded into a string that I need to parse. below is
the first few elements in the xml string.

<?xml version="1.0" standalone="yes "?>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice minOccurs="0" maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:sequence>
<xs:element name="CustomerS hortName">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CreateDat e" type="xs:dateTi me" />
.... there is more I didn't show......
I need to step through it and if you look closely you see 2 keys
identifying column names, CustomerShortNa me and CreateDate

they are defined as
<xs:element name="CustomerS hortName">
<xs:simpleTyp e>
<xs:restricti on base="xs:string ">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>

and

<xs:element name="CreateDat e" type="xs:dateTi me" />
I need to step through the entire xml document and retrieve out
CustomerShortNa me, string, 10
and
CreateDate, dateTime

can someone show me how to parse this?

You'll probably want to look at the documentation and example for
System.Xml.XmlT extReader....
--
Tom Shelton [MVP]

[Tom Shelton]

In article <uw************ *@TK2MSFTNGP11. phx.gbl>, CJ Taylor wrote:

If you need to "step through" XML you should use an SAX Parser. DOM Parsers
read in the entire document and then allow you to parse, SAX will actually
raise events for elements being read/parsed.

There is a free SAX Parser that comes with the Visual Basic Resource Kit I
believe.

-CJ

I think that XmlTextReader meets these requirements...

from the docs:

XmlTextReader Class
Represents a reader that provides fast, NON-CACHED, forward-only access
to XML data.

I don't think he really needs the resource kit....
--
Tom Shelton [MVP]

[Cor Ligthert]

Keith,

I would use the XMLnodereader, see this sample I have made for somebody
else.

http://groups.google.com/groups?selm...phx.gbl&rnum=1

I hope this helps?

Cor