i having data in sql like
Date NAME Count01-04-2013 AAJ TAK_A-LA-CARTE 230001-04-2013 ADHITYA_A-LA-CARTE 400001-04-2013 ANIMAL PLANET_A-LA-CARTE 525001-04-2013 ANIMAX_A-LA-CARTE 40001-03-2013 AAJ TAK_A-LA-CARTE 230001-03-2013 ADHITYA_A-LA-CARTE 400001-03-2013 ANIMAL PLANET_A-LA-CARTE 525001-03-2013 ANIMAX_A-LA-CARTE 400
and i want to display this data in gridview like
Date NAME COUNT date Count
01-04-2013 AAJ TAK_A-LA-CARTE 500 01-03-2013 230001-04-2013 ADHITYA_A-LA-CARTE 2800 01-03-2013 400001-04-2013 ANIMAL PLANET_A-LA-CARTE 3500 01-03-2013 525001-04-2013 ANIMAX_A-LA-CARTE 2300 01-03-2013 400