Click here to Skip to main content
15,883,855 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi There,

I have an XML file generated from html(submission) form. I am using just html pages for my project. now is there any way to store those XML file data into sql ?

Do I need to use the asp pages for that ? or is there any way that from html coding I can just push all the data into the sql?

My XML file is here.

XML
<CustomerDetails>
<SalesPersonList>Dave Barker
</SalesPersonList>
<CustomerName/>
<ContactNo/>
<ProductionList>LFD
</ProductionList>
<ShippingDueDate>11/28/2012
</ShippingDueDate>
<Description/>
<ShippingDueTime/>
<EstimateNum/>
<Description1/>
<Files1/>
<Qty1/>
<InkList1>4/0
</InkList1>
<StockSelectMenu1>12 pt Card - max 50 x 72
</StockSelectMenu1>
<BacklightList1>Select
</BacklightList1>
<CuttingMenu1>Select
</CuttingMenu1>
<WhiteList1>Select
</WhiteList1>
<LaminationList1>None
</LaminationList1>
<OtherFinishingList>None
</OtherFinishingList>
<Description2/>
<Files2/>
<Qty2/>
<InkList2>4/0
</InkList2>
<StockSelectMenu2>50 pt Card -max 45 x 65
</StockSelectMenu2>
<BacklightList2>Select
</BacklightList2>
<CuttingMenu2>Select
</CuttingMenu2>
<WhiteList2>Select
</WhiteList2>
<LaminationList2>None
</LaminationList2>
<OtherFinishingList2>None
</OtherFinishingList2>
<Description3/>
<Files3/>
<Qty3/>
<InkList3>4/0
</InkList3>
<StockSelectMenu3>.0175 Translucent Styrene -max 48 x 96
</StockSelectMenu3>
<BacklightList3>Select
</BacklightList3>
<CuttingMenu3>Select
</CuttingMenu3>
<WhiteList3>Select
</WhiteList3>
<LaminationList3>None
</LaminationList3>
<OtherFinishingList3>None
</OtherFinishingList3>
<Description4/>
<Files4/>
<Qty4/>
<InkList4>4/0
</InkList4>
<StockSelectMenu4>Wall Noodle -max width 54"
</StockSelectMenu4>
<BacklightList4>Select
</BacklightList4>
<CuttingMenu4>Select
</CuttingMenu4>
<WhiteList4>Select
</WhiteList4>
<LaminationList4>None
</LaminationList4>
<OtherFinishingList4>None
</OtherFinishingList4>
<Description5/>
<Files5/>
<Qty5/>
<InkList5>4/0
</InkList5>
<StockSelectMenu5>12 pt Card - max 50 x 72
</StockSelectMenu5>
<BacklightList5>Select
</BacklightList5>
<CuttingMenu5>Select
</CuttingMenu5>
<WhiteList5>Select
</WhiteList5>
<LaminationList5>None
</LaminationList5>
<OtherFinishingList5>None
</OtherFinishingList5>
<Description6/>
<Files6/>
<Qty6/>
<InkList6>4/0
</InkList6>
<StockSelectMenu6>Lambda Paper Matte -max width 48"
</StockSelectMenu6>
<BacklightList6>Select
</BacklightList6>
<CuttingMenu6>Select
</CuttingMenu6>
<WhiteList6>Select
</WhiteList6>
<LaminationList6>None
</LaminationList6>
<OtherFinishingList6>None
</OtherFinishingList6>
<ProofingList>PDF
</ProofingList>
<LifeExpectancyList>Short Term - less than 6 months
</LifeExpectancyList>
<ShippingList>Extra
</ShippingList>
<commentsArea/>
<IndorOutdoorList>Indoor
</IndorOutdoorList>
<PackagingList>No
</PackagingList>
<InstallationList>NO
</InstallationList>
<SiteInspectionList>NO
</SiteInspectionList>
</CustomerDetails>


thank You.
Posted

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900