Dynamically bind (populate) DropDownList with months name using C# and VB.Net in ASP.Net

comunida...

SOLVED CLOSED ACTIVE ANSWERED
User: comunidadmexicanaroma
Posted: on Feb 03, 2021 10:46 PM
Forum: Data Controls
Answer: 1
Views: 11426
Sample Code: Download

How to dynamically bind dropdown with months name.

I place a DropDownList into my web page, then add following code to bind items to dropdown list within the page load event.

In this case is a DropDownList with month names.

On this DropDownList when the month changes, the previous month or months are no longer displayed

e.g. with date 01 February in the list disappears the month of January.

I would need that the previous month is no longer shown after the 10th of the following month

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Globalization;
using System;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack )
        {
            DD_Monthbind();
        }
    }

    private void DD_Monthbind()
    {
        DateTimeFormatInfo info = DateTimeFormatInfo.GetInstance(null);
        int currentMonth = DateTime.Now.Month;

        for (int i = 1; i < 13; i++)
        {
            bool isMonthInPast = i < currentMonth;

            if (!isMonthInPast)
                DropDownList1.Items.Add(new ListItem(info.GetMonthName(i), i.ToString()));
        }
    }
}

Can you help me?

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Feb 04, 2021 04:03 AM
Modified: on Feb 04, 2021 04:10 AM
Report

Hi comunidadmexi....,

Check this example. Now please take its reference and correct your code.

HTML

<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        DD_Monthbind();
    }
}

private void DD_Monthbind()
{
    System.Globalization.DateTimeFormatInfo info = System.Globalization.DateTimeFormatInfo.GetInstance(null);
    int currentMonth = DateTime.Now.Month;
    for (int i = currentMonth; i < 13; i++)
    {
        DropDownList1.Items.Add(new ListItem(info.GetMonthName(i), i.ToString()));
    }

    if (DateTime.Now.Day <= 10)
    {
        DropDownList1.Items.Insert(0, new ListItem(info.GetMonthName(currentMonth - 1), currentMonth.ToString()));
    }

    if (DropDownList1.Items.FindByValue(currentMonth.ToString()) != null)
    {
        DropDownList1.Items.FindByValue(currentMonth.ToString()).Selected = true;
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        DD_Monthbind()
    End If
End Sub

Private Sub DD_Monthbind()
    Dim info As Globalization.DateTimeFormatInfo = Globalization.DateTimeFormatInfo.GetInstance(Nothing)
    Dim currentMonth As Integer = DateTime.Now.Month
    For i As Integer = currentMonth To 13 - 1        
        DropDownList1.Items.Add(New ListItem(info.GetMonthName(i), i.ToString()))
    Next

    If DateTime.Now.Day <= 10 Then
        DropDownList1.Items.Insert(0, New ListItem(info.GetMonthName(currentMonth - 1), currentMonth.ToString()))
    End If

    If DropDownList1.Items.FindByValue(currentMonth.ToString()) IsNot Nothing Then
        DropDownList1.Items.FindByValue(currentMonth.ToString()).Selected = True
    End If
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Dynamically bind (populate) DropDownList with months name using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us