?
Solved

Reading XML into dataset and keeping line break from XML

Posted on 2007-12-01
4
Medium Priority
?
951 Views
Last Modified: 2012-06-27
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

0
Comment
Question by:va80
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Expert Comment

by:evilrix
ID: 20387943
0
 
LVL 55

Accepted Solution

by:
Jaime Olivares earned 600 total points
ID: 20387951
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
 
LVL 40

Expert Comment

by:evilrix
ID: 20387953
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

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question