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,

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)


    private void binddrop()
        //throw new NotImplementedException();
        SqlConnection con = new SqlConnection();
        con.ConnectionString=@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\emp.mdf;Integrated Security=True";
        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.Items.Insert(0, new ListItem("Apple","5"));


1 comment: