Populate a DropDownList with a Sequence of Numbers using LINQ

Let us assume you want to populate a DropDownList with ‘Years’ data ranging from 1990 to 2010. The LINQ Range Operator is extremely useful in such situations to quickly generate a sequence of numbers. Here’s how to populate an ASP.NET DropDownList with a Sequence of Numbers using a single line of LINQ code.

C#

protected void Page_Load(object sender, EventArgs e)
{
    DropDownList1.DataSource = Enumerable.Range(1990, 21).ToList();
    DropDownList1.DataBind();
}

VB.NET

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    DropDownList1.DataSource = Enumerable.Range(1990, 21).ToList()
    DropDownList1.DataBind()
End Sub

As you can see, we use the Enumberable.Range method to generate a sequence of integers within a range and then bind the DropDownList to the list of integers.

OUTPUT