xml数据导入sqlserver2005
<?xml version="1.0" standalone="yes"?><user>
<ExternalNum>0</ExternalNum>
<LoginName>admin</LoginName>
<LastName>admin</LastName>
<FirstName>admin</FirstName>
<Password>21232F297A57A5A743894A0E4A801FC3</Password>
<UserCategory>20012</UserCategory>
<CustomerID>30000001</CustomerID>
<Emailaddress>yaohai@its-cn.com</Emailaddress>
<FixedPhone_PreNum>10</FixedPhone_PreNum>
<FixedPhone_1>62668480P8003</FixedPhone_1>
<FixedPhone_2 />
<MobilePhone_1 />
<MobilePhone_2 />
<QQ />
<MSN />
<Birthday>1980-01-01T00:00:00+08:00</Birthday>
<ZIPCode />
<Division>120002</Division>
<Status>2</Status>
<LoginStatus>20010</LoginStatus>
<Visable>true</Visable>
<Sex>20025</Sex>
< AgreeMent>
<ImportID>1</ImportID>
< User_ExternalNum > HS-11080001 </ User_ExternalNum >
<AgrMntNum>00076348</AgrMntNum>
<AuthCode>000001</AuthCode>
<ExternalNum>AHW420009</ExternalNum>
<Status>20011</Status>
<SaleOrderNum>00450701</SaleOrderNum>
<SaleRegister>杜高明</SaleRegister>
<AgrMntBarCode>HS00076348</AgrMntBarCode>
<Partner>180036</Partner>
<Customer>30000001</Customer>
< AgreeMentItem>
<ImportID>2759</ImportID>
<Agreement_ExternalNum>40002759</Agreement_ExternalNum>
<AgrMntItemNum>1</AgrMntItemNum>
<ExternalNum>FJW500010</ExternalNum>
<TrnsctnPrice>279.2000</TrnsctnPrice>
<ClearPrice>105.0000</ClearPrice>
<Quantity>1</Quantity>
<InvoiceNum>00143446</InvoiceNum>
<Completed>2010-03-28T00:00:00+08:00</Completed>
<SaleOrderNum>276323</SaleOrderNum>
<SaleOrderItemNum>1</SaleOrderItemNum>
<ServiceProduct>130103</ServiceProduct>
<AvalibFrom>2011-03-28T00:00:00+08:00</AvalibFrom>
<AvalibTo>2012-03-27T00:00:00+08:00</AvalibTo>
<ExtendPeriod>1</ExtendPeriod>
<Avalib>true</Avalib>
< AgrMntItem_Ast>
< AgreeMentItem_ExternalNum> </ AgreeMentItem_ExternalNum>
<Asset_ExternalNum></Asset_ExternalNum>
<Avalib></Avalib>
<DESC></DESC>
< Asset>
< ImportID > </ ImportID >
< ExternalNum ></ ExternalNum >
< Name ></ Name >
< Status ></ Status >
< Caption></ Caption>
< ParentID_ExternalNum></ ParentID_ExternalNum>
< Customer></ Customer>
< User_ExternalNum></ User_ExternalNum>
< Division></ Division>
< Place></ Place>
< Prod></ Prod>
< Mounted></ Mounted>
< WarrantyPeriod></ WarrantyPeriod>
< ProductBrand></ ProductBrand>
< ProductCategory></ ProductCategory>
< ProdBrandName></ ProdBrandName>
< ProdCategory></ ProdCategory>
< ProdTradeName></ ProdTradeName>
< ProdModelNum></ ProdModelNum>
< ProdSeries></ ProdSeries>
< InvoiceNum></ InvoiceNum>
< TrnsctnPrice></ TrnsctnPrice>
< SerialNum></ SerialNum>
< AssetNum></ AssetNum>
< Completed></ Completed>
< Class></ Class>
< Avalib></ Avalib>
< Desc></ Desc>
</ Asset>
</ AgrMntItem_Ast>
</ AgreeMentItem>
< /AgreeMent>
</user>
首先大家看我定义的这个xml格式是否正确
将这个xml导入数据库中的五个表中user AgreeMent AgreeMentItem AgrMntItem_Ast Asset
这五个表是有主外键顺序的,
--------------------编程问答--------------------
没怎么看明白 --------------------编程问答-------------------- 就是一个xml包 ,导入到数据库的五个表中,这五个表之间是有主外键关系的。
各位给个思路,xml格式应该如何定义?
thank you very much --------------------编程问答-------------------- 帮顶了 --------------------编程问答-------------------- 这个问题很难吗?我也不太清楚是否可以实现啊!
之前是将数据以excel的格式导入数据库,现在又是以xml的格式导入。
补充:.NET技术 , ASP.NET