Group by Queries in DataGrid

[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

 

[Thomas Dodds]

http://www.dotnetjunkies.com/Tutorial/47792CB0-0990-4BD8-BF84-B6063C4C9BBC.dcik

 

[Nitin]

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