retrieve data from multiple columns

See more:

C#

SQL-Server

I am using VS2008 C# and SQL2008 R2.

I would like to retrieve data from multiple columns and merge them, separating them by comma.

E.g. Data in my SQL Table UserData:

No. | Username | Role 1 | Role 2 | Role 3 |

1 | firoz| USER | READONLY | WRITE |

Data I would like to display in my GridView GridView1:

No. | Username | Roles |

1 | firoz| USER, READONLY, WRITE |

how i write "SELECT" Command for this in sql2008 and C# code for GrideView