loop - datetime - get quarters in ddl

Question

Dear all How do I get the quaters in dropdownlist in asp.net as from 2005 - I want the output as Q1 (January 2005 - March2005) Q2 (April 2005 - June 2005) Q3 (July 2005 - September2005) Q4 (October 2005 - December2005) - Line gap between 2 quarters Q1 (January 2006 - March2006) Q2 (April 2006 - June 2006) Q3 (July 2006 - September2006) Q4 (October 2006 - December2006) Please help..its a bit urgent.... Not able to form a loop..

Mahe · Answer

Hi Please find the code snippet in C# private void BindDropDown() { List lstDateRange = new List (); DateTime dtStartDate = new DateTime(2005 1 1); for (int iYearCount = 1; iYearCount { for (int iQuarterCount = 1; iQuarterCount { DateTime dtEndTime = dtStartDate.AddMonths(2); string s = Q+iQuarterCount+ +( +dtStartDate.ToString(MMM)+ +dtStartDate.Year.ToString()+ - +dtEndTime.ToString(MMM)+ + dtEndTime.Year.ToString(); dtStartDate = dtEndTime.AddMonths(1); lstDateRange.Add(s); } /// lstDateRange.Add( ); --Optional } DropDownList1.DataSource=lstDateRange; DropDownList1.DataBind(); } Hope it helps. In SQL loopcounter is not handled. I will rectify it and repost the sql code as well. Thanks.

Mahe · Answer

Hi Rectified script... Create table #Temp(MonthVal varchar(500)) Declare @StartDate datetime = '01/01/2005' Declare @RowCount int =8 Declare @LoopCount int =1 Declare @QuarterCount int =1 Declare @EndQuarterDate datetime While( @LoopCount Begin Set @EndQuarterDate = DateAdd(d-1DateAdd(month3@Startdate)) Insert #Temp Select 'Q'+Cast(@QuarterCount as varchar)+ ' ('+ Datename(month @StartDate)+' '+ Datename(Year @StartDate) +' - '+ Datename(month @EndQuarterDate )+' '+ Datename(Year @EndQuarterDate) +')' Set @StartDate =DateAdd(d1@EndQuarterDate) If(@QuarterCount =4) Begin Set @QuarterCount =1 End Else Begin Set @QuarterCount = @QuarterCount +1 End Set @LoopCount = @LoopCount +1 End Select * from #Temp drop table #Temp Hope it helps. Thanks.

Riddhi Valecha · Answer

The output of your code is - MonthVal Q1 (January 2005 - March 2005) Q2 (January 2005 - March 2005) Q3 (January 2005 - March 2005) Q4 (January 2005 - March 2005) Q1 (January 2005 - March 2005) Q2 (January 2005 - March 2005) Q3 (January 2005 - March 2005) Q4 (January 2005 - March 2005)

Riddhi Valecha · Answer

Hi.. I need this in asp.net c# (aspx.cs file)... Using Datetime.Now and stuffs.... I am unable to make that loop.... Please help !

Mahe · Answer

Hi I tried with SQL. Please let me know in case of any issues. Create table #Temp(MonthVal varchar(500)) Declare @StartDate datetime = '01/01/2005' Declare @RowCount int =8 Declare @LoopCount int =1 Declare @QuarterCount int =1 Declare @EndQuarterDate datetime While( @LoopCount Begin Set @EndQuarterDate = DateAdd(d-1DateAdd(month3@Startdate)) Insert #Temp Select 'Q'+Cast(@QuarterCount as varchar)+ ' ('+ Datename(month @StartDate)+' '+ Datename(Year @StartDate) +' - '+ Datename(month @EndQuarterDate )+' '+ Datename(Year @EndQuarterDate) +')' If(@QuarterCount =4) Begin Set @QuarterCount =1 End Else Begin Set @QuarterCount = @QuarterCount +1 End Set @LoopCount = @LoopCount +1 End drop table #Temp