having trouble retrieving/using xml string from database field

[KathyB]

Hi again,

I save a fairly small xmlDocument to a single db field, xDoc.OuterXML
using a SQL insert statement...thi s works fine.

However, I then need to select that field (xmlWF) into an xmlDocument
to add nodes, etc., but haven't found the correct way.

I've also tried just saving it as a session variable, but still get
errors when I try to use it, so I know I'm doing something wrong!

Dim xDoc As New XmlDocument()
xDoc.Load(varWF ) 'uses the session variable
this gives me a "path too long" statement

Ideally, I'd like to know the correct way to extract and use it both
ways (from database field and from session variable). Using datareader
to get the field, how do I assign it to a variable or load it to the
xmlDocument?

Please give me an example, I assure you I've read a lot of
documentation and still haven't gotten it right!

Thanks, Kathy

[Teemu Keiski]

XmlDocument's Load method takes a Stream, String, TextReader or XmlReader as
an argument. But the String argument is meant to specify a file location
that the XML is loaded from not the XML itself.

To load XML from string use XmlDocument's LoadXml method.

--
Teemu Keiski
MCP, Designer/Developer
Mansoft tietotekniikka Oy
http://www.mansoft.fi

AspInsiders Member, www.aspinsiders.com
ASP.NET Forums Moderator, www.asp.net
AspAlliance Columnist, www.aspalliance.com
"KathyB" <Ka**********@a ttbi.com> wrote in message
news:75******** *************** **@posting.goog le.com...

Hi again,

I save a fairly small xmlDocument to a single db field, xDoc.OuterXML
using a SQL insert statement...thi s works fine.

However, I then need to select that field (xmlWF) into an xmlDocument
to add nodes, etc., but haven't found the correct way.

I've also tried just saving it as a session variable, but still get
errors when I try to use it, so I know I'm doing something wrong!

Dim xDoc As New XmlDocument()
xDoc.Load(varWF ) 'uses the session variable
this gives me a "path too long" statement

Ideally, I'd like to know the correct way to extract and use it both
ways (from database field and from session variable). Using datareader
to get the field, how do I assign it to a variable or load it to the
xmlDocument?

Please give me an example, I assure you I've read a lot of
documentation and still haven't gotten it right!

Thanks, Kathy