I have gridview with 5 columns. I want to show following result in gridview i.e no duplication of Appno,Type,Dept columns.
| Appno | Type
| Dept
| First Name
| Last Name
|
1
| Java
| HR
| a
| a
|
|
|
| b
| s
|
|
|
| c
| d
|
|
|
| d
| f
|
|
|
| e
| g
|
2
| Android
| IT
| aa
|
|
|
|
| ss
| yy
|
|
|
| dd
| uu
|
|
|
| ff
| uu
|
|
|
| gg
| ii
|
3
| .NET
| Design
| www
| jjj
|
|
|
| eee
| kkk
|
|
|
| rrr
| mmm
|
4
| PHP
| Code
| trtr
| gfhgf
|
|
|
| fgfg
| hgh
|
|
|
| gfgfg
| hghgf
|
|
|
| bbvcb
| bcvbcvb
|
5
| SQL
| Query
| gff
| bbvc
|
|
|
| gff
| bcvbcv
|
|
|
| bcvb
| bvcb
|
|
|
| vbvcb
| vbcb
|
|
|
| vbcvb
| bcbv
|
|
|
| bvbcv
| vcbvb
|