how to add data in asp.net dropdownlist

Question

how to add data in asp.net dropdownlist

RAVI 1,076

Hello

Example 1 :- Assume Current Month Is MAR-2024 and my asp.net dropdownlist like this

<asp:DropDownList ID=“Sample” runat=“server”>  
</asp:DropDownList>

I need my drodown list to be shown like this of past 12 months

MAR-2024

FEB-2024
JAN-2024
DEC-2023
NOV-2023
OCT-2023
SEP-2023
AUG-2023
JUL-2023
JUN-2023
MAY-2023
APR-2023

Example 2 :- Assume Current Month Is APR-2024 and my asp.net dropdownlist like this
APR-2024
MAR-2024
FEB-2024

JAN-2024

DEC-2023

NOV-2023

OCT-2023

SEP-2023

AUG-2023

JUL-2023

JUN-2023

MAY-2023

how to add this in my dopdownlist based on current month and it bind data like this for past 12 months using c# code or javascript

Thanking You

my drodpwnlist to be look like this

SurferOnWww 4,631 Reputation points

2024-03-08T23:07:42.4633333+00:00

Which do you want to use, client local time or server time or utc?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Accepted answer

2 additional answers

Your answer

SurferOnWww 4,631 Reputation points

2024-03-08T23:07:42.4633333+00:00

Which do you want to use, client local time or server time or utc?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

Albert Kallal 5,586

Assuming this markup:

        <asp:DropDownList ID="cboMonth" runat="server"

            DataTextField="text"

            DataValueField="value" >

        </asp:DropDownList>

Then this code should work quite well:

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

        void LoadCombo()
        {
            DateTime Today = DateTime.Now;
            DateTime dtStart = new DateTime(Today.Year, Today.Month, 1);

            for (int i = 1;i <= 12;i++)
            {
                ListItem OneMonth = new ListItem();
                OneMonth.Text = dtStart.ToString("MMM - yyyy");
                cboMonth.Items.Add(OneMonth);
                dtStart = dtStart.AddMonths(-1);
            }
        }

And the result is this:

cbomonths

SurferOnWww 4,631 Reputation points

2024-03-10T01:08:42.7+00:00

The result of dtStart.ToString("MMM - yyyy") depends on the culture. If it is "fr-FR" the result will be as follows:

To obtain the result such like "MAR-2024" required in the original question, the CultureInfo must be specified and the resultant string must be capitalized.
Albert Kallal 5,586 Reputation points

2024-03-10T03:36:32.1266667+00:00
Actually, we don't know if the user wants the text to be regional, or not (we can't make that assumption). And for English, then the posted code going to work fine. I happen to like the lower case letters for the month abbreviation, and think it looks much nicer (and I'm sure the poster will agree).

And "must" be capitalized? Where did that come from? There was no real stated "desire" that the text must be upper case, or should be upper case. The posted question shows this, but really nothing I can see suggests, hints or even implies that upper case is "some big" requirement, or even some big issue.

I mean, it is trivial to include a "ToUpper()" if the poster really does prefer upper case.

Hence, then this:

OneMonth.Text = $"{dtStart.ToString("MMM").ToUpper()} - {dtStart.ToString("yyyy")}";
SurferOnWww 4,631 Reputation points

2024-03-11T01:07:04.72+00:00
Actually, we don't know if the user wants the text to be regional, or not (we can't make that assumption).

That is right but "if the user wants the text to be regional, or not" does not matter.

Important thing is that we do not know the culture RAVI's server belongs to.

And we know the requirement how to show MAR-2024, FEB-2024, JAN-2024 ... in the DropDownList.

To satisfy the requirement despite of the culture RAVI's server belongs to while using the "MMM" custom format specifier the CultureInfo must be specified and the resultant string must be capitalized, as follows:

DateTime.ToString("MMM-yyyy", CultureInfo.CreateSpecificCulture("en-US")).ToUpper()
Albert Kallal 5,586 Reputation points

2024-03-11T03:06:41.93+00:00

Actually, once again, there is ZERO information in that post that hints, implies, or suggests that "regional" settings are any kind of issue here. Why much such conjecture here when no need exists?

I would in fact suggest that code producing the month text based on reginal settings would be FAR more preferred here, would it not be?

How do we even know or care that reginal settings are a issue here? Answer = we don't know and have no information to support such a claim. (and thus have no valid information to suggest that we must produce English dates in the drop down? Why such an unfounded assumption on your part?).

This is not a big deal one way or the other. I see nothing that suggests, hints or even implies that regional settings are an issue, or even required for this solution. Until such time such issues are brought up by the poster, then this narrative is moot, and not required.

The simple issue is the poster now has some sample code to work with. And making assumptions such as the text "must" be upper case as you did, nor now that some big regional issue exists? Nah, we just don't know or even have to care at this point in time.

The real goal at the end of the day here is to give some suggesting's, make some efforts to help the poster, and that's the best we can do.

Having been a MVP for 13 years, and having spent 25 years on-line answering questions?

No need to be all worried here - let's hope we helped the poster, and if issues of regional settings come up, and that such settings are to be ignored? Then once again, that's great and fine.

I am somewhat at a loss as to why you use the word "must" for upper case when no such requirement was stated by the poster. And this narrative also extends to your now insisting that some big regional issue here exists when we have no evidence suggesting as such.

Relax!!! - we just trying to help the poser - not insist that some big regional issue exists or is some kind of big deal breaker here. We both have posted helpful code and if need be, based on additional feedback from the poster, I'm sure we can all here pitch in and provide additional changes to the helpful answers here.

There is zero evidence that regional issues are relevant to this question at this point in time.
SurferOnWww 4,631 Reputation points

2024-03-11T05:39:14.53+00:00

Once again,

Important thing is that we do not know the culture RAVI's server belongs to.

And we know the requirement how to show MAR-2024, FEB-2024, JAN-2024 ... in the DropDownList.

It sounds like that you are saying "forget about it."

Answer 2

Please try the following:

using System;
using System.Collections.Generic;

namespace WebForms1
{
    public class Item
    {
        public string TextField { get; set; }
        public string ValueField { get; set; }
    }

    public partial class WebForm36 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Sample.DataSource = CreateDataSource(DateTime.Now);
            Sample.DataTextField = "TextField";
            Sample.DataValueField = "ValueField";
            Sample.DataBind();
        }

        protected List<Item> CreateDataSource(DateTime date)
        {
            var list = new List<Item>();
            for (int i = 0; i < 12; i++)
            {
                var item = new Item
                {
                    TextField = GetYearMonth(date.AddMonths(-i)),
                    ValueField = GetYearMonth(date.AddMonths(-i))
                };

                list.Add(item);
            }

            return list;
        }

        protected string GetYearMonth(DateTime date)
        {
            int year = date.Year;
            int month = date.Month;
            switch (month)
            {
                case 1:
                    return $"JAN-{year}";
                case 2:
                    return $"FEB-{year}";
                case 3:
                    return $"MAR-{year}";
                case 4:
                    return $"APR-{year}";
                case 5:
                    return $"MAY-{year}";
                case 6:
                    return $"JUN-{year}";
                case 7:
                    return $"JUL-{year}";
                case 8:
                    return $"AUG-{year}";
                case 9:
                    return $"SEP-{year}";
                case 10:
                    return $"OCT-{year}";
                case 11:
                    return $"NOV-{year}";
                case 12:
                    return $"DEC-{year}";
                default:
                    return null;
            }
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" 
    CodeBehind="WebForm36.aspx.cs" Inherits="WebForms1.WebForm36" %>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:DropDownList ID="Sample" runat="server">  
        </asp:DropDownList>
    </form>
</body>
</html>

result

result

Please note that the above shows server local time.

SurferOnWww 4,631 Reputation points

2024-03-10T03:04:37.7633333+00:00

In addition, please note that the culture does not matter in the above sample code.

Answer 3

Lan Huang-MSFT 30,186 Microsoft External Staff

Hi @RAVI,

You can try using Enumerable.Range method to achieve this.

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

 protected void Page_Load(object sender, EventArgs e)
 {
     if (!this.IsPostBack)
     {             
         ddl.DataSource = Enumerable.Range(0, 12).Select(i => DateTimeOffset.Now.AddMonths(-i).ToString("MMM-yyyy").ToUpper()); ;
         ddl.DataBind();
     }
 }

User's image

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

SurferOnWww 4,631 Reputation points

2024-03-11T07:43:19.18+00:00

Please note that we do not know the culture RAVI's server belongs to.
Albert Kallal 5,586 Reputation points

2024-03-11T15:46:51.3666667+00:00

Since the question does not suggest, hint or imply that regional setting are a issue, then we are to make the a "reasonable" assumption that using the current user's culture is fine and dandy. In other words, had the user stated I have a French site, but I want the month text to come out as say English, then your assumptions would be valid.

The user at no point in time stated, hinted, or suggested they are struggling with regional settings, and thus we have no reason to worry about regional settings until such time that issue has been brought up as being an issue for this question.
SurferOnWww 4,631 Reputation points

2024-03-12T00:39:31.9266667+00:00

we are to make the a "reasonable" assumption that using the current user's culture is fine and dandy.

I totally disagree with you.

The facts are:

(1) We do NOT know the culture RAVI's server belongs to.

(2) We know the requirement "MAR-2024, FEB-2024, JAN-2024 ..." in the DropDownList.

(3) You suggested the "MMM" custom format specifier in which the resultant string depends on the culture.

Therefore, I believe that you were at least supposed to put a note such like "The result of dtStart.ToString("MMM - yyyy") depends on the culture" in your answer.

In addition please note that someone else whose culture is different from en-US might visit this Q&A from the Google. Don’t you think that the note such like "The result depends on the culture" is helpful?

Share via

how to add data in asp.net dropdownlist

2 additional answers

Your answer