How to read this XML file ?

S

Sagaert Johan

Hi

I want to put the data from this xml file into a dataset
How can i do that , i tried XmlTextReader without luck

Johan

<?xml version = "1.0" ?>
<?xml:stylesheet type="text/xsl" href="Bill of Materials-PCB_Project1.xsl"?>
<!DOCTYPE GRID [
<!ELEMENT GRID (BANDS, COLUMNS, ROWS*)>
<!ATTLIST GRID ExportVersion CDATA #REQUIRED>
<!ELEMENT BANDS (BAND*)>
<!ELEMENT BAND EMPTY>
<!ATTLIST BAND Index CDATA #REQUIRED>
<!ATTLIST BAND Caption CDATA #IMPLIED>
<!ELEMENT COLUMNS (COLUMN*)>
<!ELEMENT COLUMN EMPTY>
<!ATTLIST COLUMN Name CDATA #REQUIRED>
<!ATTLIST COLUMN Caption CDATA #IMPLIED>
<!ATTLIST COLUMN Index CDATA #REQUIRED>
<!ATTLIST COLUMN BandIndex CDATA #REQUIRED>
<!ATTLIST COLUMN RowIndex CDATA #REQUIRED>
<!ATTLIST COLUMN ColIndex CDATA #REQUIRED>
<!ATTLIST COLUMN Width CDATA #IMPLIED>
<!ELEMENT GROUP (GROUP*, ROW*)>
<!ATTLIST GROUP GroupText CDATA #IMPLIED>
<!ELEMENT ROWS (ROW*)>
<!ELEMENT ROW EMPTY>
<!ATTLIST ROW MainGridColumn8 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn16 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn17 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn29 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn39 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn56 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn15 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn36 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn52 CDATA #IMPLIED>
]>
<GRID ExportVersion="1.0">
<BANDS>
<BAND Index="0" Caption=""></BAND>
</BANDS>
<COLUMNS>
<COLUMN Name="MainGridColumn8" Caption="Comment" Index="0" BandIndex="0"
RowIndex="0" ColIndex="0" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn16" Caption="Description" Index="1"
BandIndex="0" RowIndex="0" ColIndex="1" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn17" Caption="Designator" Index="2"
BandIndex="0" RowIndex="0" ColIndex="2" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn29" Caption="Footprint" Index="3"
BandIndex="0" RowIndex="0" ColIndex="3" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn39" Caption="LibRef" Index="4" BandIndex="0"
RowIndex="0" ColIndex="4" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn56" Caption="Quantity" Index="5"
BandIndex="0" RowIndex="0" ColIndex="5" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn15" Caption="deel" Index="6" BandIndex="0"
RowIndex="0" ColIndex="6" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn36" Caption="levid" Index="7" BandIndex="0"
RowIndex="0" ColIndex="7" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn52" Caption="prijs" Index="8" BandIndex="0"
RowIndex="0" ColIndex="8" Width="100"></COLUMN>
</COLUMNS>
<ROWS>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R1"" MainGridColumn29="axial" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="10K" MainGridColumn36="aty"
MainGridColumn52="10"></ROW>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R2" MainGridColumn29="AXIAL-0.3" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="aviaa" MainGridColumn16="Resistor"
MainGridColumn17="R3" MainGridColumn29="axial" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="22K" MainGridColumn36="farn"
MainGridColumn52="25"></ROW>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R4" MainGridColumn29="AXIAL-0.3" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="47K" MainGridColumn16="Resistor"
MainGridColumn17="R45" MainGridColumn29="AXIAL-0.3" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="27C512" MainGridColumn16=""
MainGridColumn17="U?" MainGridColumn29="DIP-28"
MainGridColumn39="27C512" MainGridColumn56="1" MainGridColumn15="10K"
MainGridColumn36="aty" MainGridColumn52="10"></ROW>
</ROWS>
</GRID>
 
M

Michael Nemtsev [MVP]

Hello Sagaert,

What did you try and where you failed?


---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo


SJ> I want to put the data from this xml file into a dataset How can i
SJ> do that , i tried XmlTextReader without luck
SJ>
 
P

Peter Bromberg [C# MVP]

DataSet ds = new DataSet();
ds.ReadXml(System.Environment.CurrentDirectory + @"\XmlFile1.xml");
--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com



Sagaert Johan said:
Hi

I want to put the data from this xml file into a dataset
How can i do that , i tried XmlTextReader without luck

Johan

<?xml version = "1.0" ?>
<?xml:stylesheet type="text/xsl" href="Bill of Materials-PCB_Project1.xsl"?>
<!DOCTYPE GRID [
<!ELEMENT GRID (BANDS, COLUMNS, ROWS*)>
<!ATTLIST GRID ExportVersion CDATA #REQUIRED>
<!ELEMENT BANDS (BAND*)>
<!ELEMENT BAND EMPTY>
<!ATTLIST BAND Index CDATA #REQUIRED>
<!ATTLIST BAND Caption CDATA #IMPLIED>
<!ELEMENT COLUMNS (COLUMN*)>
<!ELEMENT COLUMN EMPTY>
<!ATTLIST COLUMN Name CDATA #REQUIRED>
<!ATTLIST COLUMN Caption CDATA #IMPLIED>
<!ATTLIST COLUMN Index CDATA #REQUIRED>
<!ATTLIST COLUMN BandIndex CDATA #REQUIRED>
<!ATTLIST COLUMN RowIndex CDATA #REQUIRED>
<!ATTLIST COLUMN ColIndex CDATA #REQUIRED>
<!ATTLIST COLUMN Width CDATA #IMPLIED>
<!ELEMENT GROUP (GROUP*, ROW*)>
<!ATTLIST GROUP GroupText CDATA #IMPLIED>
<!ELEMENT ROWS (ROW*)>
<!ELEMENT ROW EMPTY>
<!ATTLIST ROW MainGridColumn8 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn16 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn17 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn29 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn39 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn56 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn15 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn36 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn52 CDATA #IMPLIED>
]>
<GRID ExportVersion="1.0">
<BANDS>
<BAND Index="0" Caption=""></BAND>
</BANDS>
<COLUMNS>
<COLUMN Name="MainGridColumn8" Caption="Comment" Index="0" BandIndex="0"
RowIndex="0" ColIndex="0" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn16" Caption="Description" Index="1"
BandIndex="0" RowIndex="0" ColIndex="1" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn17" Caption="Designator" Index="2"
BandIndex="0" RowIndex="0" ColIndex="2" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn29" Caption="Footprint" Index="3"
BandIndex="0" RowIndex="0" ColIndex="3" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn39" Caption="LibRef" Index="4" BandIndex="0"
RowIndex="0" ColIndex="4" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn56" Caption="Quantity" Index="5"
BandIndex="0" RowIndex="0" ColIndex="5" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn15" Caption="deel" Index="6" BandIndex="0"
RowIndex="0" ColIndex="6" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn36" Caption="levid" Index="7" BandIndex="0"
RowIndex="0" ColIndex="7" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn52" Caption="prijs" Index="8" BandIndex="0"
RowIndex="0" ColIndex="8" Width="100"></COLUMN>
</COLUMNS>
<ROWS>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R1"" MainGridColumn29="axial" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="10K" MainGridColumn36="aty"
MainGridColumn52="10"></ROW>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R2" MainGridColumn29="AXIAL-0.3" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="aviaa" MainGridColumn16="Resistor"
MainGridColumn17="R3" MainGridColumn29="axial" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="22K" MainGridColumn36="farn"
MainGridColumn52="25"></ROW>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R4" MainGridColumn29="AXIAL-0.3" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="47K" MainGridColumn16="Resistor"
MainGridColumn17="R45" MainGridColumn29="AXIAL-0.3" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="27C512" MainGridColumn16=""
MainGridColumn17="U?" MainGridColumn29="DIP-28"
MainGridColumn39="27C512" MainGridColumn56="1" MainGridColumn15="10K"
MainGridColumn36="aty" MainGridColumn52="10"></ROW>
</ROWS>
</GRID>
Click to expand...
 
S

Sagaert Johan

Hi

it complains
The ':' character, hexadecimal value 0x3A, cannot be included in a name.
Line 2, position 6.

Maybe the XML does not follow the rules of the game...


Peter Bromberg said:
DataSet ds = new DataSet();
ds.ReadXml(System.Environment.CurrentDirectory + @"\XmlFile1.xml");
--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com



Sagaert Johan said:
Hi

I want to put the data from this xml file into a dataset
How can i do that , i tried XmlTextReader without luck

Johan

<?xml version = "1.0" ?>
<?xml:stylesheet type="text/xsl" href="Bill of
Materials-PCB_Project1.xsl"?>
<!DOCTYPE GRID [
<!ELEMENT GRID (BANDS, COLUMNS, ROWS*)>
<!ATTLIST GRID ExportVersion CDATA #REQUIRED>
<!ELEMENT BANDS (BAND*)>
<!ELEMENT BAND EMPTY>
<!ATTLIST BAND Index CDATA #REQUIRED>
<!ATTLIST BAND Caption CDATA #IMPLIED>
<!ELEMENT COLUMNS (COLUMN*)>
<!ELEMENT COLUMN EMPTY>
<!ATTLIST COLUMN Name CDATA #REQUIRED>
<!ATTLIST COLUMN Caption CDATA #IMPLIED>
<!ATTLIST COLUMN Index CDATA #REQUIRED>
<!ATTLIST COLUMN BandIndex CDATA #REQUIRED>
<!ATTLIST COLUMN RowIndex CDATA #REQUIRED>
<!ATTLIST COLUMN ColIndex CDATA #REQUIRED>
<!ATTLIST COLUMN Width CDATA #IMPLIED>
<!ELEMENT GROUP (GROUP*, ROW*)>
<!ATTLIST GROUP GroupText CDATA #IMPLIED>
<!ELEMENT ROWS (ROW*)>
<!ELEMENT ROW EMPTY>
<!ATTLIST ROW MainGridColumn8 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn16 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn17 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn29 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn39 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn56 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn15 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn36 CDATA #IMPLIED>
<!ATTLIST ROW MainGridColumn52 CDATA #IMPLIED>
]>
<GRID ExportVersion="1.0">
<BANDS>
<BAND Index="0" Caption=""></BAND>
</BANDS>
<COLUMNS>
<COLUMN Name="MainGridColumn8" Caption="Comment" Index="0"
BandIndex="0"
RowIndex="0" ColIndex="0" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn16" Caption="Description" Index="1"
BandIndex="0" RowIndex="0" ColIndex="1" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn17" Caption="Designator" Index="2"
BandIndex="0" RowIndex="0" ColIndex="2" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn29" Caption="Footprint" Index="3"
BandIndex="0" RowIndex="0" ColIndex="3" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn39" Caption="LibRef" Index="4"
BandIndex="0"
RowIndex="0" ColIndex="4" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn56" Caption="Quantity" Index="5"
BandIndex="0" RowIndex="0" ColIndex="5" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn15" Caption="deel" Index="6"
BandIndex="0"
RowIndex="0" ColIndex="6" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn36" Caption="levid" Index="7"
BandIndex="0"
RowIndex="0" ColIndex="7" Width="100"></COLUMN>
<COLUMN Name="MainGridColumn52" Caption="prijs" Index="8"
BandIndex="0"
RowIndex="0" ColIndex="8" Width="100"></COLUMN>
</COLUMNS>
<ROWS>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R1"" MainGridColumn29="axial" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="10K" MainGridColumn36="aty"
MainGridColumn52="10"></ROW>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R2" MainGridColumn29="AXIAL-0.3"
MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="aviaa" MainGridColumn16="Resistor"
MainGridColumn17="R3" MainGridColumn29="axial" MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="22K" MainGridColumn36="farn"
MainGridColumn52="25"></ROW>
<ROW MainGridColumn8="Res1" MainGridColumn16="Resistor"
MainGridColumn17="R4" MainGridColumn29="AXIAL-0.3"
MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="47K" MainGridColumn16="Resistor"
MainGridColumn17="R45" MainGridColumn29="AXIAL-0.3"
MainGridColumn39="Res1"
MainGridColumn56="1" MainGridColumn15="" MainGridColumn36=""
MainGridColumn52=""></ROW>
<ROW MainGridColumn8="27C512" MainGridColumn16=""
MainGridColumn17="U?" MainGridColumn29="DIP-28"
MainGridColumn39="27C512" MainGridColumn56="1" MainGridColumn15="10K"
MainGridColumn36="aty" MainGridColumn52="10"></ROW>
</ROWS>
</GRID>
Click to expand...
Click to expand...
 
M

Martin Honnen

Sagaert said:
it complains
The ':' character, hexadecimal value 0x3A, cannot be included in a name.
Line 2, position 6.

Maybe the XML does not follow the rules of the game...
Click to expand...

Yes, you need <?xml-stylesheet instead of <?xml:stylesheet you have below:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frmework for layout forms using XML 2
How can I get this code to work? 1

Top