Clubbing of multiple rows data in one column

[Sanjaylml]

I have a form through which, e-mail address of parties are showing through datasheet mode. Is their any way to club the data of multiple rows in one column?

Like :


[e-mail]
[e-mail]

To

[e-mail];amarnathmishra@rediffmai l.com;


Shall be thankful if you kindly help me to solve my problem.

[dip_developer]

I have a form through which, e-mail address of parties are showing through datasheet mode. Is their any way to club the data of multiple rows in one column?

Like :


[e-mail]
[e-mail]

To

[e-mail];amarnathmishra@rediffmai l.com;


Shall be thankful if you kindly help me to solve my problem.

are you trying to do this in your query...I dont think it is possible through SQL......
if the data is in a datatable then just loop through the table and concatenate the values ........
I dont know which language you are using....nut here is a sample in VB.NET................

 Dim mailAddress as String 
Dim ConcatenatedMailAddress as string
For i As Integer=0 To myTable.Rows.Count-1
mailAddress=myTable.Rows(0).Item(i).ToString
ConcatenatedMailAddress += mailAddress & ";"
Next i