Displaying XML in an .aspx page

[john]

I am trying to create an xml page on the fly using asp.net with vb.
I am currently reading data from my database into a dataset and then
using the xmlwriter() to output it to the clients screen.
But.............. i want to be able to edit the content which comes
out, i have to add some exta nodes which are static in between the
database records.

So i have created a loop which reads through the database and outputs
the records.
however i have tried to output it using response.write(database
record)
this outputs the data but does not display correctly in the browser.
when viewing the source code all the tags are there but its not
displayed correctly.

any help greatly appreiciated...

[SQL Server Development Team [MSFT]]

IE display XML file by applying a style sheet to translate the XML file into
HTML first, then let IE display it on the screen. If your result is in pure
Xml, you can try to set the content type to text/xml instead of text/html to
let IE display the file for you. If the Xml file is part of page content,
then you need to translate the XML file into HTML yourself.

Here is the link:
http://msdn.microsoft.com/library/de...ml04212000.asp

points to a sample app which contains the mimedefault.xsl which you can use
for XML -> HTML transformation.

Howard Hao

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"john" <j.*********@leeds.ac.uk> wrote in message
news:84**************************@posting.google.c om...

I am trying to create an xml page on the fly using asp.net with vb.
I am currently reading data from my database into a dataset and then
using the xmlwriter() to output it to the clients screen.
But.............. i want to be able to edit the content which comes
out, i have to add some exta nodes which are static in between the
database records.

So i have created a loop which reads through the database and outputs
the records.
however i have tried to output it using response.write(database
record)
this outputs the data but does not display correctly in the browser.
when viewing the source code all the tags are there but its not
displayed correctly.

any help greatly appreiciated...

[Severin]

If you just want the Text (innerXML) to display load the Text of the Item
such as

ds=new dataset
ds.ReadXml(path)
ds.Tables(ndx).Rows(ndx)("item") <-- where item is text to display

use a labelcontrol to display that text

Check out

http://www.arlingtonsoccer.org/?section=11

This page displays text that is presisted in an XML file

XML Source

http://www.arlingtonsoccer.org/data/xml/AnD.xml

The XML is first HtmlEncoded, then UrlEncoded.

"john" <j.*********@leeds.ac.uk> wrote in message
news:84**************************@posting.google.c om...

I am trying to create an xml page on the fly using asp.net with vb.
I am currently reading data from my database into a dataset and then
using the xmlwriter() to output it to the clients screen.
But.............. i want to be able to edit the content which comes
out, i have to add some exta nodes which are static in between the
database records.

So i have created a loop which reads through the database and outputs
the records.
however i have tried to output it using response.write(database
record)
this outputs the data but does not display correctly in the browser.
when viewing the source code all the tags are there but its not
displayed correctly.

any help greatly appreiciated...