How To Get Financial Year Drop Down List I Want Like Eg.2014-2015,2015-2016

Question

1.00/5 (1 vote)

See more:

HI as beginner i am unable to make this,i hope someone who is well known about it,will help me to find out this. how to get financial year drop down list i want like eg.2014-2015,2015-2016.Thank You in Advance......

Posted 15-Jun-15 23:59pm

Member 11769503

Updated 16-Jun-15 0:01am

v2

Add a Solution

Comments

sasanka sekhar panda 16-Jun-15 6:10am

okk you want dropdown items from 2014-2015 to which year?

Member 11769503 16-Jun-15 6:44am

2015-2016,2016-2017...

sasanka sekhar panda 16-Jun-15 6:50am

DropDownList1.Items.Insert(0, new ListItem("---select---"));
DropDownList1.Items.Insert(1, new ListItem("2015-2016"));
DropDownList1.Items.Insert(2, new ListItem("2016-2017"));
see solution 2 if you want to generate the years dynamically...

OriginalGriff 16-Jun-15 6:10am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
So we need to know what kind of environment you are in (website, winforms, etc), what control you are using, where your data is coming from, and so forth.
And most important, we need to know what you have tried, where you are stuck, and what help you need.
Use the "Improve question" widget to edit your question and provide better information.

Member 11769503 16-Jun-15 6:47am

sir,am working on ASP.Net and its on winforms and data am taking from my internal server.sir i tried but i didn't succeed sorry for poor english

OriginalGriff 16-Jun-15 7:11am

OK - poor English isn't a problem, it's poor data that is! :laugh:

So your "internal server" (SQL server I assume) has a table holding data? What data? What datatypes? what does it contain? What do you need to do to it to get it in the format you want?

We can't guess this stuff - there are too many possible ways this could be organised - so we need to be given it!

2 solutions

Solution 2

C#

 protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                int year = DateTime.Now.Year , count = 1;
                DropDownList1.Items.Insert(0, new ListItem("---select---"));

                for (int i = year; i < year + 3; i++)
                {
                    DropDownList1.Items.Insert(count, new ListItem(i.ToString() + "-" + (i + 1).ToString()));
                    count++;
                }
                
            }
}

Posted 16-Jun-15 0:20am

sasanka sekhar panda

Updated 16-Jun-15 0:51am

v3

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2015-06-16T00:12:00

The following SQL will generate the list for you which you can then use as the datasource for your dropdown list

SQL

;WITH CTE AS
(
    SELECT YEAR(GETDATE()) - 1 AS d
    UNION ALL
    SELECT d + 1
    FROM CTE
    WHERE d < YEAR(GETDATE()) + 30
)
SELECT CAST(D AS VARCHAR) + '-' + CAST(D+1 AS VARCHAR)
FROM CTE

It starts from last year. Change the 30 to whatever your maximum number of years should be