XPath from String

[Joe Pannone]

Does anyone have an example on using an XPath statement (in VB.NET) where the
source XML document is NOT a file, but a 'text' value from SQL Server?

[Scott M.]

Load the text file into an XMLDocument and use XPath from there?
"Joe Pannone" <Jo********@dis cussions.micros oft.com> wrote in message
news:53******** *************** ***********@mic rosoft.com...

Does anyone have an example on using an XPath statement (in VB.NET) where
the
source XML document is NOT a file, but a 'text' value from SQL Server?

[Joe Pannone]

Its NOT a text file, its a 'text' value in a SQL Server table.

I have a (SQL Server 2005) table with a field (defined as TEXT) that contains
an XML document. In VB.NET (VS 2005) I need to get this xml document and
perform XPath statements on it. When I get the XML document and convert it
to a string I loose part of the document.

Dim xmltext As New System.Text.Str ingBuilder
Dim strReader As StringReader = New StringReader(xm ltext.ToString)
Dim reader As XmlTextReader = New XmlTextReader(s trReader)
Dim strSQL As New System.Text.Str ingBuilder

strSQL.Append(" SELECT msg as VAL from tblMessage WHERE ID=100")
'routine ExecSQLReturnVa l executes a SQL statements are returns VAL
xmltext.Append( ExecSQLReturnVa l(strSQL.ToStri ng))
strReader = New StringReader(xm ltext.ToString)
reader = New XmlTextReader(s trReader)
docNav = New XPathDocument(r eader)
now 'xmltext' does not have the full XML document, it has been cut off

Scott, Do you have an example in VB.NET to load the text?

"Scott M." wrote:

Load the text file into an XMLDocument and use XPath from there?
"Joe Pannone" <Jo********@dis cussions.micros oft.com> wrote in message
news:53******** *************** ***********@mic rosoft.com...

Does anyone have an example on using an XPath statement (in VB.NET) where
the
source XML document is NOT a file, but a 'text' value from SQL Server?

[Sonu Kapoor [MVP]]

Checkout my XPath examples:

http://weblogs.asp.net/sonukapoor/articles/159790.aspx

Sonu Kapoor
---
Posted via www.DotNetSlackers.com

[Joe Pannone]

Sonu, the examples on the site all use an actual XML file:

ds.ReadXml(Serv er.MapPath("fil e.xml"));
....

XPathDocument xmlDoc= new XPathDocument(S erver.MapPath(" categories.xml" ));
Does anyone have an example (preferably in VB.NET) when using XPath with an
XML document NOT from a file but from a SQL Table?


"Sonu Kapoor [MVP]" wrote:

Checkout my XPath examples:

http://weblogs.asp.net/sonukapoor/articles/159790.aspx

Sonu Kapoor
---
Posted via www.DotNetSlackers.com

[Martin Honnen]

Joe Pannone wrote:

Does anyone have an example on using an XPath statement (in VB.NET) where the
source XML document is NOT a file, but a 'text' value from SQL Server?

Here is a VB.NET example that reads the XML input from a .NET string
variable

Dim ExampleXML As String = "<gods><god>Kib o</god></gods>"
Dim Xml_Document As XPathDocument = _
New XPathDocument(N ew StringReader(Ex ampleXML))
Dim Navigator As XPathNavigator = Xml_Document.Cr eateNavigator()
Dim NodeIterator As XPathNodeIterat or = _
Navigator.Selec t("/gods/god")
While NodeIterator.Mo veNext()
Console.WriteLi ne(NodeIterator .Current.Value)
End While

If you have problems reading out text data from a data base into a
string variable then ask in a data base group.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Scott M.]

The fact that is coming from SQL is irrelevant. What you have is a string
of XML on your hands. Just use the LoadXML method of the XMLDocument object
to load it up.
"Joe Pannone" <Jo********@dis cussions.micros oft.com> wrote in message
news:06******** *************** ***********@mic rosoft.com...

Sonu, the examples on the site all use an actual XML file:

ds.ReadXml(Serv er.MapPath("fil e.xml"));
...

XPathDocument xmlDoc= new XPathDocument(S erver.MapPath(" categories.xml" ));
Does anyone have an example (preferably in VB.NET) when using XPath with
an
XML document NOT from a file but from a SQL Table?


"Sonu Kapoor [MVP]" wrote:

Checkout my XPath examples:

http://weblogs.asp.net/sonukapoor/articles/159790.aspx

Sonu Kapoor
---
Posted via www.DotNetSlackers.com

[Scott M.]

Dim doc As XmlDocument = New XmlDocument()
doc.LoadXM(refe r to the SQL text here)


"Joe Pannone" <Jo********@dis cussions.micros oft.com> wrote in message
news:48******** *************** ***********@mic rosoft.com...

Its NOT a text file, its a 'text' value in a SQL Server table.

I have a (SQL Server 2005) table with a field (defined as TEXT) that
contains
an XML document. In VB.NET (VS 2005) I need to get this xml document and
perform XPath statements on it. When I get the XML document and convert
it
to a string I loose part of the document.

Dim xmltext As New System.Text.Str ingBuilder
Dim strReader As StringReader = New StringReader(xm ltext.ToString)
Dim reader As XmlTextReader = New XmlTextReader(s trReader)
Dim strSQL As New System.Text.Str ingBuilder

strSQL.Append(" SELECT msg as VAL from tblMessage WHERE ID=100")
'routine ExecSQLReturnVa l executes a SQL statements are returns VAL
xmltext.Append( ExecSQLReturnVa l(strSQL.ToStri ng))
strReader = New StringReader(xm ltext.ToString)
reader = New XmlTextReader(s trReader)
docNav = New XPathDocument(r eader)
now 'xmltext' does not have the full XML document, it has been cut off

Scott, Do you have an example in VB.NET to load the text?

"Scott M." wrote:

Load the text file into an XMLDocument and use XPath from there?
"Joe Pannone" <Jo********@dis cussions.micros oft.com> wrote in message
news:53******** *************** ***********@mic rosoft.com...

> Does anyone have an example on using an XPath statement (in VB.NET)
> where
> the
> source XML document is NOT a file, but a 'text' value from SQL Server?

[Scott M.]

A System.XML.XMLD ocument object has 2 methods for loading it up with XML.

XMLDocument.Loa d(xmlTextFile)
XMLDocument.Loa dXML(xmlString)

Use the second one and then use standard XPath for parsing.

http://msdn.microsoft.com/library/de...adxmltopic.asp

"Joe Pannone" <Jo********@dis cussions.micros oft.com> wrote in message
news:48******** *************** ***********@mic rosoft.com...

Its NOT a text file, its a 'text' value in a SQL Server table.

I have a (SQL Server 2005) table with a field (defined as TEXT) that
contains
an XML document. In VB.NET (VS 2005) I need to get this xml document and
perform XPath statements on it. When I get the XML document and convert
it
to a string I loose part of the document.

Dim xmltext As New System.Text.Str ingBuilder
Dim strReader As StringReader = New StringReader(xm ltext.ToString)
Dim reader As XmlTextReader = New XmlTextReader(s trReader)
Dim strSQL As New System.Text.Str ingBuilder

strSQL.Append(" SELECT msg as VAL from tblMessage WHERE ID=100")
'routine ExecSQLReturnVa l executes a SQL statements are returns VAL
xmltext.Append( ExecSQLReturnVa l(strSQL.ToStri ng))
strReader = New StringReader(xm ltext.ToString)
reader = New XmlTextReader(s trReader)
docNav = New XPathDocument(r eader)
now 'xmltext' does not have the full XML document, it has been cut off

Scott, Do you have an example in VB.NET to load the text?

"Scott M." wrote:

Load the text file into an XMLDocument and use XPath from there?
"Joe Pannone" <Jo********@dis cussions.micros oft.com> wrote in message
news:53******** *************** ***********@mic rosoft.com...

> Does anyone have an example on using an XPath statement (in VB.NET)
> where
> the
> source XML document is NOT a file, but a 'text' value from SQL Server?