This is a .net 1.1 question. I am attempting to load and process an
XML file (see below) with XmlDocument. I can load the file:
XmlDocument doc = new XmlDocument();
doc.Load("dump.xml");
but when I attempt to access it, I receive a "Additional information:
System error." message. I tried the XmlTextReader , but have the
same issue. The only reader that appears to work is the
XmlValidatingReader.
Question, if this is a an XML issue, why can I process the XML with
XmlValidatingReader and not XmlDocument? Also, I can load the
XmlDocument from the XmlValidatingReader but why not reading the xml
directly
Thanks
<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="store_sunshop">
<table_structure name="items">
<field Field="itemid" Type="int(10) unsigned" Null=""
Key="PRI" Extra="auto_increment" />
<field Field="categories" Type="varchar(250)"
Null="YES" Key="" Extra="" />
<field Field="title" Type="varchar(200)" Null="YES"
Key="" Extra="" />
<field Field="imagename" Type="varchar(250)"
Null="YES" Key="" Extra="" />
<field Field="thumb" Type="varchar(250)" Null="YES"
Key="" Extra="" />
<field Field="poverview" Type="text" Null="YES" Key=""
Extra="" />
<field Field="pdetails" Type="text" Null="YES" Key=""
Extra="" />
<field Field="meta_keywords" Type="varchar(255)"
Null="YES" Key="" Extra="" />
<field Field="meta_description" Type="varchar(255)"
Null="YES" Key="" Extra="" />
<field Field="quantity" Type="int(11)" Null="YES"
Key="" Extra="" />
<field Field="sold" Type="int(11)" Null="YES" Key=""
Extra="" />
<field Field="retail" Type="float" Null="YES" Key=""
Extra="" />
<field Field="price" Type="float" Null="YES" Key=""
Extra="" />
<field Field="sprice" Type="float" Null="YES" Key=""
Extra="" />
<field Field="fship" Type="float" Null="YES" Key=""
Extra="" />
<field Field="weight" Type="float" Null="YES" Key=""
Extra="" />
<field Field="shipsep" Type="enum('1','0')" Null="YES"
Key="" Default="0" Extra="" />
<field Field="length" Type="float" Null="YES" Key=""
Default="0" Extra="" />
<field Field="width" Type="float" Null="YES" Key=""
Default="0" Extra="" />
<field Field="height" Type="float" Null="YES" Key=""
Default="0" Extra="" />
<field Field="maxperbox" Type="float" Null="YES"
Key="" Default="0" Extra="" />
<field Field="cship" Type="char(3)" Null="YES" Key=""
Extra="" />
<field Field="ctax" Type="char(3)" Null="YES" Key=""
Extra="" />
<field Field="isnew" Type="char(3)" Null="YES" Key=""
Extra="" />
<field Field="isfeatured" Type="char(3)" Null="YES"
Key="" Extra="" />
<field Field="available" Type="varchar(5)" Null="YES"
Key="" Extra="" />
<field Field="viewable" Type="char(3)" Null="YES"
Key="" Extra="" />
<field Field="manufacturer" Type="varchar(255)"
Null="YES" Key="" Extra="" />
<field Field="vendor" Type="varchar(255)" Null="YES"
Key="" Extra="" />
<field Field="sku" Type="varchar(150)" Null="YES"
Key="" Extra="" />
<key Table="items" Non_unique="0" Key_name="PRIMARY"
Seq_in_index="1" Column_name="itemid" Collation="A" Cardinality="39"
Null="" Index_type="BTREE" Comment="" />
<options Name="items" Engine="MyISAM" Version="9"
Row_format="Dynamic" Rows="39" Avg_row_length="159" Data_length="6220"
Max_data_length="4294967295" Index_length="2048" Data_free="0"
Auto_increment="54" Create_time="2006-11-09 16:08:09"
Update_time="2006-11-10 15:47:09" Collation="latin1_swedish_ci"
Create_options="" Comment="" />
</table_structure>
<table_data name="items">
<row>
<field name="itemid">1</field>
<field
name="categories">3->1|5->8->34|9->44->49</field>
<field name="title">TEST Guide</field>
<field name="imagename"></field>
<field name="thumb"></field>
<field name="poverview">23nd edition - 2007</field>
<field name="pdetails"></field>
<field name="meta_keywords"></field>
<field name="meta_description"></field>
<field name="quantity">0</field>
<field name="sold">0</field>
<field name="retail">0</field>
<field name="price">22.95</field>
<field name="sprice">0</field>
<field name="fship">0</field>
<field name="weight">0</field>
<field name="shipsep"></field>
<field name="length">9</field>
<field name="width">1</field>
<field name="height">0</field>
<field name="maxperbox">0</field>
<field name="cship">Yes</field>
<field name="ctax">Yes</field>
<field name="isnew">Yes</field>
<field name="isfeatured">Yes</field>
<field name="available"></field>
<field name="viewable">No</field>
<field name="manufacturer">x</field>
<field name="vendor">x</field>
<field name="sku">660749589466</field>
</row>
</table_data>
</database>
</mysqldump>