如何使用Xmldocument将其插入数据表 | 如何使用Xmldocument将其插入数据表

本文介绍了如何使用Xmldocument将其插入数据表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我的xml文件是这样的，不要对文件lenth.i只有一个问题，我有两个同名的节点。

Plz将下面的代码复制到xml doc u can看到了。

现在我希望它插入数据表。但是不能正确。

< pre lang = xml>< s：Envelope xmlns：s =" http：//schemas.xmlsoap.org/soap/envelope/">

< s：Body>

< SearchResponse xmlns =" http：//stellatravelgateway.stellatravelservices.co.uk/AirService">

< SearchResult Success =" true"错误码=" 0" ErrorDescription中= QUOT;" ResultSetID = QUOT; ************ - 7f6c-49b7-83a2-54e10435b45f"的xmlns：的xsi = QUOT; HTTP：//www.w3.org/2001/XMLSchema-instance" xmlns：xsd =" http：//www.w3.org/2001/XMLSchema">

<结果>

<结果>

< AirResult ResultItemID =" 0"操作者= QUOT; BA"从= QUOT; LGW"为了= QUOT; BCN" FromName =" London Gatwick，London，Great Britain" ToName =" Barcelona，Barcelona，Spain" AirlineClass = QUOT; O" OperatorName =" British Airways" CabinClass = QUOT;经济" HasAvailability = QUOT;真" FareType = QUOT;公开" MinStayCode = QUOT;" MaxStayCode = QUOT;" MinStayDescription = QUOT;" MaxStayDescription = QUOT;" AdultGross = QUOT; 58.50" AdultTax = QUOT; 78.57" AdultTotal = QUOT; 137.07" AdultCommission = QUOT; 0.00" ChildGross = QUOT; 58.50" ChildTax = QUOT; 78.57" ChildTotal = QUOT; 137.07" ChildCommission = QUOT; 0.00" InfantGross = QUOT; 10.00" InfantTax = QUOT; 37.57" InfantTotal = QUOT; 47.57" InfantCommission = QUOT; 0.00" TotalGross = QUOT; 127.00" TotalCommission = QUOT; 0.00" TotalTax = QUOT; 194.71" AdultPaxCount = QUOT 1 QUOT; ChildPaxCount = QUOT 1 QUOT; InfantPaxCount =" 1">

<条件/>

< ValidFrom xsi：nil =" true" />

< ValidTo xsi：nil =" true" />

< TicketingDeadline> 2014-02-13T07：09：28.6230307 + 00:00< / TicketingDeadline>

< Journeys>

< Journey>

< Journey JourneyItemID =" 0">

< Options>

< Option>

< Option OptionItemID =" 0">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 319"到达= QUOT; 2014-09-01T10：40：00" ArrivalTerminal = QUOT 1 QUOT; CabinClass = QUOT;经济"出发= QUOT; 2014-09-01T07：40：00" DepartureTerminal = QUOT; N" FlightNo = QUOT; 2706"从= QUOT; LGW" FromCity = QUOT;伦敦" FromCountry =" Great Britain" FromName =" London Gatwick"为了= QUOT; BCN" ToCity = QUOT;巴塞罗那" ToCountry = QUOT;西班牙" ToName = QUOT;巴塞罗那" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 120< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 2< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 1">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 734"到达= QUOT; 2014-09-01T21：55：00" ArrivalTerminal = QUOT 1 QUOT; CabinClass = QUOT;经济"出发= QUOT; 2014-09-01T18：50：00" DepartureTerminal = QUOT; N" FlightNo = QUOT; 2710"从= QUOT; LGW" FromCity = QUOT;伦敦" FromCountry =" Great Britain" FromName =" London Gatwick"为了= QUOT; BCN" ToCity = QUOT;巴塞罗那" ToCountry = QUOT;西班牙" ToName = QUOT;巴塞罗那" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 125< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 7< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< / Option>

< / Options>

< StopOverCostPerPerson xsi：nil =" true" />

< / Journey>

< Journey JourneyItemID =" 1" >

<期权>

<期权>

<期权OptionItemID =" 0">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 319"到达= QUOT; 2014-09-08T22：30：00" ArrivalTerminal = QUOT; 5英寸CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T21：20：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 471"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LHR" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Heathrow" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 130< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 9< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 1">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 320"到达= QUOT; 2014-09-08T21：45：00" ArrivalTerminal = QUOT; 5英寸CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T20：35：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 487"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LHR" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Heathrow" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 130< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 9< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 2">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 320"到达= QUOT; 2014-09-08T20：35：00" ArrivalTerminal = QUOT; 5英寸CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T19：20：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 481"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LHR" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Heathrow" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 135< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 7< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 3">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 321"到达= QUOT; 2014-09-08T13：05：00" ArrivalTerminal = QUOT; 5英寸CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T11：45：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 479"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LHR" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Heathrow" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 140< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 4< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 4">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 321"到达= QUOT; 2014-09-08T17：30：00" ArrivalTerminal = QUOT; 5英寸CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T16：10：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 475"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LHR" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Heathrow" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 140< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 7< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< / Option>

< / Options>

< StopOverCostPerPerson xsi：nil =" true" />

< / Journey>

< / Journey>

< / Journeys>

< PassengerPricingBreakdowns>

< PassengerPricingBreakdown Description =" ADT"委员会= QUOT; 0.000000"总值= QUOT; 51.000000"税= QUOT; 78.57" TaxBreakdown =" 13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ"总计=" 129.570000">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" CHD"委员会= QUOT; 0.000000"总值= QUOT; 51.000000"税= QUOT; 78.57" TaxBreakdown =" 13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ"总计=" 129.570000">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" INF"委员会= QUOT; 0.000000"总值= QUOT; 10.000000"税= QUOT; 37.57" TaxBreakdown =" 12.27UB 12.70JD 0.50OG 3.10QV 9.00YQ"总计=" 47.570000">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" SAFI"委员会= QUOT; 0.00"总值= QUOT; 5.00"税= QUOT; 0"总计=" 5.00">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" BA SECTOR FEE"委员会= QUOT; 0"总值= QUOT; 0"税= QUOT; 0"总计=" 0"

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" ATOL FEE PUB"委员会= QUOT; 0.00"总值= QUOT; 2.50"税= QUOT; 0"总计=" 2.50>>

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< / PassengerPricingBreakdowns>

< CommissionIsPercentage> true< / CommissionIsPercentage>

< CommissionRate> 0< / CommissionRate>

< / AirResult>

< AirResult ResultItemID =" 1"操作者= QUOT; BA"从= QUOT; LGW"为了= QUOT; BCN" FromName =" London Gatwick，London，Great Britain" ToName =" Barcelona，Barcelona，Spain" AirlineClass = QUOT; O" OperatorName =" British Airways" CabinClass = QUOT;经济" HasAvailability = QUOT;真" FareType = QUOT;公开" MinStayCode = QUOT;" MaxStayCode = QUOT;" MinStayDescription = QUOT;" MaxStayDescription = QUOT;" AdultGross = QUOT; 61.50" AdultTax = QUOT; 78.57" AdultTotal = QUOT; 140.07" AdultCommission = QUOT; 0.00" ChildGross = QUOT; 61.50" ChildTax = QUOT; 78.57" ChildTotal = QUOT; 140.07" ChildCommission = QUOT; 0.00" InfantGross = QUOT; 10.00" InfantTax = QUOT; 37.57" InfantTotal = QUOT; 47.57" InfantCommission = QUOT; 0.00" TotalGross = QUOT; 133.00" TotalCommission = QUOT; 0.00" TotalTax = QUOT; 194.71" AdultPaxCount = QUOT 1 QUOT; ChildPaxCount = QUOT 1 QUOT; InfantPaxCount =" 1">

<条件/>

< ValidFrom xsi：nil =" true" />

< ValidTo xsi：nil =" true" />

< TicketingDeadline> 2014-02-13T07：09：28.7167819 + 00:00< / TicketingDeadline>

< Journeys>

< Journey>

< Journey JourneyItemID =" 0">

< Options>

< Option>

< Option OptionItemID =" 0">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 319"到达= QUOT; 2014-09-01T10：40：00" ArrivalTerminal = QUOT 1 QUOT; CabinClass = QUOT;经济"出发= QUOT; 2014-09-01T07：40：00" DepartureTerminal = QUOT; N" FlightNo = QUOT; 2706"从= QUOT; LGW" FromCity = QUOT;伦敦" FromCountry =" Great Britain" FromName =" London Gatwick"为了= QUOT; BCN" ToCity = QUOT;巴塞罗那" ToCountry = QUOT;西班牙" ToName = QUOT;巴塞罗那" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 120< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 2< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 1">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 734"到达= QUOT; 2014-09-01T21：55：00" ArrivalTerminal = QUOT 1 QUOT; CabinClass = QUOT;经济"出发= QUOT; 2014-09-01T18：50：00" DepartureTerminal = QUOT; N" FlightNo = QUOT; 2710"从= QUOT; LGW" FromCity = QUOT;伦敦" FromCountry =" Great Britain" FromName =" London Gatwick"为了= QUOT; BCN" ToCity = QUOT;巴塞罗那" ToCountry = QUOT;西班牙" ToName = QUOT;巴塞罗那" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 125< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 7< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< / Option>

< / Options>

< StopOverCostPerPerson xsi：nil =" true" />

< / Journey>

< Journey JourneyItemID =" 1" >

<期权>

<期权>

<期权OptionItemID =" 0">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 734"到达= QUOT; 2014-09-08T16：35：00" ArrivalTerminal = QUOT; N" CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T15：25：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 2709"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LGW" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Gatwick" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 130< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 9< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 1">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 734"到达= QUOT; 2014-09-08T23：50：00" ArrivalTerminal = QUOT; N" CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T22：40：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 2711"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LGW" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Gatwick" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 130< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 9< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< Option OptionItemID =" 2">

< Legs>

< Leg>

< Leg Airline =" BA" AirlineClass = QUOT; O"航空公司名称=英国航空公司飞机= QUOT; 319"到达= QUOT; 2014-09-08T12：40：00" ArrivalTerminal = QUOT; N" CabinClass = QUOT;经济"出发= QUOT; 2014-09-08T11：25：00" DepartureTerminal = QUOT 1 QUOT; FlightNo = QUOT; 2707"从= QUOT; BCN" FromCity = QUOT;巴塞罗那" FromCountry = QUOT;西班牙" FROMNAME = QUOT;巴塞罗那"为了= QUOT; LGW" ToCity = QUOT;伦敦" ToCountry =Great Britain ToName =" London Gatwick" CodeShareInformation = QUOT;" IsCodeShare =" false">

< Touchdown>

< Touchdown />

< / Touchdowns>

< FlightTimeMinutes> 135< / FlightTimeMinutes>

< Miles xsi：nil =" true" />

< AvailableSeats> 9< / AvailableSeats>

< / Leg>

< / Leg>

< / Legs>

< / Option>

< / Option>

< / Options>

< StopOverCostPerPerson xsi：nil =" true" />

< / Journey>

< / Journey>

< / Journeys>

< PassengerPricingBreakdowns>

< PassengerPricingBreakdown Description =" ADT"委员会= QUOT; 0.000000"总值= QUOT; 54.000000"税= QUOT; 78.57" TaxBreakdown =" 13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ"总计=" 132.570000">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" CHD"委员会= QUOT; 0.000000"总值= QUOT; 54.000000"税= QUOT; 78.57" TaxBreakdown =" 13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ"总计=" 132.570000">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" INF"委员会= QUOT; 0.000000"总值= QUOT; 10.000000"税= QUOT; 37.57" TaxBreakdown =" 12.27UB 12.70JD 0.50OG 3.10QV 9.00YQ"总计=" 47.570000">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" SAFI"委员会= QUOT; 0.00"总值= QUOT; 5.00"税= QUOT; 0"总计=" 5.00">

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" BA SECTOR FEE"委员会= QUOT; 0"总值= QUOT; 0"税= QUOT; 0"总计=" 0"

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< PassengerPricingBreakdown Description =" ATOL FEE PUB"委员会= QUOT; 0.00"总值= QUOT; 2.50"税= QUOT; 0"总计=" 2.50>>

< CommissionFlatRate xsi：nil =" true" xmlns =" Air" />

< CommissionPercentage xmlns =" Air"> 0< / CommissionPercentage>

< / PassengerPricingBreakdown>

< / PassengerPricingBreakdowns>

< CommissionIsPercentage> true< / CommissionIsPercentage>

< CommissionRate> 0< / CommissionRate>

< / AirResult>

< /结果>

< /结果>

< SearchSource>默认< / SearchSource>

< / SearchResult>

< / SearchResponse>

< / s：Body>

< / s：信封>

< / pre>

解决方案

My xml file is like this,Dont wry about the document lenth.i have just one issue that i have two node with the same name.
Plz copy the below code into xml doc u can see that.
Now i want it to insert into a data table.But cant get it right.

<pre lang="xml"><s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body>
<SearchResponse xmlns="http://stellatravelgateway.stellatravelservices.co.uk/AirService">
<SearchResult Success="true" ErrorCode="0" ErrorDescription="" ResultSetID="************-7f6c-49b7-83a2-54e10435b45f" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Results>
<Result>
<AirResult ResultItemID="0" Operator="BA" From="LGW" To="BCN" FromName="London Gatwick, London, Great Britain" ToName="Barcelona, Barcelona, Spain" AirlineClass="O" OperatorName="British Airways" CabinClass="Economy" HasAvailability="true" FareType="Published" MinStayCode="" MaxStayCode="" MinStayDescription="" MaxStayDescription="" AdultGross="58.50" AdultTax="78.57" AdultTotal="137.07" AdultCommission="0.00" ChildGross="58.50" ChildTax="78.57" ChildTotal="137.07" ChildCommission="0.00" InfantGross="10.00" InfantTax="37.57" InfantTotal="47.57" InfantCommission="0.00" TotalGross="127.00" TotalCommission="0.00" TotalTax="194.71" AdultPaxCount="1" ChildPaxCount="1" InfantPaxCount="1">
<Conditions/>
<ValidFrom xsi:nil="true"/>
<ValidTo xsi:nil="true"/>
<TicketingDeadline>2014-02-13T07:09:28.6230307+00:00</TicketingDeadline>
<Journeys>
<Journey>
<Journey JourneyItemID="0">
<Options>
<Option>
<Option OptionItemID="0">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="319" Arrival="2014-09-01T10:40:00" ArrivalTerminal="1" CabinClass="Economy" Departure="2014-09-01T07:40:00" DepartureTerminal="N" FlightNo="2706" From="LGW" FromCity="London" FromCountry="Great Britain" FromName="London Gatwick" To="BCN" ToCity="Barcelona" ToCountry="Spain" ToName="Barcelona" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>120</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>2</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="1">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="734" Arrival="2014-09-01T21:55:00" ArrivalTerminal="1" CabinClass="Economy" Departure="2014-09-01T18:50:00" DepartureTerminal="N" FlightNo="2710" From="LGW" FromCity="London" FromCountry="Great Britain" FromName="London Gatwick" To="BCN" ToCity="Barcelona" ToCountry="Spain" ToName="Barcelona" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>125</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>7</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
</Option>
</Options>
<StopOverCostPerPerson xsi:nil="true"/>
</Journey>
<Journey JourneyItemID="1">
<Options>
<Option>
<Option OptionItemID="0">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="319" Arrival="2014-09-08T22:30:00" ArrivalTerminal="5" CabinClass="Economy" Departure="2014-09-08T21:20:00" DepartureTerminal="1" FlightNo="471" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LHR" ToCity="London" ToCountry="Great Britain" ToName="London Heathrow" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>130</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>9</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="1">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="320" Arrival="2014-09-08T21:45:00" ArrivalTerminal="5" CabinClass="Economy" Departure="2014-09-08T20:35:00" DepartureTerminal="1" FlightNo="487" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LHR" ToCity="London" ToCountry="Great Britain" ToName="London Heathrow" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>130</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>9</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="2">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="320" Arrival="2014-09-08T20:35:00" ArrivalTerminal="5" CabinClass="Economy" Departure="2014-09-08T19:20:00" DepartureTerminal="1" FlightNo="481" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LHR" ToCity="London" ToCountry="Great Britain" ToName="London Heathrow" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>135</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>7</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="3">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="321" Arrival="2014-09-08T13:05:00" ArrivalTerminal="5" CabinClass="Economy" Departure="2014-09-08T11:45:00" DepartureTerminal="1" FlightNo="479" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LHR" ToCity="London" ToCountry="Great Britain" ToName="London Heathrow" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>140</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>4</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="4">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="321" Arrival="2014-09-08T17:30:00" ArrivalTerminal="5" CabinClass="Economy" Departure="2014-09-08T16:10:00" DepartureTerminal="1" FlightNo="475" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LHR" ToCity="London" ToCountry="Great Britain" ToName="London Heathrow" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>140</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>7</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
</Option>
</Options>
<StopOverCostPerPerson xsi:nil="true"/>
</Journey>
</Journey>
</Journeys>
<PassengerPricingBreakdowns>
<PassengerPricingBreakdown Description="ADT" Commission="0.000000" Gross="51.000000" Tax="78.57" TaxBreakdown="13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ" Total="129.570000">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="CHD" Commission="0.000000" Gross="51.000000" Tax="78.57" TaxBreakdown="13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ" Total="129.570000">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="INF" Commission="0.000000" Gross="10.000000" Tax="37.57" TaxBreakdown="12.27UB 12.70JD 0.50OG 3.10QV 9.00YQ" Total="47.570000">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="SAFI" Commission="0.00" Gross="5.00" Tax="0" Total="5.00">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="BA SECTOR FEE" Commission="0" Gross="0" Tax="0" Total="0">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="ATOL FEE PUB" Commission="0.00" Gross="2.50" Tax="0" Total="2.50">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
</PassengerPricingBreakdowns>
<CommissionIsPercentage>true</CommissionIsPercentage>
<CommissionRate>0</CommissionRate>
</AirResult>
<AirResult ResultItemID="1" Operator="BA" From="LGW" To="BCN" FromName="London Gatwick, London, Great Britain" ToName="Barcelona, Barcelona, Spain" AirlineClass="O" OperatorName="British Airways" CabinClass="Economy" HasAvailability="true" FareType="Published" MinStayCode="" MaxStayCode="" MinStayDescription="" MaxStayDescription="" AdultGross="61.50" AdultTax="78.57" AdultTotal="140.07" AdultCommission="0.00" ChildGross="61.50" ChildTax="78.57" ChildTotal="140.07" ChildCommission="0.00" InfantGross="10.00" InfantTax="37.57" InfantTotal="47.57" InfantCommission="0.00" TotalGross="133.00" TotalCommission="0.00" TotalTax="194.71" AdultPaxCount="1" ChildPaxCount="1" InfantPaxCount="1">
<Conditions/>
<ValidFrom xsi:nil="true"/>
<ValidTo xsi:nil="true"/>
<TicketingDeadline>2014-02-13T07:09:28.7167819+00:00</TicketingDeadline>
<Journeys>
<Journey>
<Journey JourneyItemID="0">
<Options>
<Option>
<Option OptionItemID="0">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="319" Arrival="2014-09-01T10:40:00" ArrivalTerminal="1" CabinClass="Economy" Departure="2014-09-01T07:40:00" DepartureTerminal="N" FlightNo="2706" From="LGW" FromCity="London" FromCountry="Great Britain" FromName="London Gatwick" To="BCN" ToCity="Barcelona" ToCountry="Spain" ToName="Barcelona" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>120</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>2</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="1">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="734" Arrival="2014-09-01T21:55:00" ArrivalTerminal="1" CabinClass="Economy" Departure="2014-09-01T18:50:00" DepartureTerminal="N" FlightNo="2710" From="LGW" FromCity="London" FromCountry="Great Britain" FromName="London Gatwick" To="BCN" ToCity="Barcelona" ToCountry="Spain" ToName="Barcelona" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>125</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>7</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
</Option>
</Options>
<StopOverCostPerPerson xsi:nil="true"/>
</Journey>
<Journey JourneyItemID="1">
<Options>
<Option>
<Option OptionItemID="0">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="734" Arrival="2014-09-08T16:35:00" ArrivalTerminal="N" CabinClass="Economy" Departure="2014-09-08T15:25:00" DepartureTerminal="1" FlightNo="2709" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LGW" ToCity="London" ToCountry="Great Britain" ToName="London Gatwick" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>130</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>9</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="1">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="734" Arrival="2014-09-08T23:50:00" ArrivalTerminal="N" CabinClass="Economy" Departure="2014-09-08T22:40:00" DepartureTerminal="1" FlightNo="2711" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LGW" ToCity="London" ToCountry="Great Britain" ToName="London Gatwick" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>130</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>9</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
<Option OptionItemID="2">
<Legs>
<Leg>
<Leg Airline="BA" AirlineClass="O" AirlineName="British Airways" Airplane="319" Arrival="2014-09-08T12:40:00" ArrivalTerminal="N" CabinClass="Economy" Departure="2014-09-08T11:25:00" DepartureTerminal="1" FlightNo="2707" From="BCN" FromCity="Barcelona" FromCountry="Spain" FromName="Barcelona" To="LGW" ToCity="London" ToCountry="Great Britain" ToName="London Gatwick" CodeShareInformation="" IsCodeShare="false">
<Touchdowns>
<Touchdown/>
</Touchdowns>
<FlightTimeMinutes>135</FlightTimeMinutes>
<Miles xsi:nil="true"/>
<AvailableSeats>9</AvailableSeats>
</Leg>
</Leg>
</Legs>
</Option>
</Option>
</Options>
<StopOverCostPerPerson xsi:nil="true"/>
</Journey>
</Journey>
</Journeys>
<PassengerPricingBreakdowns>
<PassengerPricingBreakdown Description="ADT" Commission="0.000000" Gross="54.000000" Tax="78.57" TaxBreakdown="13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ" Total="132.570000">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="CHD" Commission="0.000000" Gross="54.000000" Tax="78.57" TaxBreakdown="13.00GB 12.27UB 12.70JD 0.50OG 3.10QV 37.00YQ" Total="132.570000">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="INF" Commission="0.000000" Gross="10.000000" Tax="37.57" TaxBreakdown="12.27UB 12.70JD 0.50OG 3.10QV 9.00YQ" Total="47.570000">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="SAFI" Commission="0.00" Gross="5.00" Tax="0" Total="5.00">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="BA SECTOR FEE" Commission="0" Gross="0" Tax="0" Total="0">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
<PassengerPricingBreakdown Description="ATOL FEE PUB" Commission="0.00" Gross="2.50" Tax="0" Total="2.50">
<CommissionFlatRate xsi:nil="true" xmlns="Air"/>
<CommissionPercentage xmlns="Air">0</CommissionPercentage>
</PassengerPricingBreakdown>
</PassengerPricingBreakdowns>
<CommissionIsPercentage>true</CommissionIsPercentage>
<CommissionRate>0</CommissionRate>
</AirResult>

</Result>
</Results>
<SearchSource>Default</SearchSource>
</SearchResult>
</SearchResponse>
</s:Body>
</s:Envelope>
</pre>

解决方案

这篇关于如何使用Xmldocument将其插入数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！