Maruthu Pandian

Maruthu Pandian

  • NA
  • 3
  • 8.1k

how to Displaying single column in Multiple Columns in Grid

Apr 19 2013 9:11 AM

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