Reading XML into dataset and keeping line break from XML

I am reading information from a XML file into a Dataset and loading it to a webpage.  I wanted to keep the format from the XML file such as line break (see code example).  I loaded the xml to dataset as ds.ReadXml(filename) and loaded it do a table.  How can i make line break from text in <blog> in XML file appear in webpage??

<Comments>
    <Name>VAldimf</Name>
    <Time>01.12.2007 12:14:43</Time>
    <Title>slasfdj</Title>
    <Blog>valdij
södfj
 
 
 
asdföj
adsfj
 
asdföj
sadf</Blog>
    <ID>4</ID>
  </Comments>
 
 
...
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                TableRow tr = new TableRow();
                tr.Cells.Add(new TableCell());
...
                tr.Cells[0].Text = "<FONT size = 2 FACE = Verdana color = #8F8672 >" + dr[3].ToString() + "</FONT>";
                this.BlogTable.Rows.Add(tr);
.....

Open in new window

va80Asked:
Who is Participating?
 
Jaime OlivaresConnect With a Mentor Software ArchitectCommented:
Use :
tr.Cells[0].Text = "<FONT size = 2 FACE = Verdana color = #8F8672 >" + dr[3].ToString().Replace("\n","<br>") + "</FONT>";
               
Replace real newlines with the <br> tag.
0
 
evilrixSenior Software Engineer (Avast)Commented:
0
 
evilrixSenior Software Engineer (Avast)Commented:
http://msdn2.microsoft.com/en-us/library/ms256097.aspx

So, try this: -


Comments>
    <Name>VAldimf</Name>
    <Time>01.12.2007 12:14:43</Time>
    <Title>slasfdj</Title>
    <Blog xml:space="preserve">valdij
södfj
 
 
 
asdföj
adsfj
 
asdföj
sadf</Blog>
    <ID>4</ID>
  </Comments>

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.