DotNet Programming

when we want the first item of dropdownlist to be user defined which is binded from the database,we have to insert a new row in the dropdownlist at first postion and give the DataTextField as our requirement.

Coding :

OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=D:\\PrjAspnet\\test1\\db1.mdb");
DataRow dr;
protected void Page_Load(object sender, EventArgs e)
{
OleDbDataAdapter da = new OleDbDataAdapter("select empid,empname from emp", con);
DataTable dt = new DataTable();
da.Fill(dt); // fill dropdown from database
dr = dt.NewRow();
dr[0] = "0"; //DataValueField
dr[1] = "-------- Select --------"; //or dr[1] = "All" // DataTextField
dt.Rows.InsertAt(dr, 0); // give the postion where you want item to be
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "empname";
DropDownList1.DataValueField = "empid";
DropDownList1.DataBind();
}

Or

OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=D:\\PrjAspnet\\test1\\db1.mdb");
DataRow dr;
protected void Page_Load(object sender, EventArgs e)
{
OleDbDataAdapter da = new OleDbDataAdapter("select empid,empname from emp", con);
DataTable dt = new DataTable();
da.Fill(dt);
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "empname";
DropDownList1.DataValueField = "empid";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "--Select--");
DropDownList1.Items.FindByText("--Select--").Value = "0";
}