Adding an item to a DropDownList which is connected to a SQLDataSource 1

[technisup]

Hi, how can i add a new item manually to a dropdownlist which is connected to a SQLDataSource?

This is my current code:

<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataGrupo" DataTextField="Descripcion"
                        DataValueField="IdGrupo" Style="position: relative">
                        <asp:ListItem Selected="True" Value="0">:: Seleccione ::</asp:ListItem>
                    </asp:DropDownList><asp:SqlDataSource ID="SqlDataGrupo" runat="server" ConnectionString="<%$ ConnectionStrings:SIPConnectionString %>"
                        SelectCommand="SELECT * FROM [Grupo]"></asp:SqlDataSource>

But is not displaying the new item ":: Seleccione ::" along with the other items extracted from the table.

 

[jmeckley]

couple different options.

<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataGrupo" DataTextField="Descripcion" DataValueField="IdGrupo" Style="position: relative" AppendDataBoundItems="true">
   <asp:ListItem Selected="True" Value="0">:: Seleccione ::</asp:ListItem>
 </asp:DropDownList>

or

<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataGrupo" DataTextField="Descripcion" DataValueField="IdGrupo" Style="position: relative" >
 </asp:DropDownList>

//code behind
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("", "text"));

Jason Meckley
Programmer
Specialty Bakers, Inc.