displaying the data in gridview on click event

See more:

.NET

i have a table with columns like
cnmae(id),productname,qty,price
in this every id has more than one product, my requirement is when i click on the button i t will display the cname(id) and products related to that id in one columns like this

Cname(id)

2001
colgate
xxxx
yyyy
2002
zzzz
dfdsk
hhhhh


i used grid view for displaying data ,how can i do this,can any one help me,pls