How to show demo title in Dropdownlist

Question

I want to show demo title in dropdownlist like 'Select Item' from binding data value in dropdownlist.Database value show perfectly but demo text not show.Bellow my C# code

void GetStatus()
{
if (!IsPostBack)
{
SqlDataAdapter sda = new SqlDataAdapter("SELECT Title FROM tblCloseStatus", con);
DataTable dt = new DataTable();
sda.Fill(dt);
DropDownList1.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
DropDownList1.Items.Add(dr["Title"].ToString());
}
}
}

Here is my Asp.net Code

Jignesh Kumar · Answer

Hi, Please try below code Its good to have value and display text in dropdown, if you want to use that value in future it will be helpful. For loop not requred to bind dropdown. SqlDataAdapter sda = new SqlDataAdapter( "SELECT ID, Title FROM tblCloseStatus" , con); DataTable dt = new DataTable(); sda.Fill(dt); DropDownList1.DataSource = dt; DropDownList1.DataBind(); DropDownList1.DataTextField = "Title " ; DropDownList1.DataValueField = "ID" ; DropDownList1.DataBind(); DropDownList1.Items.Insert(0,ListItem("--Select Demo--", "0"));

Methoun Ahmed · Answer

DropDownList1.Items.Insert(0,new ListItem("Please Select One","0");I was already try the code but,not work Suraj

Suraj Kumar · Answer

Hello, You can insert item at index using below code after binding the dropdown DropDownList1.Items.Insert(0,new ListItem("Please Select One","0"); OR You can also insert a demo text with sql server query as below SELECT 'Select Item' AS Title, 0 AS SrNo UNION SELECT Title, 1 AS SrNo FROM tblCloseStatus ORDER BY SrNo Thanks Suraj

Ruchi Sharavat · Answer

Try this: DropDownList1.Items.Insert(0, "select" );

How to show demo title in Dropdownlist

Answers (4)