DayPilot MonthPicker for ASP.NET

• Source code download
• Live demo

A few numbers for the beginning

• 3 demo pages: See the main features in action.
• 202 languages: Translated automatically using one of the cultures supported by ASP.NET
• 389 lines of code: Definitely no bloatware.

What it replaces

It replaces a combination of two separate dropdowns (one for month, another for year).

Typical usage

On reporting pages for listing values/summaries for a given time period.

How it saves your time

• It generates the month list automatically.
• It generates the year list automatically from the YearStart and YearEnd properties.
• It automatically uses the language of current culture.
• You can use directly to fill parameters of SqlDataSource (the selected month is accessible as both StartDate and EndDate properties).
• It automatically preselects the current month.
• Compatible with UpdatePanel.

Sample 1: Switching the language

You have two options for choosing the language:

1. Change the Culture in your Page declaration:

<%@ Page Language="C#" … Culture="en-US" %>

2. Set the Culture property of MonthPicker control:

MonthPicker1.Culture = "en-US";

Sample 2: SqlDataSource and GridView integration

DayPilot MonthPicker can be used directly in SqlDataSource declaration:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
ConnectionString="<%$ ConnectionStrings:MonthPicker %>" 
SelectCommand="SELECT [Id], [Name], [Start] FROM [events] WHERE ([Start] >= @Start) AND ([Start] < @End)"> 
    <SelectParameters> 
        <asp:ControlParameter 
    ControlID="MonthPicker1" PropertyName="StartDate"
            Name="Start" Type="DateTime" /> 
        <asp:ControlParameter 
        ControlID="MonthPicker1" PropertyName="EndDate"
            Name="End" Type="DateTime" /> 
    </SelectParameters> 
</asp:SqlDataSource> 

Links

• DayPilot MonthPicker Homepage
• Online Demo