Hi all,
I have a pretty basic question... I have a method (below) which uses
ExecuteXMLReade r to load the output from a FOR XML Explicit stored procedure
into an XML document, and then save the document to a file. It works well.
Now, I am trying to add namespace support, and want my namespace to be
something like "http://MapTo837P". How do I get this incorporated into the
XML document?
Thanks.
With sqlCmdSendClaim s
.Parameters("@N PID").Value = NPIDCursor
Dim doc As New XmlDocument
cnSA.Open()
Dim myXmlReader As XmlTextReader = .ExecuteXmlRead er()
myXmlReader.Whi tespaceHandling = WhitespaceHandl ing.None
doc.Load(myXmlR eader)
'close the XmlReader when finished.
myXmlReader.Clo se()
cnSA.Close()
doc.Save("D:\BT S\" & strFileLoc & "claim in\" & NPIDCursor & ".xml")
End With
--
John