Hi ng,
I can't handle this XML-Schema (below)
I want to access the data like "Select Name from DATA".

<?xml version="1.0" encoding="utf-8"?>
<dataset xmlns="http://developer.cognos.com/schemas/xmldata/1/" xmlns:xs="http://www.w3.org/2001/XMLSchema-instance">
<!--
<dataset
xmlns="http://developer.cognos.com/schemas/xmldata/1/"
xmlns:xs="http://www.w3.org/2001/XMLSchema-instance"
xs:schemaLocation="http://developer.cognos.com/schemas/xmldata/1/ xmldata.xsd"
<metadata>
<item name="Name" type="xs:string" length="202"/>
<item name="Familyname" type="xs:string" length="102"/>
</metadata>
<data>
<row>
<value>Kohl</value>
<value>Helmut</value>
</row>
<row>
<value>Merkel</value>
<value>Angela</value>
</row>
</data>
</dataset>

Chuck Vance wrote:

What you show below is an XML instance document, not an XML schema.

That is SQL. For XML querying you use XPath e.g.
/xd:dataset/xd:data/xd:row/xd:value
selects all value elements (assuming prefix xd is bound to namespace
http://developer.cognos.com/schemas/xmldata/1/).



--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

Chuck Vance wrote:

What you show below is an XML instance document, not an XML schema.

That is SQL. For XML querying you use XPath e.g.
/xd:dataset/xd:data/xd:row/xd:value
selects all value elements (assuming prefix xd is bound to namespace
http://developer.cognos.com/schemas/xmldata/1/).



--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

However this question is about to process the data with built-in .NET-routines without writing own iterative functions.

I tried to read the document with XPath-Methods etc. but I failed to get the information like this:
XMLElement.Name="Familyname"
XMLElement.Value="Merkel"

I can't combine the information inside the XML-document like above.
The field-names are declared - the rows is listed - and the values are defined -
but I haven't yet found the right way to restore the information by a System.XML..Command.

Chuck.

However this question is about to process the data with built-in .NET-routines without writing own iterative functions.

I tried to read the document with XPath-Methods etc. but I failed to get the information like this:
XMLElement.Name="Familyname"
XMLElement.Value="Merkel"

I can't combine the information inside the XML-document like above.
The field-names are declared - the rows is listed - and the values are defined -
but I haven't yet found the right way to restore the information by a System.XML..Command.

Chuck.