Specifying the Default Namespace

[JT]

Hi all,
I have a pretty basic question... I have a method (below) which uses
ExecuteXMLReader 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 sqlCmdSendClaims
.Parameters("@NPID").Value = NPIDCursor

Dim doc As New XmlDocument
cnSA.Open()
Dim myXmlReader As XmlTextReader = .ExecuteXmlReader()
myXmlReader.WhitespaceHandling = WhitespaceHandling.None
doc.Load(myXmlReader)
'close the XmlReader when finished.
myXmlReader.Close()
cnSA.Close()
doc.Save("D:\BTS\" & strFileLoc & "claim in\" & NPIDCursor & ".xml")

End With
--
John

[Steven Cheng[MSFT]]

Hi John,

Thanks for your posting.
AS for the adding namespace for XmlDocument question you mentioned, what
namespace do you means, the default namespace for the xml document's root
element or any arbitary namespace for certain nodes in the document(with or
without prefix).

The .net's XmlDocument didn't provide buildin interfaces for adding
namespaces for all the elemetns in document(including namespace prefix). If
you just want to add a default namespace for the whole XmlDocument, we can
use the XmlAttributes collection to append such as namespace, like:
============
XmlDocument doc = new XmlDocument();
doc.Load(@"..\..\xpath.xml");

XmlAttribute attr = doc.CreateAttribute("xmlns");
attr.Value = "http://www.test.org";

doc.DocumentElement.Attributes.Append(attr);
doc.Save("myoutput.xml");
==============

If there are many namespaces you need to add, and some of them are under
sub nodes(under different hierarchy in the document) and also need to add
namespace prefix for node, I suggest you use XSLT to transform the Document
rather than use the DOM api to modify the XmlDocument.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[JT]

Thanks Steve. I do mean the default namespace. I am doing the transform in
BizTalk Server 2004, and just trying to improve the interface between it and
my SQL Server datasource.
JT

"Steven Cheng[MSFT]" wrote:

Hi John,

Thanks for your posting.
AS for the adding namespace for XmlDocument question you mentioned, what
namespace do you means, the default namespace for the xml document's root
element or any arbitary namespace for certain nodes in the document(with or
without prefix).

The .net's XmlDocument didn't provide buildin interfaces for adding
namespaces for all the elemetns in document(including namespace prefix). If
you just want to add a default namespace for the whole XmlDocument, we can
use the XmlAttributes collection to append such as namespace, like:
============
XmlDocument doc = new XmlDocument();
doc.Load(@"..\..\xpath.xml");

XmlAttribute attr = doc.CreateAttribute("xmlns");
attr.Value = "http://www.test.org";

doc.DocumentElement.Attributes.Append(attr);
doc.Save("myoutput.xml");
==============

If there are many namespaces you need to add, and some of them are under
sub nodes(under different hierarchy in the document) and also need to add
namespace prefix for node, I suggest you use XSLT to transform the Document
rather than use the DOM api to modify the XmlDocument.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Steven Cheng[MSFT]]

Thanks for your followup.

If so, I think using the XmlNode's Attributes collection to manually set
the default namespace is a possbile approach. Have you met any further
problems ? If so, please feel free to post here.

Thanks & Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)