How to show demo title in Dropdownlist

Methoun Ahmed

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar8y ago
Accepted 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"));
Ruchi Sharavat8y ago
Try this:
DropDownList1.Items.Insert(0,"select");
Methoun Ahmed8y ago
DropDownList1.Items.Insert(0,new ListItem("Please Select One","0");I was already try the code but,not work Suraj
Suraj Kumar8y ago
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