html in database

[Jochen Stuempfig]

hello,

i'd like to store text in an database and generate html files with the text
stored in the database. i use dom to generate an xml file and render it
using xsl. i use the following code to render the xsl file.

XmlTextWriter output = new XmlTextWriter("myHtmlFile.html",
System.Text.Encoding.Default);

XmlUrlResolver resolver = new XmlUrlResolver();

XMLGenerator gen = new XMLGenerator();

XmlDocument doc = gen.getObjectAsXML();

XslTransform transformer = new XslTransform();

transformer.Load("myStylesheet.xsl");

transformer.Transform(doc.CreateNavigator(), null, output, resolver);

output.Close();

My Problem is that when i have an text like <b>jochen</b> in the database
its rendered like it is and not like i want.

i've read a lot in the newsgroups about this, but nothing works.

Thanks for your help.

greets jochen

[Oleg Tkachenko [MVP]]

Jochen Stuempfig wrote:

My Problem is that when i have an text like <b>jochen</b> in the database
its rendered like it is and not like i want.

Most likely your XMLGenerator generates this as text not as XML markup.
So it's rendered as text onviously. I don't see nothing wrong with it.
If you do want it to be markup, make it markup in XMLGenerator.
Alternatively use disable-output-escaping feature in your XSLT
stylesheet, but beware it doesn't always work.

--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[Jochen Stuempfig]

Sorry for the stupid question, but how can i markup the xml in my generator?

"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> schrieb im
Newsbeitrag news:ui**************@TK2MSFTNGP09.phx.gbl...

Jochen Stuempfig wrote:

My Problem is that when i have an text like <b>jochen</b> in the database its rendered like it is and not like i want.

Most likely your XMLGenerator generates this as text not as XML markup.
So it's rendered as text onviously. I don't see nothing wrong with it.
If you do want it to be markup, make it markup in XMLGenerator.
Alternatively use disable-output-escaping feature in your XSLT
stylesheet, but beware it doesn't always work.

--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[Oleg Tkachenko [MVP]]

Jochen Stuempfig wrote:

Sorry for the stupid question, but how can i markup the xml in my generator?

Well, I didn't see your XML generator. How do you generate XML?
--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[Chris Barber]

Oleg is asking how you generated the text in the database? From an XML DOM
based method or just created the string yourself? Either way, if the stuff
in the database *is* XML then the <b> might be stored as escaped text as
opposed to an actual XML element in which case it *will* appear in your
resultant transform as just text.

Chris.

"Jochen Stuempfig" <jo**************@skillworks.de> wrote in message
news:c1*************@ID-120572.news.uni-berlin.de...
Sorry for the stupid question, but how can i markup the xml in my generator?

"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> schrieb im
Newsbeitrag news:ui**************@TK2MSFTNGP09.phx.gbl...

Jochen Stuempfig wrote:

My Problem is that when i have an text like <b>jochen</b> in the database its rendered like it is and not like i want.

Most likely your XMLGenerator generates this as text not as XML markup.
So it's rendered as text onviously. I don't see nothing wrong with it.
If you do want it to be markup, make it markup in XMLGenerator.
Alternatively use disable-output-escaping feature in your XSLT
stylesheet, but beware it doesn't always work.

--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[Jochen Stuempfig]

Ok here my code where i generate my xml data from an object.

XmlDocument doc = new XmlDocument();

XmlElement rootElement = doc.CreateElement("rootElement");

XmlAttribute attribNumber = doc.CreateAttribute("number");

attribNumber.Value = rootNumber;

rootElement.Attributes.Append(attribNumber);

foreach(ChildNode child in obj.ChildNodes)

{

XmlElement subElem = doc.CreateElement("child");

//this text contains some html tags eq. <b>jochen</b>

string text = sub._subsectionText;

subElem.AppendChild(doc.CreateTextNode(text));

rootElement.AppendChild(subElem);

}

doc.AppendChild(rootElement);

Thanks for your help,

jochen

"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> schrieb im
Newsbeitrag news:%2****************@TK2MSFTNGP10.phx.gbl...

Jochen Stuempfig wrote:

Sorry for the stupid question, but how can i markup the xml in my

generator?
Well, I didn't see your XML generator. How do you generate XML?
--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[Oleg Tkachenko [MVP]]

Jochen Stuempfig wrote:

//this text contains some html tags eq. <b>jochen</b>

string text = sub._subsectionText;

subElem.AppendChild(doc.CreateTextNode(text));

Well, you are storing it as text, so it's displayed as text.
You are sure it's wellformed html (all tags closed and properly nested,
no html entities etc), you can set it to subElem.InnerXml property.
But most likely it won't be wellformed, so use disable-output-escaping
in XSLT then.
--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[Jochen Stuempfig]

ok, i used the innerxml attribute to set the text. But it doesn't work
either.
I checked out now, that when i use xmlspy to transform the xml file it
works.
when i remove the disable-output-escaping attribute i have the same result
as in my application.
it seems, that the transformation in my application ignores the
disable-output-escaping.

greets jochen
"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> schrieb im
Newsbeitrag news:Oj**************@TK2MSFTNGP10.phx.gbl...

Jochen Stuempfig wrote:

//this text contains some html tags eq. <b>jochen</b>

string text = sub._subsectionText;

subElem.AppendChild(doc.CreateTextNode(text));

Well, you are storing it as text, so it's displayed as text.
You are sure it's wellformed html (all tags closed and properly nested,
no html entities etc), you can set it to subElem.InnerXml property.
But most likely it won't be wellformed, so use disable-output-escaping
in XSLT then.
--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com

[Jochen Stuempfig]

Hello,

i solved my last problem by reading other ng entries form you olek. from now
it works.
thank your very much for your guidance.

greets jochen
"Jochen Stuempfig" <jo**************@skillworks.de> schrieb im Newsbeitrag
news:c1*************@ID-120572.news.uni-berlin.de...

ok, i used the innerxml attribute to set the text. But it doesn't work
either.
I checked out now, that when i use xmlspy to transform the xml file it
works.
when i remove the disable-output-escaping attribute i have the same result
as in my application.
it seems, that the transformation in my application ignores the
disable-output-escaping.

greets jochen
"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> schrieb im
Newsbeitrag news:Oj**************@TK2MSFTNGP10.phx.gbl...

Jochen Stuempfig wrote:

//this text contains some html tags eq. <b>jochen</b>

string text = sub._subsectionText;

subElem.AppendChild(doc.CreateTextNode(text));

Well, you are storing it as text, so it's displayed as text.
You are sure it's wellformed html (all tags closed and properly nested,
no html entities etc), you can set it to subElem.InnerXml property.
But most likely it won't be wellformed, so use disable-output-escaping
in XSLT then.
--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com