how to remove the duplicated rows value in Sql server and bind them in gridview
<p>hi
 i have an table as <strong>products</strong> colums productid, productname, product value,
the values in the colums are .</p>

<pre><code>productid productname productQuantity
1         a1          2
1         a2          2
1         a3          2
1         a4          2
1         a5          2
2         a21         3
2         a22         3
2         a23         3
</code></pre>

<p>so when i  bind in gridview i need to get the output like this </p>

<pre><code>productid  productname         productQuantity
1          a1,a2,a3,a4,a5          2
2          a21,a22,a23             3
</code></pre>

<p>so how can i get the data in this  format when i bind to gridview.
 any help  how  to write Sp  so that i can  i get data in this format
 would be great . or these there any other way to achive the  data in this format
any help would be great 
thank you </p>
