xml - looking for help parsing SOAP response in C# -


i'm looking in parsing soap response this:

<?xml version="1.0"?> - <s:envelope xmlns:d="http://schemas.microsoft.com/xw/2004/10/dssp.html"   xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing"   xmlns:s="http://www.w3.org/2003/05/soap-envelope">    - <s:header>        <wsa:to>http://10.226.88.13:56031/</wsa:to>        <wsa:action>http://schemas.microsoft.com/xw/2004/10/dssp.html:getresponse</wsa:action> -<d:timestamp> <d:value>2016-08-10t16:24:46.3329154z</d:value> </d:timestamp> <wsa:relatesto>uuid:36d92433-4e72-47e5-8e8f-fc2b9a7344aa</wsa:relatesto> </s:header> -<s:body>     -<somedatadat xmlns="http://schemas.corp.com/2009/02/somedata.html">         -<somedataarray>             -<somedata>                 -<column1>                     <string>sales some1</string>                     <string>sales some2</string>                     <string>sales some3</string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                 </column1>                 -<column2>                     <float>0.061</float>                     <float>0.07</float>                     <float>0.08</float>                     <float>0</float>                     <float>0</float>                     <float>0</float>                     <float>0</float>                     <float>0</float>                 </column2>                 -<column3>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                 </column3>                 -<column4>                     <decimal>0.0000</decimal>                     <decimal>0.0000</decimal>                     <decimal>0.0000</decimal>                     <decimal>0.0000</decimal>                     <decimal>0.0000</decimal>                     <decimal>0.0000</decimal>                     <decimal>0.0000</decimal>                     <decimal>0.0000</decimal>                 </column4>                 -<noncolumn6>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                 </noncolumn6>                 -<column6>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                 </column6>                 -<column7>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                 </column7>                 -<column8>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                 </column8>                 -<column9>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                     <string> </string>                 </column9>                 -<column10>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                 </column10>                 -<column11>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                     <short>0</short>                 </column11>             </somedata>         </somedataarray>         <variablerecordcount>1</variablerecordcount>     </somedatadat> </s:body> </s:envelope>

i want extract 'somedata', table. code looks this:

namespace filereadtesting {     public class sometable     {         public static void main(string[] args)         {                 xnamespace ns = "http://schemas.corp.com/2009/02/somedata.html";             string filename = "somedata.xml";             xdocument xmlfile = xdocument.load(filename);              ienumerable<xelement> table =                 el in xmlfile.descendants(ns + "somedataarray")                 select el;             foreach (xelement el in table)                 console.writeline(el.value);              console.writeline("hit enter end");             console.readline();         }     } }

and not getting job done, since output is

"sales some1sales some2sales some30.0610.070.0800000000000000.00000.00000.00000.00000.00000.00000.00000.00000000000000000000"

i'm not sure how best read data table instead of long string.


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more