How to merge multiple datarows within a single dataset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I wonder how to merge multiple datarows within one single dataset? I have a
dataset which contains one table, in this table, for example, there are 10
records, where rec#1 - 5 have the same content in column(0) and rec#6-10 have
the same content in column(0), now I want to concatenate another column(1)
for records that have same content in column(0). that is, the new dataset
should have only two record: rec1's column(1) contains the text from previous
rec1-5, and rec2's contains previous rec6-10

Can anyone tell me how to do it? I believe there should be a simple way.

Thanks in advance.
 
Back
Top