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
Sub Total 300.00
Sub Total 200.00
Grand Total 500.00
Please Help this matter. Please provide coding sample.