Hi all,
       I am retrieving data from database on group by basis. If The resultant of query is such a way as shown below.

        EC No HOD EC No.
        0001 0009
        0002 0009
        0003 0009
        0004 00010
        0005 00010

But I want to display the resultant in the grid as below

        EC No HOD EC No.
        -----------------------------
        0001
        0002 0009
        0003
        ------------------------------
        0004
        0005 00010
        ------------------------------
which is nothing but i want to merge the "HOD EC NO." cells and making it to display only once unless the next different HOD EC No. is found.
 Can this be possible in Datagrid. Hope u understood my query.
            Waiting For The Reply.........
            Thanks