How can I read an XML string directly into a dataset without creating a file?

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Howdy Folks,

Below is an example of a string I've created in memory. I would like
to load it directly into a dataset that can then be displayed in a
DataGrid or . . . whatever. Can I load the string into the dataset
without first saving it to a file?

This doesn't work but, you probably know that <g>

Dim dsStatement As New DataSet("STMTTRN")
dsStatement.ReadXml(strOFXXML)


Thank you,

Don


EXAMPLE of strOFXXML:

-<OFX>
- <STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20050912120000</DTPOSTED>
<TRNAMT>-1.61</TRNAMT>
<FITID>2005091213</FITID>
<NAME>POS PURCHASE - SAFEWAY STORE SAF</NAME>
</STMTTRN>
- <STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20050912120000</DTPOSTED>
<TRNAMT>-3.00</TRNAMT>
<FITID>2005091212</FITID>
<NAME>POS PURCHASE - FRED MEYER </NAME>
</STMTTRN>
- <STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20050912120000</DTPOSTED>
<TRNAMT>-3.26</TRNAMT>
<FITID>2005091211</FITID>
<NAME>POS PURCHASE - SOU STAPLES </NAME>
</STMTTRN>
</OFX>
 
Wonderful! Excellent! Perfect! Fantastic!

Thanks, I appreciate your help.

Don in Redmond
 
Back
Top