ASP.NET - Getting a list of dates between X and Y and databinding them to a DropDownList?

Question

Hi Everyone,

I am hoping that this is possible and easy! As the title says, I want to specify two dates and get a data set of dates by specifying the start and end date, then be able to bind that to a DropDownList control on my page..

If it isn't possible (which is a damn shame) does anyone have recommendations or best practices for doing this, as that sort of functionality appears on lots of sites.

Thanks in advance for any help! Pete

Answer 1

Apologies! I have since discovered that I can use DateTime span.. thanks go to this article on asp.net forums:

http://forums.asp.net/p/944596/1137162.aspx#1137162

Answer 2

Try this:

        DateTime start = new DateTime(2009, 1, 1);
        DateTime end = new DateTime(2009, 3, 1);
        var dates = Enumerable.Range(0, (end - start).Days).Select(x => start.AddDays(x));

Answer 3

I would think a simple way of doing this is to use a loop to iterate through the date range and add each date to the DropDownList. Something like:

while(startDate.Date <= endDate.Date)
{
    myDropDownList.Items.Add(new ListItem(startDate.ToShortDateString()));
    startDate = startDate.AddDays(1);
}