how to get only years in dropdownlist in c#asp.net

using system.collection.generaics;
dropdownlist.datasource=GetYear();
dropdownlist.databind();

public list string<string>GetYear()
{
list<string>get=new list<string>();
sqlcommand cmd=new sqlcmmand("select datapart(year,[date]) as year from tbl_Name ",con);
con.open();
sqldatareader dr=cmd.executereader();;

while(dr.read())
{
get.add(dr["year"].tosting());

}
con.close();
return get;
}

Thanks & Regards,
Alokssm

Raj_Chennai, if this helps please login to Mark As Answer. | Alert Moderator

Hi Raj,

private void Year()

{

 DateTimeFormatInfo info = DateTimeFormatInfo.GetInstance(null);

int year = DateTime.Now.Year - 5;

        for (int Y = year; Y <= DateTime.Now.Year; Y++)

        {

            dropYear.Items.Add(new ListItem(Y.ToString(), Y.ToString()));

        }

dropYear.SelectedValue = DateTime.Now.Year.ToString();

}

Raj_Chennai, if this helps please login to Mark As Answer. | Alert Moderator

private void Form1_Load(object sender, EventArgs e)
{
for (var i = 0; i < 6; i++)
{
var year = DateTime.Now.AddYears(i).Year;
yearComboBox.Items.Add(year);
}
}

Raj_Chennai, if this helps please login to Mark As Answer. | Alert Moderator