How to add academic years in dropdownlist?

Use DateTime[^] to get the years, do string concatenation(Ex. 2010-2011) & add it to dropdownlist.

DateTime.Now.Year() will return current year.

EDIT

---

Agree with Prasad. Store values in database & load it in dropdownlist. Consider this is your table(Academic_Years).

Years
--------------
2008-2009
2009-2010
2010-2011
2011-2012
--------------

Use below query to select the data

SELECT * FROM Academic_Years

Write code something like below

DataTable dt = GetYears();//Custom function to load Academic years from database
dropdownlist.DataSource = dt;
dropdownlist.DataBind();

Finally I suggest you to learn everything ASP.NET Tutorial @ W3Schools[^]

Hi Hari,

Please use this code in the Page_Load() event

if (!Page.IsPostBack)
        {
            for (int i = 2000; i <= 2012; i++)
            {
                int next = i + 1;
                DropDownList1.Items.Add(i.ToString() + "-" + next.ToString());
            }
        }

Please make as Resolved if this resolves your issue,

Please revert back to me in case of any cocnerns.

Thanks And Regards
Suman Zalodiya

it is basic. i don't know, what you want exactly. but this may help you.

dropdownlist.Items.Add("2010-2011");

There is no limit.
you can add items directly through code or your can take years in XML file and load XML in dropdowonlist

To fill the dropwdonlist from database use DataReader

cmd = new SqlCommand("select * from AcademicYears", con);
       cmd.CommandType = SqlDataSourceCommandType.Text;
       dr = cmd.ExecuteReader();
       while (dr.Read())
       {
               drp1.Items.Add(new ListItem(dr[AcademicYearName], dr[AcademicYearId]));
           // This is your Columne Name - "AcademicYearName"
           // This is your Primary key column - "AcademicYearId"
       }

There are two properties of Dropdownlist
1. DataTextField
2. DataValueField

Hence i have retrieve two fields from database.


Thanks