Item add at first | 0 index After Bind ASP.NET DropDownList using c#

In this article, I will show you how to add item at 0 index after bind DropDownList in ASP.NET C#. I will give an simple example of it. First to bind the DropDownlist with the DataSource then you can use Insert method to add item at any position. Insert( ) method overloads with 4 parameters. You can use third option, in which we have two parameters first for Text and second for value.

Lets start to do:

Create a Database table with the following fields: 

CREATE TABLE [dbo].[user_table] (

    [Id]       INT           IDENTITY (1, 1) NOT NULL,

    [username] NVARCHAR (50) NULL,

    [Password] NVARCHAR (50) NULL,

    [email]    NVARCHAR (50) NULL,

    PRIMARY KEY CLUSTERED ([Id] ASC)

);

1. Add a new web form in the project.

2. Bind it with the mentioned table using SqlDataReader class. 

3. After bind you can use insert method.

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Default9 : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            binddrop();

        }

    }

    private void binddrop()

    {

        //throw new NotImplementedException();

        SqlConnection con = new SqlConnection();

        con.ConnectionString=@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\emp.mdf;Integrated Security=True";

        con.Open();

        SqlCommand cmd = new SqlCommand();

        cmd.CommandText = "select * from [user_table]";

        cmd.Connection = con;

        SqlDataReader rd = cmd.ExecuteReader();

        DropDownList1.DataSource = rd;

        DropDownList1.DataTextField = "username";

        DropDownList1.DataValueField = "Id";

        DropDownList1.DataBind();

        DropDownList1.Items.Insert(0, new ListItem("Apple","5"));

    }

}