Group by Queries in DataGrid

  • Thread starter Thread starter Sandeep
  • Start date Start date
S

Sandeep

Hi

I want to know that can we show the result of group by query in the
following way in datagrid

Data is like that

id val
1 4
1 5
1 6
3 6
5 7
2 6
5 2

O/p I want to be in grid to be like that

id val
1 4
5
6
Total 15

2 6
Total 6

3


and like that

Is it possible to do that in datagrid then how tell me I m using
sqlserver2000 as database


Regards
Sandeep
 
select * from table group by name
fill this data into dataset and bind the grid
Or use dataview
Nitin
 
Back
Top