I have an xml file. I need to write a program that will read the xml file and its node export to database and format to cvs file as a complete order. I need some to help how should i do it. here is part of my xml.
<BSN BSN01="00" BSN02="193515"
BSN03="2007-05-31" BSN04="11:59:38" BSN05="0001" />
<HL HL01="1" HL02="0" HL03="S" />
<TD1 TD101="CTN25"
TD102="105" TD106="G" TD107="581.16" TD108="KG" />
<DTM_2 DTM01="011"
DTM02="2007-05-31" />
<FOB FOB01="CC" />
<N1 N101="ST" N102="WALMART 3135 - BRAMPTON" N103="UL" N104="0681131001359" />
N1Loop1>
<N1 N101="SF" N102="Vantage Foods (MC)"
/>
N1Loop1>
HLLoop1>
<HL HL01="2" HL02="1" HL03="O" />
<PRF PRF01="9300101243"
PRF04="2007-05-31" />
<REF REF01="IA" REF02="028372930"
/>
<REF REF01="DP" REF02="00093" />
<REF REF01="MR" REF02="0037" />
<REF REF01="IV" REF02="679319" />
HLLoop1>
<HL HL01="3" HL02="1" HL03="P" />
<MAN MAN01="GM" MAN02="00008731256900027718"
/>
HLLoop1>
<HL HL01="4" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="221029000004"
LIN04="IN"
LIN05="009304481" LIN06="VN" LIN07="9304481" />
<SN1 SN102="24.61"
SN103="EA"
/>
HLLoop1>
<HL HL01="5" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="221005000004"
LIN04="IN"
LIN05="009303977" LIN06="VN" LIN07="9303977" />
<SN1 SN102="4.11"
SN103="EA"
/>
HLLoop1>
<HL HL01="6" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220011000008"
LIN04="IN"
LIN05="009306413" LIN06="VN" LIN07="9306413" />
<SN1 SN102="2.85"
SN103="EA"
/>
HLLoop1>
<HL HL01="7" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220060000004"
LIN04="IN"
LIN05="009308142" LIN06="VN" LIN07="9308142" />
<SN1 SN102="2.3"
SN103="EA"
/>
HLLoop1>
<HL HL01="8" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220042000008"
LIN04="IN"
LIN05="009303928" LIN06="VN" LIN07="9303928" />
<SN1 SN102="7.02"
SN103="EA"
/>
HLLoop1>
<HL HL01="9" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220021000005"
LIN04="IN"
LIN05="009306483" LIN06="VN" LIN07="9306483" />
<SN1 SN102="2.67"
SN103="EA"
/>
HLLoop1>
<HL HL01="10" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220038000005"
LIN04="IN"
LIN05="009303900" LIN06="VN" LIN07="9303900" />
<SN1 SN102="3.17"
SN103="EA"
/>
HLLoop1>
<HL HL01="11" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220059000008"
LIN04="IN"
LIN05="009307659" LIN06="VN" LIN07="9307659" />
<SN1 SN102="6.68"
SN103="EA"
/>
HLLoop1>
<HL HL01="12" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="605388183781"
LIN04="IN"
LIN05="009307596" LIN06="VN" LIN07="9307596" />
<SN1 SN102="24" SN103="EA" />
HLLoop1>
<HL HL01="13" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="221039000001"
LIN04="IN"
LIN05="009307666" LIN06="VN" LIN07="9307666" />
<SN1 SN102="40.76"
SN103="EA"
/>
HLLoop1>
<HL HL01="14" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="605388183767"
LIN04="IN"
LIN05="009307589" LIN06="VN" LIN07="9307589" />
<SN1 SN102="36" SN103="EA" />
HLLoop1>
<HL HL01="15" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220010000009"
LIN04="IN"
LIN05="009306406" LIN06="VN" LIN07="9306406" />
<SN1 SN102="3.67"
SN103="EA"
/>
HLLoop1>
<HL HL01="16" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="221021000002"
LIN04="IN"
LIN05="009304607" LIN06="VN" LIN07="9304607" />
<SN1 SN102="3.08"
SN103="EA"
/>
HLLoop1>
<HL HL01="17" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="221028000005"
LIN04="IN"
LIN05="009307813" LIN06="VN" LIN07="9307813" />
<SN1 SN102="26.56"
SN103="EA"
/>
HLLoop1>
<HL HL01="18" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220039000004"
LIN04="IN"
LIN05="009303907" LIN06="VN" LIN07="9303907" />
<SN1 SN102="14.25"
SN103="EA"
/>
HLLoop1>
<HL HL01="19" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220065000009"
LIN04="IN"
LIN05="009308674" LIN06="VN" LIN07="9308674" />
<SN1 SN102="3.96"
SN103="EA"
/>
HLLoop1>
<HL HL01="20" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="221011000005"
LIN04="IN"
LIN05="009307764" LIN06="VN" LIN07="9307764" />
<SN1 SN102="4.17"
SN103="EA"
/>
HLLoop1>
<HL HL01="21" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220066000008"
LIN04="IN"
LIN05="009308681" LIN06="VN" LIN07="9308681" />
<SN1 SN102="4.21"
SN103="EA"
/>
HLLoop1>
<HL HL01="22" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220005000007"
LIN04="IN"
LIN05="009306371" LIN06="VN" LIN07="9306371" />
<SN1 SN102="2.14"
SN103="EA"
/>
HLLoop1>
<HL HL01="23" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220041000009"
LIN04="IN"
LIN05="009303921" LIN06="VN" LIN07="9303921" />
<SN1 SN102="3" SN103="EA" />
HLLoop1>
<HL HL01="24" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220022000004"
LIN04="IN"
LIN05="009306490" LIN06="VN" LIN07="9306490" />
<SN1 SN102="4.36"
SN103="EA"
/>
HLLoop1>
<HL HL01="25" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220001000001"
LIN04="IN"
LIN05="009306343" LIN06="VN" LIN07="9306343" />
<SN1 SN102="4.13"
SN103="EA"
/>
HLLoop1>
<HL HL01="26" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220030000003"
LIN04="IN"
LIN05="009303844" LIN06="VN" LIN07="9303844" />
<SN1 SN102="2.77"
SN103="EA"
/>
HLLoop1>
<HL HL01="27" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="221020000003"
LIN04="IN"
LIN05="009307785" LIN06="VN" LIN07="9307785" />
<SN1 SN102="10.23"
SN103="EA"
/>
HLLoop1>
<HL HL01="28" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220008000004"
LIN04="IN"
LIN05="009306392" LIN06="VN" LIN07="9306392" />
<SN1 SN102="3.32"
SN103="EA"
/>
HLLoop1>
<HL HL01="29" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220055000002"
LIN04="IN"
LIN05="009306679" LIN06="VN" LIN07="9306679" />
<SN1 SN102="3.18"
SN103="EA"
/>
HLLoop1>
<HL HL01="30" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220007000005"
LIN04="IN"
LIN05="009306385" LIN06="VN" LIN07="9306385" />
<SN1 SN102="10.36"
SN103="EA"
/>
HLLoop1>
<HL HL01="31" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="605388183699"
LIN04="IN"
LIN05="009307561" LIN06="VN" LIN07="9307561" />
<SN1 SN102="12" SN103="EA" />
HLLoop1>
<HL HL01="32" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220018000001"
LIN04="IN"
LIN05="009306462" LIN06="VN" LIN07="9306462" />
<SN1 SN102="2.41"
SN103="EA"
/>
HLLoop1>
<HL HL01="33" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220002000000"
LIN04="IN"
LIN05="009308149" LIN06="VN" LIN07="9308149" />
<SN1 SN102="8.97"
SN103="EA"
/>
HLLoop1>
<HL HL01="34" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="605388183651"
LIN04="IN"
LIN05="009307540" LIN06="VN" LIN07="9307540" />
<SN1 SN102="36" SN103="EA" />
HLLoop1>
<HL HL01="35" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="605388183637"
LIN04="IN"
LIN05="009307533" LIN06="VN" LIN07="9307533" />
<SN1 SN102="12" SN103="EA" />
HLLoop1>
<HL HL01="36" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="605388183729"
LIN04="IN"
LIN05="009307568" LIN06="VN" LIN07="9307568" />
<SN1 SN102="8" SN103="EA" />
HLLoop1>
<HL HL01="37" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220017000002"
LIN04="IN"
LIN05="009306455" LIN06="VN" LIN07="9306455" />
<SN1 SN102="3.47"
SN103="EA"
/>
HLLoop1>
<HL HL01="38" HL02="3" HL03="I" />
<LIN LIN02="UP" LIN03="220031000002"
LIN04="IN"
LIN05="009303851" LIN06="VN" LIN07="9303851" />
<SN1 SN102="3.98"
SN103="EA"
/>
HLLoop1>
<HL HL01="39" HL02="1" HL03="P" />
<MAN MAN01="GM" MAN02="00008731256900027817"
/>
HLLoop1>
<HL HL01="40" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221013000003"
LIN04="IN"
LIN05="009307771" LIN06="VN" LIN07="9307771" />
<SN1 SN102="17.93"
SN103="EA"
/>
HLLoop1>
<HL HL01="41" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221001000008"
LIN04="IN"
LIN05="009303949" LIN06="VN" LIN07="9303949" />
<SN1 SN102="3.76"
SN103="EA"
/>
HLLoop1>
<HL HL01="42" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221026000007"
LIN04="IN"
LIN05="009307799" LIN06="VN" LIN07="9307799" />
<SN1 SN102="12.31"
SN103="EA"
/>
HLLoop1>
<HL HL01="43" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="605388183750"
LIN04="IN"
LIN05="009307582" LIN06="VN" LIN07="9307582" />
<SN1 SN102="8" SN103="EA" />
HLLoop1>
<HL HL01="44" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221006000003"
LIN04="IN"
LIN05="009303984" LIN06="VN" LIN07="9303984" />
<SN1 SN102="20.28"
SN103="EA"
/>
HLLoop1>
<HL HL01="45" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="605388183620"
LIN04="IN"
LIN05="009307526" LIN06="VN" LIN07="9307526" />
<SN1 SN102="24" SN103="EA" />
HLLoop1>
<HL HL01="46" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221020000003"
LIN04="IN"
LIN05="009307785" LIN06="VN" LIN07="9307785" />
<SN1 SN102="5.09"
SN103="EA"
/>
HLLoop1>
<HL HL01="47" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="605388183668"
LIN04="IN"
LIN05="009307547" LIN06="VN" LIN07="9307547" />
<SN1 SN102="24" SN103="EA" />
HLLoop1>
<HL HL01="48" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221031000009"
LIN04="IN"
LIN05="009307820" LIN06="VN" LIN07="9307820" />
<SN1 SN102="2.64"
SN103="EA"
/>
HLLoop1>
<HL HL01="49" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221030000000"
LIN04="IN"
LIN05="009304684" LIN06="VN" LIN07="9304684" />
<SN1 SN102="4.77"
SN103="EA"
/>
HLLoop1>
<HL HL01="50" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221003000006"
LIN04="IN"
LIN05="009303963" LIN06="VN" LIN07="9303963" />
<SN1 SN102="6.23"
SN103="EA"
/>
HLLoop1>
<HL HL01="51" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="220048000002"
LIN04="IN"
LIN05="009306616" LIN06="VN" LIN07="9306616" />
<SN1 SN102="4.63"
SN103="EA"
/>
HLLoop1>
<HL HL01="52" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221024000009"
LIN04="IN"
LIN05="009304621" LIN06="VN" LIN07="9304621" />
<SN1 SN102="5.22"
SN103="EA"
/>
HLLoop1>
<HL HL01="53" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="605388183682"
LIN04="IN"
LIN05="009307554" LIN06="VN" LIN07="9307554" />
<SN1 SN102="4" SN103="EA" />
HLLoop1>
<HL HL01="54" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221019000007"
LIN04="IN"
LIN05="009304418" LIN06="VN" LIN07="9304418" />
<SN1 SN102="7.98"
SN103="EA"
/>
HLLoop1>
<HL HL01="55" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221002000007"
LIN04="IN"
LIN05="009303956" LIN06="VN" LIN07="9303956" />
<SN1 SN102="25.45"
SN103="EA"
/>
HLLoop1>
<HL HL01="56" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221036000004"
LIN04="IN"
LIN05="009307638" LIN06="VN" LIN07="9307638" />
<SN1 SN102="5.49"
SN103="EA"
/>
HLLoop1>
<HL HL01="57" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221012000004"
LIN04="IN"
LIN05="009304544" LIN06="VN" LIN07="9304544" />
<SN1 SN102="5.1"
SN103="EA"
/>
HLLoop1>
<HL HL01="58" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221038000002"
LIN04="IN"
LIN05="009307652" LIN06="VN" LIN07="9307652" />
<SN1 SN102="4.49"
SN103="EA"
/>
HLLoop1>
<HL HL01="59" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="220015000004"
LIN04="IN"
LIN05="009306441" LIN06="VN" LIN07="9306441" />
<SN1 SN102="3.32"
SN103="EA"
/>
HLLoop1>
<HL HL01="60" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="220028000008"
LIN04="IN"
LIN05="009303830" LIN06="VN" LIN07="9303830" />
<SN1 SN102="2.81"
SN103="EA"
/>
HLLoop1>
<HL HL01="61" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="220027000009"
LIN04="IN"
LIN05="009303823" LIN06="VN" LIN07="9303823" />
<SN1 SN102="2.69"
SN103="EA"
/>
HLLoop1>
<HL HL01="62" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="220040000000"
LIN04="IN"
LIN05="009303914" LIN06="VN" LIN07="9303914" />
<SN1 SN102="6.53"
SN103="EA"
/>
HLLoop1>
<HL HL01="63" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="220029000007"
LIN04="IN"
LIN05="009303837" LIN06="VN" LIN07="9303837" />
<SN1 SN102="9.05"
SN103="EA"
/>
HLLoop1>
<HL HL01="64" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221010000006"
LIN04="IN"
LIN05="009304495" LIN06="VN" LIN07="9304495" />
<SN1 SN102="7.82"
SN103="EA"
/>
HLLoop1>
<HL HL01="65" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221008000001"
LIN04="IN"
LIN05="009304523" LIN06="VN" LIN07="9304523" />
<SN1 SN102="7.1"
SN103="EA"
/>
HLLoop1>
<HL HL01="66" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="605388183798"
LIN04="IN"
LIN05="009307603" LIN06="VN" LIN07="9307603" />
<SN1 SN102="8" SN103="EA" />
HLLoop1>
<HL HL01="67" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="605388183736"
LIN04="IN"
LIN05="009307575" LIN06="VN" LIN07="9307575" />
<SN1 SN102="4" SN103="EA" />
HLLoop1>
<HL HL01="68" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="220049000001"
LIN04="IN"
LIN05="009306623" LIN06="VN" LIN07="9306623" />
<SN1 SN102="12.08"
SN103="EA"
/>
HLLoop1>
<HL HL01="69" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221041000006"
LIN04="IN"
LIN05="009307883" LIN06="VN" LIN07="9307883" />
<SN1 SN102="10.74"
SN103="EA"
/>
HLLoop1>
<HL HL01="70" HL02="39" HL03="I" />
<LIN LIN02="UP" LIN03="221027000006"
LIN04="IN"
LIN05="009307806" LIN06="VN" LIN07="9307806" />
<SN1 SN102="10.35"
SN103="EA"
/>
HLLoop1>
<CTT CTT01="70" />
X12_4010_856>
should i create console program
please help
should i create console program
please help
Mahesh ChandPosted Jan 22, 2009, 9:31 AM
You can create a console application but then you will have to hardcode the path and file name in the application or read it from app.config file. If you need to select a file, then build a Windows Forms application.
To learn how to work with XML files, read this small book:
http://www.c-sharpcorner.com/UploadFile/mahesh/XmlProgramming09142007082751AM/XmlProgramming.aspx