将XML文件数据插入sql [英] insert XML file data into sql

问题描述

我有一个从html(submission)表单生成的XML文件.我只为我的项目使用html页面.现在有什么方法可以将这些XML文件数据存储到sql中吗?

我需要为此使用asp页面吗?还是有什么办法可以通过html编码将所有数据推送到sql中?

我的XML文件在这里.

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.

<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.

推荐答案

http://msdn.microsoft.com/en-us/library/ms189887.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/aa276847(SQL .80).aspx [ ^ ]
http://www.daniweb.com/software-development/csharp/threads/255946/store-xml-file-in-sql-database [

http://msdn.microsoft.com/en-us/library/ms189887.aspx[^]
http://msdn.microsoft.com/en-us/library/aa276847(SQL.80).aspx[^]
http://www.daniweb.com/software-development/csharp/threads/255946/store-xml-file-in-sql-data-base[^]

这篇关于将XML文件数据插入sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！