I am developing windows application using C# and MS sql.
i have a table with records of startdate and enddate columns.
example
create table datetble(int did not null primarykey, startdate datetime, enddate datetime, cost int))
then the values are
101 1/1/2012 1/4/2012 1000
now i want to show this on datagirdview like this.
101 1/1/2012 30/1/2012 1000
101 1/2/2012 30/2/2012 1000
101 1/3/2012 31/3/2012 1000
1010 1/4/2012 30/4/2012 1000

just i need to show each months on datagirview. if there are 6 months.. then i want to show.. all the months in a table like above.
help me please