How Do I Use Xmldocument To Insert It Into Datatable

Question

0.00/5 (No votes)

See more:

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>

Posted 13-Feb-14 0:08am

hrishisinha

Updated 13-Feb-14 0:15am

v5

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Salman622 · Answer 1 · 2014-02-13T00:22:00

Solution 1

go through the below link may it will help

xml_To_datatable

Posted 13-Feb-14 0:22am

Salman622