in datagrid view the course should not be repeated
i want to merge the particular row in data grid view.how can i do?
output as follows in data grid view by using query in data grid view;
Date Course 1 2 3 4
15/1/2013 REO GS Null VB Null
16/1/2013 REO Null RJ Null SK
17/1/2013 REO TM Null RJ GS
18/1/2013 REO VRV RJ Null Ms
from the above output i want to show below as follows in data grid view;
Date Course 1 2 3 4
15/1/2013 REO GS Null VB Null
16/1/2013 Null RJ Null SK
17/1/2013 TM Null RJ GS
18/1/2013 VRv RJ Null Ms
from the above output i dont want to repeat the REO course for every date.the REO Course should be showed once in data grid view.
how can i do. help me.