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 -- -- 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 dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@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 dotnetdevelopment+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
