How to format a DataSet to contain multiple data in a single column?
<p>I have a situation like: From DB I am getting data like </p>

<pre><code>-------------------------------------------------
ID  BOOK_NAME AUTHOR REMARKS
1   ASP.Net   xyz    It is a good book.
1   ASP.Net   xyz    I like this book.
1   ASP.Net   xyz    It worth buying.
2   C#.net    abc    It is a average book.
2   C#.net    abc    It is good for beginner.
--------------------------------------------------
</code></pre>

<p>As you can see, i have multiple remarks for a specific book detail. I am getting it as a DataSet. My problem is to remove the duplicate rows and set it something like in a DataSet.</p>

<pre><code>-------------------------------------------------
ID  BOOK_NAME AUTHOR REMARKS
1   ASP.Net   xyz    It is a good book.
                     I like this book.
                     It worth buying.
2   C#.net    abc    It is a average book.
                     It is good for beginner.
--------------------------------------------------
</code></pre>

<p>After creating the DataSet i have to convert to XML by using the dataSetObj.GetXml();</p>

<p>Any idea how to do this in C#?</p>
