Please refer below code
C#
DataSet newTable = new DataSet();
newTable.ReadXml(Server.MapPath("~/XMLFile1.xml"));
and you can check there is muliple DataTable in DataSet
XMLFile1.xml
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<ns1:OTA_AirLowFareSearchRS Version="2.001" xmlns="http://www.opentravel.org/OTA/2003/05" xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
<ns1:Success />
<ns1:PricedItineraries>
<ns1:PricedItinerary CompositeFlightNumber="S2" CountCompositeFlightNumber="1" FareType="Non-Refundable" InboundSegmentReference="1" MatrixFare="true" Mode="" OriginDestinationRPH="BLRMAAS246066620130321" OutboundSegmentReference="1" Priority="1" RecommendationRPH="1" Refundable="true" ReturnOnly="false" SequenceNumber="1.0" SupplierCode="1AWS">
<ns1:AirItinerary SupplierSystem="Amadeus">
<ns1:OriginDestinationOptions>
<ns1:OriginDestinationOption Duration="00:45:00" FlightID="BLRMAAS24606662013-03-21" FromCache="true" MajorityCarrier="S2" ReturnOnly="false" SupplierCode="1AWS" SupplierSystem="Amadeus" UniqueIdentifier="1.0">
<ns1:FlightSegment ArrivalDateTime="2013-03-21T07:40:00" CabinCode="Y" DeliveryMethod="Courier" DepartureDateTime="2013-03-21T06:55:00" Duration="00:45:00" FlightNumber="4606" LTD="1AWS" LineNumber="Y" NumberInParty="BLRMAA" RPH="1" ResBookDesigCode="G" TicketType="Physical" ValidConnectionInd="1AWS">
<ns1:DepartureAirport AirPortName="Bengaluru" CityName="Bangalore" LocationCode="BLR" />
<ns1:ArrivalAirport AirPortName="Chennai" CityName="Chennai" LocationCode="MAA" Terminal="D" />
<ns1:OperatingAirline Code="S2" />
<ns1:BookingClassAvail FareType="RP" ResBookDesigCode="G" ResBookDesigQuantity="9" Status="9" WebFareName="G2SAP30" />
<ns1:Equipment AirEquipType="739" />
<ns1:MarketingAirline Code="S2" MatrixCode="66" Name="JetKonnect" YTAirlineCode="77" />
<ns1:ValidatingCarrier Code="S2" />
<ns1:Comment Cancelled="" Delay="" Ontime="" Stars="" />
</ns1:FlightSegment>
<ns1:FormData>
<ns1:FBC Destination="MAA" FlightNumber="4606" LineNumber="Y" Origin="BLR" SeatToSell="9" WebFareName="G2SAP30" />
<ns1:FareDifference>
<ns1:TotalFare ADT="1" BaseFare="420-ADT 420" CHD="0" Cabin="Economy" HostName="railserver" INF="0" Rbd="RP - G - " Tax="TTL-2395">2819</ns1:TotalFare>
</ns1:FareDifference>
<ns1:TicketingInfo DeliveryMethod="Courier" TicketTimeLimit="2013-02-06" TicketType="Physical" />
<ns1:AgentMarkup>
<ns1:Airlines>
<ns1:Others>
<ns1:Code />
<ns1:GDS>1</ns1:GDS>
<ns1:WholeSalerFees>0</ns1:WholeSalerFees>
<ns1:CommissionType>C</ns1:CommissionType>
<ns1:ApplyOn>B</ns1:ApplyOn>
<ns1:Amount>0.0000</ns1:Amount>
</ns1:Others>
</ns1:Airlines>
</ns1:AgentMarkup>
</ns1:FormData>
<ns1:FormData />
</ns1:OriginDestinationOption>
</ns1:OriginDestinationOptions>
</ns1:AirItinerary>
<ns1:AirItineraryPricingInfo UniqueIdentifier="1.0">
<ns1:ItinTotalFare NegotiatedFare="No">
<ns1:BaseFare Amount="420" CurrencyCode="INR" />
<ns1:Taxes>
<ns1:Tax Amount="2395" CurrencyCode="INR" TaxCode="TTL" />
</ns1:Taxes>
<ns1:TotalFare Amount="2819" CurrencyCode="INR" />
<ns1:Fees>
<ns1:Fee Amount="0" />
<ns1:Fee Amount="0" FeeCode="YatraLCCSurcharge" />
</ns1:Fees>
<ns1:ServiceTax Amount="4" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0.01" />
<ns1:Markups>
<ns1:Markup Amount="0" CurrencyCode="INR" Description="0.0 wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C" />
</ns1:Markups>
</ns1:ItinTotalFare>
<ns1:PTC_FareBreakdowns>
<ns1:PTC_FareBreakdown>
<ns1:PassengerTypeQuantity Code="ADT" Quantity="1.0" />
<ns1:FareBasisCodes>
<ns1:FareBasisCode FareType="Non-Refundable" SegmentRPH="">XXXXX</ns1:FareBasisCode>
</ns1:FareBasisCodes>
<ns1:PassengerFare>
<ns1:BaseFare Amount="420" CurrencyCode="INR" />
<ns1:Taxes>
<ns1:Tax Amount="2395" CurrencyCode="INR" TaxCode="TTL" />
</ns1:Taxes>
<ns1:TotalFare Amount="2819" CurrencyCode="INR" />
<ns1:ServiceTax Amount="4" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0.01" />
<ns1:Markups>
<ns1:Markup Amount="0" CurrencyCode="INR" Description="0.0 wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C" />
</ns1:Markups>
</ns1:PassengerFare>
</ns1:PTC_FareBreakdown>
</ns1:PTC_FareBreakdowns>
<ns1:FareInfos>
<ns1:FareInfo>
<ns1:FareReference>G2SAP30</ns1:FareReference>
<ns1:FilingAirline Code="ZZ" />
<ns1:DepartureAirport LocationCode="BLR" />
<ns1:ArrivalAirport LocationCode="MAA" />
</ns1:FareInfo>
</ns1:FareInfos>
</ns1:AirItineraryPricingInfo>
<ns1:TicketingInfo DeliveryMethod="Courier" TicketTimeLimit="2013-02-06" TicketType="Physical" />
<ns1:Notes>PENALTY APPLIES</ns1:Notes>
<ns1:Notes>LAST TKT DTE06FEB13 - SEE ADV PURCHASE</ns1:Notes>
</ns1:PricedItinerary>
<ns1:PricedItinerary CompositeFlightNumber="S2" CountCompositeFlightNumber="1" FareType="Non-Refundable" InboundSegmentReference="2" Mode="" OriginDestinationRPH="BLRMAAS246316620130321" OutboundSegmentReference="2" Priority="1" RecommendationRPH="1" Refundable="true" ReturnOnly="false" SequenceNumber="1.0" SupplierCode="1AWS">
<ns1:AirItinerary SupplierSystem="Amadeus">
<ns1:OriginDestinationOptions>
<ns1:OriginDestinationOption Duration="00:45:00" FlightID="BLRMAAS24631662013-03-21" FromCache="true" MajorityCarrier="S2" ReturnOnly="false" SupplierCode="1AWS" SupplierSystem="Amadeus" UniqueIdentifier="1.0">
<ns1:FlightSegment ArrivalDateTime="2013-03-21T20:20:00" CabinCode="Y" DeliveryMethod="Courier" DepartureDateTime="2013-03-21T19:35:00" Duration="00:45:00" FlightNumber="4631" LTD="1AWS" LineNumber="Y" NumberInParty="BLRMAA" RPH="2" ResBookDesigCode="G" TicketType="Physical" ValidConnectionInd="1AWS">
<ns1:DepartureAirport AirPortName="Bengaluru" CityName="Bangalore" LocationCode="BLR" />
<ns1:ArrivalAirport AirPortName="Chennai" CityName="Chennai" LocationCode="MAA" Terminal="D" />
<ns1:OperatingAirline Code="S2" />
<ns1:BookingClassAvail FareType="RP" ResBookDesigCode="G" ResBookDesigQuantity="9" Status="9" WebFareName="G2SAP30" />
<ns1:Equipment AirEquipType="739" />
<ns1:MarketingAirline Code="S2" MatrixCode="66" Name="JetKonnect" YTAirlineCode="77" />
<ns1:ValidatingCarrier Code="S2" />
<ns1:Comment Cancelled="" Delay="" Ontime="" Stars="" />
</ns1:FlightSegment>
<ns1:FormData>
<ns1:FBC Destination="MAA" FlightNumber="4631" LineNumber="Y" Origin="BLR" SeatToSell="9" WebFareName="G2SAP30" />
<ns1:FareDifference>
<ns1:TotalFare ADT="1" BaseFare="420-ADT 420" CHD="0" Cabin="Economy" HostName="railserver" INF="0" Rbd="RP - G - " Tax="TTL-2395">2819</ns1:TotalFare>
</ns1:FareDifference>
<ns1:TicketingInfo DeliveryMethod="Courier" TicketTimeLimit="2013-02-06" TicketType="Physical" />
<ns1:AgentMarkup>
<ns1:Airlines>
<ns1:Others>
<ns1:Code />
<ns1:GDS>1</ns1:GDS>
<ns1:WholeSalerFees>0</ns1:WholeSalerFees>
<ns1:CommissionType>C</ns1:CommissionType>
<ns1:ApplyOn>B</ns1:ApplyOn>
<ns1:Amount>0.0000</ns1:Amount>
</ns1:Others>
</ns1:Airlines>
</ns1:AgentMarkup>
</ns1:FormData>
<ns1:FormData />
</ns1:OriginDestinationOption>
</ns1:OriginDestinationOptions>
</ns1:AirItinerary>
<ns1:AirItineraryPricingInfo UniqueIdentifier="1.0">
<ns1:ItinTotalFare NegotiatedFare="No">
<ns1:BaseFare Amount="420" CurrencyCode="INR" />
<ns1:Taxes>
<ns1:Tax Amount="2395" CurrencyCode="INR" TaxCode="TTL" />
</ns1:Taxes>
<ns1:TotalFare Amount="2819" CurrencyCode="INR" />
<ns1:Fees>
<ns1:Fee Amount="0" />
<ns1:Fee Amount="0" FeeCode="YatraLCCSurcharge" />
</ns1:Fees>
<ns1:ServiceTax Amount="4" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0.01" />
<ns1:Markups>
<ns1:Markup Amount="0" CurrencyCode="INR" Description="0.0 wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C" />
</ns1:Markups>
</ns1:ItinTotalFare>
<ns1:PTC_FareBreakdowns>
<ns1:PTC_FareBreakdown>
<ns1:PassengerTypeQuantity Code="ADT" Quantity="1.0" />
<ns1:FareBasisCodes>
<ns1:FareBasisCode FareType="Non-Refundable" SegmentRPH="">XXXXX</ns1:FareBasisCode>
</ns1:FareBasisCodes>
<ns1:PassengerFare>
<ns1:BaseFare Amount="420" CurrencyCode="INR" />
<ns1:Taxes>
<ns1:Tax Amount="2395" CurrencyCode="INR" TaxCode="TTL" />
</ns1:Taxes>
<ns1:TotalFare Amount="2819" CurrencyCode="INR" />
<ns1:ServiceTax Amount="4" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0.01" />
<ns1:Markups>
<ns1:Markup Amount="0" CurrencyCode="INR" Description="0.0 wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C" />
</ns1:Markups>
</ns1:PassengerFare>
</ns1:PTC_FareBreakdown>
</ns1:PTC_FareBreakdowns>
<ns1:FareInfos>
<ns1:FareInfo>
<ns1:FareReference>G2SAP30</ns1:FareReference>
<ns1:FilingAirline Code="ZZ" />
<ns1:DepartureAirport LocationCode="BLR" />
<ns1:ArrivalAirport LocationCode="MAA" />
</ns1:FareInfo>
</ns1:FareInfos>
</ns1:AirItineraryPricingInfo>
<ns1:TicketingInfo DeliveryMethod="Courier" TicketTimeLimit="2013-02-06" TicketType="Physical" />
<ns1:Notes>PENALTY APPLIES</ns1:Notes>
<ns1:Notes>LAST TKT DTE06FEB13 - SEE ADV PURCHASE</ns1:Notes>
</ns1:PricedItinerary>
</ns1:PricedItineraries>
</ns1:OTA_AirLowFareSearchRS>
</soapenv:Body>
</soapenv:Envelope>
Screenshot
