i having data in sql like
Date NAME Count
01-04-2013 AAJ TAK_A-LA-CARTE 2300
01-04-2013 ADHITYA_A-LA-CARTE 4000
01-04-2013 ANIMAL PLANET_A-LA-CARTE 5250
01-04-2013 ANIMAX_A-LA-CARTE 400
01-03-2013 AAJ TAK_A-LA-CARTE 2300
01-03-2013 ADHITYA_A-LA-CARTE 4000
01-03-2013 ANIMAL PLANET_A-LA-CARTE 5250
01-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 2300
01-04-2013 ADHITYA_A-LA-CARTE 2800 01-03-2013 4000
01-04-2013 ANIMAL PLANET_A-LA-CARTE 3500 01-03-2013 5250
01-04-2013 ANIMAX_A-LA-CARTE 2300 01-03-2013 400