Problem in Gridview

Question

Dear All,

I have Sql table it have mainly two fields Contract No & Amount. That Contract Number is Mainly categories two way
HP(Higher Perches) & LC(Leasing) . I want to bind that table in Gridview Like below

Contract Number Amount
LC001 100.00
LC002 200.00

Sub Total 300.00

HP001 100.00
HP002 100.00

Sub Total 200.00

Grand Total 500.00



Please Help this matter. Please provide coding sample.

Thank You....