Load XML RowSetSchema????

[Lucas Tam]

I have an XML File which looks like:

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly" rs:updatable="true">
- <s:AttributeType name="Artist" rs:number="4" rs:nullable="true" rs:maydefer="true" rs:write="true" rs:basetable="Master" rs:basecolumn="Artist">
<s:datatype dt:type="string" dt:maxLength="70" />
</s:AttributeType>
- <s:AttributeType name="Description" rs:number="5" rs:nullable="true" rs:maydefer="true" rs:write="true" rs:basetable="Master" rs:basecolumn="Description">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="DiscNo" rs:number="1" rs:nullable="true" rs:maydefer="true" rs:write="true" rs:basetable="Master" rs:basecolumn="DiscNo">
<s:datatype dt:type="string" dt:maxLength="255" />
</s:AttributeType>
- <s:AttributeType name="Title" rs:number="3" rs:nullable="true" rs:maydefer="true" rs:write="true" rs:basetable="Master" rs:basecolumn="Title">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="TrackNo" rs:number="2" rs:nullable="true" rs:maydefer="true" rs:write="true" rs:basetable="Master" rs:basecolumn="TrackNo">
<s:datatype dt:type="float" dt:maxLength="8" rsrecision="15" rs:fixedlength="true" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
<z:row Artist="Children's Songs" Description="DKKaraoke Premiere" DiscNo="DK1103" Title="Mary Had A Little Lamb" TrackNo="1" />
</rs:data>
</xml>

Is there a way I can load it up in .NET???

I tried XMLDocument, but it complains about a missing root element.

Any ideas?

Thanks!

 

[Ken Tucker [MVP]]

Hi,

You will have to read the xml in manually. Hopefully this will
get you started.
http://support.microsoft.com/default.aspx?scid=kb;en-us;301225

Ken
---------------------
I have an XML File which looks like:

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly" rs:updatable="true">
- <s:AttributeType name="Artist" rs:number="4" rs:nullable="true"
rs:maydefer="true" rs:write="true" rs:basetable="Master"
rs:basecolumn="Artist">
<s:datatype dt:type="string" dt:maxLength="70" />
</s:AttributeType>
- <s:AttributeType name="Description" rs:number="5" rs:nullable="true"
rs:maydefer="true" rs:write="true" rs:basetable="Master"
rs:basecolumn="Description">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="DiscNo" rs:number="1" rs:nullable="true"
rs:maydefer="true" rs:write="true" rs:basetable="Master"
rs:basecolumn="DiscNo">
<s:datatype dt:type="string" dt:maxLength="255" />
</s:AttributeType>
- <s:AttributeType name="Title" rs:number="3" rs:nullable="true"
rs:maydefer="true" rs:write="true" rs:basetable="Master"
rs:basecolumn="Title">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="TrackNo" rs:number="2" rs:nullable="true"
rs:maydefer="true" rs:write="true" rs:basetable="Master"
rs:basecolumn="TrackNo">
<s:datatype dt:type="float" dt:maxLength="8" rsrecision="15"
rs:fixedlength="true" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
<z:row Artist="Children's Songs" Description="DKKaraoke Premiere"
DiscNo="DK1103" Title="Mary Had A Little Lamb" TrackNo="1" />
</rs:data>
</xml>

Is there a way I can load it up in .NET???

I tried XMLDocument, but it complains about a missing root element.

Any ideas?

Thanks!

 

[Lucas Tam]

You will have to read the xml in manually. Hopefully this
will
get you started.
http://support.microsoft.com/default.aspx?scid=kb;en-us;301225

I ended up using the Interop ADODB class to read the file - works great.


For some reason, the standard System.Text.XML classes complained about a
missing parent root or something like that.