By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,573 Members | 1,927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,573 IT Pros & Developers. It's quick & easy.

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

P: n/a
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>
Feb 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Don,

You can try this ones

http://www.vb-tips.com/default.aspx?...a-c891846eaf0b

I hope this helps,

Cor
Feb 8 '06 #2

P: n/a
Don
Wonderful! Excellent! Perfect! Fantastic!

Thanks, I appreciate your help.

Don in Redmond

On Wed, 8 Feb 2006 07:09:38 +0100, "Cor Ligthert [MVP]"
<no************@planet.nl> wrote:
Don,

You can try this ones

http://www.vb-tips.com/default.aspx?...a-c891846eaf0b

I hope this helps,

Cor

Feb 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.