how to list the date based on months?
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
Re: how to list the date based on months?
That's not really a great explanation. Examples help but only if we know the rules they're implementing. Are you saying that you have records that specify a date range that may span multiple months and, for each one, you want to produce multiple records with the date range adjusted to span no more than one calendar month?
Re: how to list the date based on months?
As jmcilhinney had mentioned, the explanation here is vague and lacking good 'enough' detail for somebody to understand. Of course you can see what the issue is here :) You don't get any help when people don't understand what you're asking.
~Ace