loop - datetime - get quarters in ddl

Riddhi Valecha

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..

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahe10y ago
Accepted 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 <= 2; iYearCount++)
{
for (int iQuarterCount = 1; iQuarterCount <= 4; 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.
Mahe10y ago
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 <=@RowCount)
Begin
Set @EndQuarterDate = DateAdd(d,-1,DateAdd(month,3,@Startdate))
Insert #Temp
Select 'Q'+Cast(@QuarterCount as varchar)+ ' ('+ Datename(month, @StartDate)+' '+ Datename(Year, @StartDate) +' - '+
Datename(month, @EndQuarterDate )+' '+ Datename(Year, @EndQuarterDate) +')'
Set @StartDate =DateAdd(d,1,@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 Valecha10y ago
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 Valecha10y ago
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 !
Mahe10y ago
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 <=@RowCount)
Begin
Set @EndQuarterDate = DateAdd(d,-1,DateAdd(month,3,@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