> I can't handle this XML-Schema (below)
What you show below is an XML instance document, not an XML schema.
> I want to access the data like "Select Name from DATA".
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/).

Signature
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
Chuck Vance - 29 Aug 2007 23:48 GMT
>> I can't handle this XML-Schema (below)
> What you show below is an XML instance document, not an XML schema.
you exchange the form with the content! It's the schema that problems me.
However this question is about to process the data with built-in .NET-routines without writing own iterative functions.
> use XPath e.g.
> /xd:dataset/xd:data/xd:row/xd:value
> selects all value elements (assuming prefix xd is bound to namespace
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.