XML Linq Help

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<div style="color:Black;background-color:White; <pre>
I have the following XML document to Parse.
[/code]
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; span <span style="color:Red; style<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; white-space:normal<span style="color:Black; "<span style="color:Blue; ><span style="color:Blue; <<span style="color:#A31515; pre <span style="color:Red; lang<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; x-xml<span style="color:Black; "<span style="color:Blue; ><span style="color:Blue; <?<span style="color:#A31515; xml <span style="color:Red; version<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; 1.0<span style="color:Black; " <span style="color:Red; encoding<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; UTF-8<span style="color:Black; "<span style="color:Blue; ?>
<span style="color:Blue; <<span style="color:#A31515; soap-env<span style="color:Blue; :<span style="color:#A31515; Envelope <span style="color:Red; xmlns:soap-env<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; http://schemas.xmlsoap.org/soap/envelope/<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; soap-env<span style="color:Blue; :<span style="color:#A31515; Body<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-history-reply<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; request-event<span style="color:Blue; >LP229<span style="color:Blue; </<span style="color:#A31515; request-event<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; pos-transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-transaction-id<span style="color:Blue; >10659596<span style="color:Blue; </<span style="color:#A31515; px-transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; datetime<span style="color:Blue; >2011-12-02T14:42:53.968<span style="color:Blue; </<span style="color:#A31515; datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender-id<span style="color:Blue; >PXS<span style="color:Blue; </<span style="color:#A31515; sender-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; customer-name <span style="color:Blue; />
<span style="color:Blue; <<span style="color:#A31515; tier-name<span style="color:Blue; >DMC - Holiday 2011 Init (25)<span style="color:Blue; </<span style="color:#A31515; tier-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-auth-code<span style="color:Blue; >130694<span style="color:Blue; </<span style="color:#A31515; px-auth-code<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; response-code<span style="color:Blue; >200<span style="color:Blue; </<span style="color:#A31515; response-code<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; response-message<span style="color:Blue; >Query succeeded<span style="color:Blue; </<span style="color:#A31515; response-message<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; printed-card-number<span style="color:Blue; >6000101000477524<span style="color:Blue; </<span style="color:#A31515; printed-card-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; masked-card-number<span style="color:Blue; >477524<span style="color:Blue; </<span style="color:#A31515; masked-card-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; balance-point<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; point-type<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; point-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; point-name<span style="color:Blue; >Visits<span style="color:Blue; </<span style="color:#A31515; point-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; points<span style="color:Blue; >0<span style="color:Blue; </<span style="color:#A31515; points<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; balance-point<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; balance-point<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; point-type<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; point-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; point-name<span style="color:Blue; >Direct Mail Offers<span style="color:Blue; </<span style="color:#A31515; point-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; points<span style="color:Blue; >2<span style="color:Blue; </<span style="color:#A31515; points<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; balance-point<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; trailer-width<span style="color:Blue; >0<span style="color:Blue; </<span style="color:#A31515; trailer-width<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; trailer-line-count<span style="color:Blue; >0<span style="color:Blue; </<span style="color:#A31515; trailer-line-count<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; wallet-info <span style="color:Red; id<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; ws-173-13-0<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; code<span style="color:Blue; >13<span style="color:Blue; </<span style="color:#A31515; code<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; label<span style="color:Blue; >Visits<span style="color:Blue; </<span style="color:#A31515; label<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; scale<span style="color:Blue; >0<span style="color:Blue; </<span style="color:#A31515; scale<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; wallet-info<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; wallet-info <span style="color:Red; id<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; ws-173-17-1<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; code<span style="color:Blue; >17<span style="color:Blue; </<span style="color:#A31515; code<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; label<span style="color:Blue; >Direct Mail Offers<span style="color:Blue; </<span style="color:#A31515; label<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; scale<span style="color:Blue; >0<span style="color:Blue; </<span style="color:#A31515; scale<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; wallet-info<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; wallet-info <span style="color:Red; id<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; ws-173-12-2<span style="color:Black; "<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; code<span style="color:Blue; >12<span style="color:Blue; </<span style="color:#A31515; code<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; label<span style="color:Blue; >Direct Mail $<span style="color:Blue; </<span style="color:#A31515; label<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; scale<span style="color:Blue; >2<span style="color:Blue; </<span style="color:#A31515; scale<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; wallet-info<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-guest-type<span style="color:Blue; >false<span style="color:Blue; </<span style="color:#A31515; is-guest-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-authorized<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-authorized<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-id<span style="color:Blue; >10659596<span style="color:Blue; </<span style="color:#A31515; transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-datetime<span style="color:Blue; >2011-12-02T14:50:37.573-05:00<span style="color:Blue; </<span style="color:#A31515; transaction-datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-type<span style="color:Blue; >Transaction History<span style="color:Blue; </<span style="color:#A31515; transaction-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-merchant<span style="color:Blue; >Fox and Hound Restaurant Group<span style="color:Blue; </<span style="color:#A31515; store-merchant<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-number<span style="color:Blue; >9999<span style="color:Blue; </<span style="color:#A31515; store-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-name<span style="color:Blue; >Web Sale Fulfillment<span style="color:Blue; </<span style="color:#A31515; store-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; terminal-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; terminal-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; operator-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; operator-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender<span style="color:Blue; >PARTNER<span style="color:Blue; </<span style="color:#A31515; sender<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-guest-type<span style="color:Blue; >false<span style="color:Blue; </<span style="color:#A31515; is-guest-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-authorized<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-authorized<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-id<span style="color:Blue; >10659592<span style="color:Blue; </<span style="color:#A31515; transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-datetime<span style="color:Blue; >2011-12-02T14:29:46.003-05:00<span style="color:Blue; </<span style="color:#A31515; transaction-datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-type<span style="color:Blue; >Transaction History<span style="color:Blue; </<span style="color:#A31515; transaction-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-merchant<span style="color:Blue; >Fox and Hound Restaurant Group<span style="color:Blue; </<span style="color:#A31515; store-merchant<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-number<span style="color:Blue; >9999<span style="color:Blue; </<span style="color:#A31515; store-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-name<span style="color:Blue; >Web Sale Fulfillment<span style="color:Blue; </<span style="color:#A31515; store-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; terminal-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; terminal-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; operator-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; operator-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender<span style="color:Blue; >PARTNER<span style="color:Blue; </<span style="color:#A31515; sender<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-auth-code<span style="color:Blue; >651449<span style="color:Blue; </<span style="color:#A31515; px-auth-code<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-guest-type<span style="color:Blue; >false<span style="color:Blue; </<span style="color:#A31515; is-guest-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-authorized<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-authorized<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-id<span style="color:Blue; >10659591<span style="color:Blue; </<span style="color:#A31515; transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-datetime<span style="color:Blue; >2011-12-02T14:25:52.140-05:00<span style="color:Blue; </<span style="color:#A31515; transaction-datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-type<span style="color:Blue; >Transaction History<span style="color:Blue; </<span style="color:#A31515; transaction-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-merchant<span style="color:Blue; >Fox and Hound Restaurant Group<span style="color:Blue; </<span style="color:#A31515; store-merchant<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-number<span style="color:Blue; >9999<span style="color:Blue; </<span style="color:#A31515; store-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-name<span style="color:Blue; >Web Sale Fulfillment<span style="color:Blue; </<span style="color:#A31515; store-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; terminal-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; terminal-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; operator-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; operator-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender<span style="color:Blue; >PARTNER<span style="color:Blue; </<span style="color:#A31515; sender<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-auth-code<span style="color:Blue; >257682<span style="color:Blue; </<span style="color:#A31515; px-auth-code<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-guest-type<span style="color:Blue; >false<span style="color:Blue; </<span style="color:#A31515; is-guest-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-authorized<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-authorized<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-id<span style="color:Blue; >10659590<span style="color:Blue; </<span style="color:#A31515; transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-datetime<span style="color:Blue; >2011-12-02T14:23:44.103-05:00<span style="color:Blue; </<span style="color:#A31515; transaction-datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-type<span style="color:Blue; >Transaction History<span style="color:Blue; </<span style="color:#A31515; transaction-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-merchant<span style="color:Blue; >Fox and Hound Restaurant Group<span style="color:Blue; </<span style="color:#A31515; store-merchant<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-number<span style="color:Blue; >9999<span style="color:Blue; </<span style="color:#A31515; store-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-name<span style="color:Blue; >Web Sale Fulfillment<span style="color:Blue; </<span style="color:#A31515; store-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; terminal-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; terminal-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; operator-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; operator-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender<span style="color:Blue; >PARTNER<span style="color:Blue; </<span style="color:#A31515; sender<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-auth-code<span style="color:Blue; >139795<span style="color:Blue; </<span style="color:#A31515; px-auth-code<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-guest-type<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-guest-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-authorized<span style="color:Blue; >false<span style="color:Blue; </<span style="color:#A31515; is-authorized<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-id<span style="color:Blue; >10659489<span style="color:Blue; </<span style="color:#A31515; transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-datetime<span style="color:Blue; >2011-12-01T18:41:23.630-05:00<span style="color:Blue; </<span style="color:#A31515; transaction-datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-type<span style="color:Blue; >Denied Activate<span style="color:Blue; </<span style="color:#A31515; transaction-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-merchant<span style="color:Blue; >Fox and Hound Restaurant Group<span style="color:Blue; </<span style="color:#A31515; store-merchant<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-number<span style="color:Blue; >65069<span style="color:Blue; </<span style="color:#A31515; store-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-name<span style="color:Blue; >Fox <span style="color:Red; &amp; Hound Wichita<span style="color:Blue; </<span style="color:#A31515; store-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; terminal-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; terminal-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; operator-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; operator-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender<span style="color:Blue; >PARTNER<span style="color:Blue; </<span style="color:#A31515; sender<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-auth-code<span style="color:Blue; >-1<span style="color:Blue; </<span style="color:#A31515; px-auth-code<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-guest-type<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-guest-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-authorized<span style="color:Blue; >false<span style="color:Blue; </<span style="color:#A31515; is-authorized<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-id<span style="color:Blue; >10659483<span style="color:Blue; </<span style="color:#A31515; transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-datetime<span style="color:Blue; >2011-12-01T18:07:41.553-05:00<span style="color:Blue; </<span style="color:#A31515; transaction-datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-type<span style="color:Blue; >Denied Activate<span style="color:Blue; </<span style="color:#A31515; transaction-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-merchant<span style="color:Blue; >Fox and Hound Restaurant Group<span style="color:Blue; </<span style="color:#A31515; store-merchant<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-number<span style="color:Blue; >65069<span style="color:Blue; </<span style="color:#A31515; store-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-name<span style="color:Blue; >Fox <span style="color:Red; &amp; Hound Wichita<span style="color:Blue; </<span style="color:#A31515; store-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; terminal-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; terminal-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; operator-id<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; operator-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender<span style="color:Blue; >PARTNER<span style="color:Blue; </<span style="color:#A31515; sender<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-auth-code<span style="color:Blue; >-1<span style="color:Blue; </<span style="color:#A31515; px-auth-code<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-guest-type<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-guest-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; is-authorized<span style="color:Blue; >true<span style="color:Blue; </<span style="color:#A31515; is-authorized<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-id<span style="color:Blue; >10638629<span style="color:Blue; </<span style="color:#A31515; transaction-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >web<span style="color:Blue; </<span style="color:#A31515; pos-transaction-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-datetime<span style="color:Blue; >2011-11-18T16:55:01.780-05:00<span style="color:Blue; </<span style="color:#A31515; transaction-datetime<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; transaction-type<span style="color:Blue; >Activate<span style="color:Blue; </<span style="color:#A31515; transaction-type<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-merchant<span style="color:Blue; >Fox and Hound Restaurant Group<span style="color:Blue; </<span style="color:#A31515; store-merchant<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-number<span style="color:Blue; >65931<span style="color:Blue; </<span style="color:#A31515; store-number<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; store-name<span style="color:Blue; >Denver Office<span style="color:Blue; </<span style="color:#A31515; store-name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; operator-id<span style="color:Blue; >5528742<span style="color:Blue; </<span style="color:#A31515; operator-id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; sender<span style="color:Blue; >CSR<span style="color:Blue; </<span style="color:#A31515; sender<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; px-auth-code<span style="color:Blue; >1<span style="color:Blue; </<span style="color:#A31515; px-auth-code<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; wallet-detail<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; accrued<span style="color:Blue; >2<span style="color:Blue; </<span style="color:#A31515; accrued<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; redeemed<span style="color:Blue; >0<span style="color:Blue; </<span style="color:#A31515; redeemed<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; balance<span style="color:Blue; >2<span style="color:Blue; </<span style="color:#A31515; balance<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; wallet-info <span style="color:Red; idref<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; ws-173-17-1<span style="color:Black; " <span style="color:Blue; />
<span style="color:Blue; </<span style="color:#A31515; wallet-detail<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-detail<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; transaction-history-reply<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; soap-env<span style="color:Blue; :<span style="color:#A31515; Body<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; soap-env<span style="color:Blue; :<span style="color:#A31515; Envelope<span style="color:Blue; >
[/code]
<br/><br/>[/code]
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; span <span style="color:Red; style<span style="color:Blue; =<span style="color:Black; "<span style="color:Blue; white-space:normal<span style="color:Black; "<span style="color:Blue; >I need the results to be output to a grid that looks like this:<span style="color:Blue; </<span style="color:#A31515; span<span style="color:Blue; >
[/code]
<img src="http://social.microsoft.com/Forums/getfile/40671/" alt="
I have the following code that does export the data to a Datagrid, but I dont know how to link the two wallet-code elements to get the description for the reward column in the datagrid.


<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; Dim resultsXML <span style="color:Blue; As XElement = XElement.Load(<span style="color:#A31515; "C:thistory.xml")
<span style="color:Blue; Dim q = <span style="color:Blue; From th <span style="color:Blue; In resultsXML...<transaction-detail> _
<span style="color:Blue; Select <span style="color:Blue; New <span style="color:Blue; With { _
.TransactionTime = th.<transaction-datetime>.Value, _
.StoreName = th.<store-name>.Value, _
.CheckNo = th.<pos-transaction-number>.Value, _
.TransactionType = th.<transaction-type>.Value, _
.Balance = th.Descendants(<span style="color:#A31515; "balance").Value}


DataGridView1.DataSource = q.ToList
[/code]
<br/>
Any help or direction would be appreciated.
<hr class="sig Brock davis

View the full article
 
Back
Top