convert XML string into Data table

[crazy]

Dear All,

I am getting below string as XML response from a third party system. How can I convert below XML string into Data table?  I need to insert the values into datatable.Please suggest some ideas.

string sXml=<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<AvailabilityResponse xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns=\"http://SunHotels.Services.External.SunHotelsIntegrationService.PostGet\">\r\n  <StatusCode>0</StatusCode>\r\n  <RoomTypeAvailabilities>\r\n    <RoomTypeAvailability>\r\n      <Date>2014-02-13T00:00:00</Date>\r\n      <RoomId>416240</RoomId>\r\n      <Rate>129.0000</Rate>\r\n      <Currency>USD</Currency>\r\n      <AvailableUnits>0</AvailableUnits>\r\n      <ReleaseDays>0</ReleaseDays>\r\n      <MinimumStay>1</MinimumStay>\r\n      <Beds>2</Beds>\r\n      <ExtraBeds>1</ExtraBeds>\r\n      <IncludedBoard>Half Board</IncludedBoard>\r\n      <AdultBreakfastPrice>0.0000</AdultBreakfastPrice>\r\n      <ChildBreakfastPrice>0.0000</ChildBreakfastPrice>\r\n      <AdultHalfBoardPrice>0.0000</AdultHalfBoardPrice>\r\n      <ChildHalfBoardPrice>0.0000</ChildHalfBoardPrice>\r\n      <AdultFullBoardPrice>0.0000</AdultFullBoardPrice>\r\n      <ChildFullBoardPrice>0.0000</ChildFullBoardPrice>\r\n      <AdultAllBoardsPrice>0.0000</AdultAllBoardsPrice>\r\n      <ChildAllBoardsPrice>0.0000</ChildAllBoardsPrice>\r\n      <AdultExtrabedPrice xsi:nil=\"true\" />\r\n      <ChildExtrabedPrice>37.00</ChildExtrabedPrice>\r\n    </RoomTypeAvailability>\r\n    <RoomTypeAvailability>\r\n      <Date>2014-02-14T00:00:00</Date>\r\n      <RoomId>416240</RoomId>\r\n      <Rate>129.0000</Rate>\r\n      <Currency>USD</Currency>\r\n      <AvailableUnits>0</AvailableUnits>\r\n      <ReleaseDays>0</ReleaseDays>\r\n      <MinimumStay>1</MinimumStay>\r\n      <Beds>2</Beds>\r\n      <ExtraBeds>1</ExtraBeds>\r\n      <IncludedBoard>Half Board</IncludedBoard>\r\n      <AdultBreakfastPrice>0.0000</AdultBreakfastPrice>\r\n      <ChildBreakfastPrice>0.0000</ChildBreakfastPrice>\r\n      <AdultHalfBoardPrice>0.0000</AdultHalfBoardPrice>\r\n      <ChildHalfBoardPrice>0.0000</ChildHalfBoardPrice>\r\n      <AdultFullBoardPrice>0.0000</AdultFullBoardPrice>\r\n      <ChildFullBoardPrice>0.0000</ChildFullBoardPrice>\r\n      <AdultAllBoardsPrice>0.0000</AdultAllBoardsPrice>\r\n      <ChildAllBoardsPrice>0.0000</ChildAllBoardsPrice>\r\n      <AdultExtrabedPrice xsi:nil=\"true\" />\r\n      <ChildExtrabedPrice>37.00</ChildExtrabedPrice>\r\n    </RoomTypeAvailability>\r\n    <RoomTypeAvailability>\r\n      <Date>2014-02-15T00:00:00</Date>\r\n      <RoomId>416240</RoomId>\r\n      <Rate>129.0000</Rate>\r\n      <Currency>USD</Currency>\r\n      <AvailableUnits>0</AvailableUnits>\r\n      <ReleaseDays>0</ReleaseDays>\r\n      <MinimumStay>1</MinimumStay>\r\n      <Beds>2</Beds>\r\n      <ExtraBeds>1</ExtraBeds>\r\n      <IncludedBoard>Half Board</IncludedBoard>\r\n      <AdultBreakfastPrice>0.0000</AdultBreakfastPrice>\r\n      <ChildBreakfastPrice>0.0000</ChildBreakfastPrice>\r\n      <AdultHalfBoardPrice>0.0000</AdultHalfBoardPrice>\r\n      <ChildHalfBoardPrice>0.0000</ChildHalfBoardPrice>\r\n      <AdultFullBoardPrice>0.0000</AdultFullBoardPrice>\r\n      <ChildFullBoardPrice>0.0000</ChildFullBoardPrice>\r\n      <AdultAllBoardsPrice>0.0000</AdultAllBoardsPrice>\r\n      <ChildAllBoardsPrice>0.0000</ChildAllBoardsPrice>\r\n      <AdultExtrabedPrice xsi:nil=\"true\" />\r\n      <ChildExtrabedPrice>37.00</ChildExtrabedPrice>\r\n    </RoomTypeAvailability>\r\n    <RoomTypeAvailability>\r\n      <Date>2014-02-16T00:00:00</Date>\r\n      <RoomId>416240</RoomId>\r\n      <Rate>129.0000</Rate>\r\n      <Currency>USD</Currency>\r\n      <AvailableUnits>0</AvailableUnits>\r\n      <ReleaseDays>0</ReleaseDays>\r\n      <MinimumStay>1</MinimumStay>\r\n      <Beds>2</Beds>\r\n      <ExtraBeds>1</ExtraBeds>\r\n      <IncludedBoard>Half Board</IncludedBoard>\r\n      <AdultBreakfastPrice>0.0000</AdultBreakfastPrice>\r\n      <ChildBreakfastPrice>0.0000</ChildBreakfastPrice>\r\n      <AdultHalfBoardPrice>0.0000</AdultHalfBoardPrice>\r\n      <ChildHalfBoardPrice>0.0000</ChildHalfBoardPrice>\r\n      <AdultFullBoardPrice>0.0000</AdultFullBoardPrice>\r\n      <ChildFullBoardPrice>0.0000</ChildFullBoardPrice>\r\n      <AdultAllBoardsPrice>0.0000</AdultAllBoardsPrice>\r\n      <ChildAllBoardsPrice>0.0000</ChildAllBoardsPrice>\r\n      <AdultExtrabedPrice xsi:nil=\"true\" />\r\n      <ChildExtrabedPrice>37.00</ChildExtrabedPrice>\r\n    </RoomTypeAvailability>\r\n    <RoomTypeAvailability>\r\n      <Date>2014-02-17T00:00:00</Date>\r\n      <RoomId>416240</RoomId>\r\n      <Rate>129.0000</Rate>\r\n      <Currency>USD</Currency>\r\n      <AvailableUnits>0</AvailableUnits>\r\n      <ReleaseDays>0</ReleaseDays>\r\n      <MinimumStay>1</MinimumStay>\r\n      <Beds>2</Beds>\r\n      <ExtraBeds>1</ExtraBeds>\r\n      <IncludedBoard>Half Board</IncludedBoard>\r\n      <AdultBreakfastPrice>0.0000</AdultBreakfastPrice>\r\n      <ChildBreakfastPrice>0.0000</ChildBreakfastPrice>\r\n      <AdultHalfBoardPrice>0.0000</AdultHalfBoardPrice>\r\n      <ChildHalfBoardPrice>0.0000</ChildHalfBoardPrice>\r\n      <AdultFullBoardPrice>0.0000</AdultFullBoardPrice>\r\n      <ChildFullBoardPrice>0.0000</ChildFullBoardPrice>\r\n      <AdultAllBoardsPrice>0.0000</AdultAllBoardsPrice>\r\n      <ChildAllBoardsPrice>0.0000</ChildAllBoardsPrice>\r\n      <AdultExtrabedPrice xsi:nil=\"true\" />\r\n      <ChildExtrabedPrice>37.00</ChildExtrabedPrice>\r\n    </RoomTypeAvailability>\r\n  </RoomTypeAvailabilities>\r\n</AvailabilityResponse> "

--
"People who never make mistakes, never do anything."

dEv

[Stephen Russell]

Start here:

<http://www.lmgtfy.com/?q=c%23+read+xml+from+string>

--
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to dotnetde...@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopm...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
 
---
You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotnetdevelopm...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell