I have a xml file. I want to display the nodes and childnodes in my datagrid, i used xmldatasource, but i can read a specific path only. The problem is i should not use dataset and xmldocument. Give me some suggestions
<?xml version="1.0" encoding="utf-8"?>
<newbookingrs>
<bookingid>187250</bookingid>
<bookingstatus>We have received your request. As you did not submit the required payment details, no booking will be held for you. If you would like to go ahead with this request, please [varHref]>click here to provide your payment details now. Otherwise, no further correspondence is required from you.</bookingstatus>
<checkindate>2007-10-25</checkindate>
<checkoutdate>2007-10-26</checkoutdate>
<currencycode></currencycode>
<bookingdetails>
<hotelname>STAMFORD GRAND GLENELG</hotelname>
<hoteladdress>London City in United kingdom</hoteladdress>
<cancellationpolicy>0-4 days prior to arrival = 1 nights accommodation</cancellationpolicy>
<arrivaltime>21</arrivaltime>
<roomtype id="27569" name="City View Room">
<roomconfig id="108128" name="Double" count="1">
<rate amountcharged="-1.00" ratepernight="-1.00" noofnights="1" />
<adultsandchildren email="mandatory@man.com" adults="2" children="0" totaladult="5" totalchildren="0" />
</roomconfig>
<roomconfig id="108127" name="single" count="1">
<rate amountcharged="-1.00" ratepernight="-1.00" noofnights="1" />
<adultsandchildren email="mandatory@man.com" adults="1" children="0" totaladult="5" totalchildren="0" />
</roomconfig>
<roomconfig id="108131" name="Triple - 2 x Double beds" count="1">
<rate amountcharged="-1.00" ratepernight="-1.00" noofnights="1" />
<adultsandchildren email="mandatory@man.com" adults="2" children="0" totaladult="5" totalchildren="0" />
</roomconfig>
<roomconfig id="1454519" name="Bonus Night Offer" count="">
<rate amountcharged="" ratepernight="" noofnights="" />
<adultsandchildren email="" adults="" children="" totaladult="0" totalchildren="0" />
</roomconfig>
</roomtype>
<extraservices>
<service id="0" desc="Meal" typeid="5860" type="BREAKFAST" number="2" numberofnight="1" ratepernight="0" amount="0" />
<service id="-1" desc="Other" typeid="12443" type="AIRPORT PICKUP" number="2" numberofnight="1" ratepernight="0" amount="0" />
</extraservices>
<transactiondetails>
<transactionmethod>MasterCard</transactionmethod>
<transactiondocnumber>5300000000000006</transactiondocnumber>
<categoryid>INT</categoryid>
<currencycode></currencycode>
<bookingdate>2007-05-22</bookingdate>
<grandtotal>-3.00</grandtotal>
<creditcard firstname="dsfa" lastname="asdf" expirydate="09-2009" />
</transactiondetails><hotelrequest value="" />
</bookingdetails>
</newbookingrs
This is the xmlresponse i am getting. Now i want to display a particular nodes and subnodes in my datalist or repeater. This is the overall output i am
getting, but for displaying in repeater i want a particular node only not all (ie) (roomtype,roomconfig,rate and aults)
expected output is
roomtype name="City View Room"
roomconfig name="Double" count="1"
rate amountcharged="-1.00" ratepernight="-1.00" noofnights="1"
adultsandchildren email="mandatory@man.com" adults="2" children="0" totaladult="5" totalchildren="0"
The output has to come like this ie
RoomType Room / Offer Number of rooms Length Of Stay Adults Children Rate/Room
CityViewRoom Double 1 1 1 0 -1
CityViewRoom single 1 1....
like that for all nodes,