0 Replies Latest reply on Jan 20, 2007 1:37 PM by JMR4ID

    XML PROBLEMS

    JMR4ID
      The following xml is returned to Flex via a webservice:

      <GetMonths2Response xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:SOAP-ENV=" http://schemas.xmlsoap.org/soap/envelope/" xmlns:sqlresultstream=" http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream" xmlns:sqlmessage=" http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage" xmlns:sqltypes=" http://schemas.microsoft.com/sqlserver/2004/sqltypes" xmlns:xsd=" http://www.w3.org/2001/XMLSchema" xmlns:sqlsoaptypes=" http://schemas.microsoft.com/sqlserver/2004/SOAP/types" xmlns:sqlrowcount=" http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount" xmlns:sqltransaction=" http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction" xmlns:sql=" http://schemas.microsoft.com/sqlserver/2004/SOAP" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance" xmlns:method=" http://schemas.microsoft.com/sqlserver/2004/SOAP" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" xmlns="http//localhost/">
      <GetMonths2Result msdata:UDTColumnValueWrapped="true" msdata:UseDataSetSchemaOnly="true">
      <diffgr:diffgram>
      <SqlRowSet1 xmlns="urn:schemas-microsoft-com:sql:SqlRowSet1">
      <row1>
      <MonthID>1</MonthID>
      <MonthName>January</MonthName>
      </row1>
      <row1>
      <MonthID>2</MonthID>
      <MonthName>February</MonthName>
      </row1>
      <row1>
      <MonthID>3</MonthID>
      <MonthName>March</MonthName>
      </row1>
      <row1>
      <MonthID>4</MonthID>
      <MonthName>April</MonthName>
      </row1>
      <row1>
      <MonthID>5</MonthID>
      <MonthName>May</MonthName>
      </row1>
      <row1>
      <MonthID>6</MonthID>
      <MonthName>June</MonthName>
      </row1>
      <row1>
      <MonthID>7</MonthID>
      <MonthName>July</MonthName>
      </row1>
      <row1>
      <MonthID>8</MonthID>
      <MonthName>August</MonthName>
      </row1>
      <row1>
      <MonthID>9</MonthID>
      <MonthName>September</MonthName>
      </row1>
      <row1>
      <MonthID>10</MonthID>
      <MonthName>October</MonthName>
      </row1>
      <row1>
      <MonthID>11</MonthID>
      <MonthName>November</MonthName>
      </row1>
      <row1>
      <MonthID>12</MonthID>
      <MonthName>December</MonthName>
      </row1>
      </SqlRowSet1>
      </diffgr:diffgram>
      </GetMonths2Result>
      </GetMonths2Response>

      My problem is that I cant get the "MonthName" or "MonthID" nodes into a datagrid? Any help would be greatly appreciated before I pull the rest of my hair out!!