ADO.NET Dataset to XML and displaying namespace

  • Thread starter Thread starter Simeon Lobo
  • Start date Start date
S

Simeon Lobo

Hello All,

I have an ASP.NET web form that retrieves data from a SQL
Server stored proc containing a "FOR XML AUTO, XMLDATA".
The following is a snippet I use to convert the dataset to
XML;

'-- Start ---
ds.ReadXml(dr, XmlReadMode.Fragment)
Response.ContentType = "text/xml"
Response.Write(ds.GetXml)
'-- End ---

When the XML data is returned, it is formatted as;
<Schema1>
....
....
....
</Schema>

I was wondering if anyone could give me some ideas as to
replacing <Schema1> with a parent node of my choice. I
would also like to include a namespace declaration within
this parent node.

I would appreciate any ideas...thanks....

Simeon
 
You can associate a schema with your query. The Schema header will set the
root node such as the "myroot" in the partial schema header below:

<xsd:schema id="myRoot" xmlns:xsd="http://www.w3.org/2001/XMLSchema"...

If you don't have control over the schema used for the query then a simple
replace could be used (or XSLT transform).

ds.ReadXml(dr, XmlReadMode.Fragment)
dim s as string
s = ds.GetXml
s = s.Replace("<Schema1>","<myRoot>")
s = s.Replace("</Schema1>","</myRoot>")
Response.Write(s)

Hope this helps...
 
Back
Top