grouping rows in gridview...

[pranavcool]

Hi, I have to show some data in gridview group wise. I an having 2 sql tables with some data as shown below.

Table 1

Empid Empname
01 abc
02 xyz
03 pqr

Table 2

Assign1 Empid Assignment
01 01 Assign1
02 01 Assign2
03 01 Assign3
04 02 Assign1
05 03 Assign1

above is the table structure. Now i want to display it in gridview employee name wise as shown below.

Name Assignment
abc Assign1
Assign2
Assign3
xyz Assign1
pqr Assign1

i want to display it in grid view name wise i.e i want to group assignments by employee name and show it in gridview. i an sql server 2005 as database. Any suggestion or code snippet or useful link representing above will be useful. Thanks and regards,

Pranav Dave

[Avinash_Mane]

Hi pranav, Please check this out. Creating groups and summaries with 2 lines of code[^]

[Brij]

have a look to the following links Link 1 Linkk 2 Link 3 Hope it'll help you

Cheers!! Brij Check my latest Article :Exploring ASP.NET Validators