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"));
}
}