Adding a default value in dropdownlist after binding with database

Question

I binded my ddl to my database as below  but how can I add a default text on top of the binded values so that it appears as   Select Color --- gt  default text Red --- gt  database value Blue --- gt  database value Green --- gt  database value      Code       DropDownList ddlSize    DropDownList FormView Product Row Cells 0  FindControl  ddlSize        CommerceEntities db   new CommerceEntities         ddlColor DataSource   from p in db ProductTypes                                       where p ProductID    pID                                       orderby p Color                                        select new   p Color        ddlColor DataTextField    Color     Thanks

User · Answer

You can add it programmatically or in the markup, but if you add it programmatically, rather than Add the item, you should Insert it as position zero so that it is the first item:

ddlColor.DataSource = from p in db.ProductTypes
                      where p.ProductID == pID
                      orderby p.Color
                      select new { p.Color };
ddlColor.DataTextField = "Color";
ddlColor.DataBind();
ddlColor.Items.Insert(0, new ListItem("Select Color", "");

The default item is expected to be the first item in the list. If you just Add it, it will be on the bottom and will not be selected by default.

User · Answer

design   lt asp DropDownList ID  ddlArea  DataSourceID  ldsArea  runat  server  ondatabound  ddlArea DataBound    gt    codebehind  protected void ddlArea DataBound object sender  EventArgs e        ddlArea Items Insert 0  new ListItem  --Select--    0

User · Answer

The solution provided by Justin should work  To be sure making use of SelectedIndex property will also help   ddlColor DataSource   from p in db ProductTypes                       where p ProductID    pID                       orderby p Color                       select new   p Color     ddlColor DataTextField    Color   ddlColor DataBind     ddlColor Items Insert 0  new ListItem  Select Color         ddlColor SelectedIndex   0

User · Answer

After data-binding  do this   ddlColor Items Insert 0  new ListItem  Select   NA       updated code   Or follow Brian s second suggestion if you want to do it in markup   You should probably add a RequiredFieldValidator control and set its InitialValue to  NA     lt asp RequiredFieldValidator    ControlToValidate  ddlColor  InitialValue  NA    gt

User · Answer

You can do it programmatically   ddlColor DataSource   from p in db ProductTypes                                   where p ProductID    pID                                   orderby p Color                                    select new   p Color    ddlColor DataTextField    Color   ddlColor DataBind    ddlColor Items Insert 0  new ListItem  Select    NA       Or add it in markup as    lt asp DropDownList    AppendDataBoundItems  true  gt      lt Items gt          lt asp ListItem Text  Select  Value      gt      lt  Items gt   lt  asp DropDownList gt

[c#] Adding a default value in dropdownlist after binding with database

Examples related to c#

Examples related to asp.net