Click here to Skip to main content
16,020,182 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have a table which consist multiple rows with same values except one.
for e.g.

Sn------memberid-----name------ role
1 .......... 12 ...... ... subash ...... admin
2 ........ .. 12 ...... ... subash ...... member
3 ......... . 12 ....... .. subash ...... accountant


in datagridview i want to show this data as

Sn------member-id-----name------ role
1 ...... 12 ...... subash ...... admin,member,accountant

any help or hints would be appreciated.

thanks in advance :)
Posted
Updated 3-Jul-11 23:50pm
v3

1 solution

You can use group by in your SQL statement and then pull out the other members, or use a pivot table to create the format you want.
 
Share this answer
 
Comments
sanomama 4-Jul-11 5:51am    
can you provide some examples or link regarding this. I'm new to database nt familiar with many queries.
thanks for reply!
sanomama 4-Jul-11 12:10pm    
couldn't find anything. i'm in desperate help. can u post some code snippet.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900