ASP.NET

Ginozzzz wrote:

But I simply can't believe that Microsoft would replace the CB with that feeble Drop Down List. Surely there's a simple way???

ListItem Li=ddlAll.Items[itemno];
Li.Attributes.Add("optionPrice",dt[itemno]["optionPrice"])

Protected Sub FillOptionsList()
  ddl1.Items.Clear()

  Dim sqlStr As String = "SELECT Option1, Option2, Option3 FROM TblOptions WHERE Bid=1"

  Dim con As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("myConnection").ConnectionString)
  Dim cmd As New SqlCommand(sqlStr, con)
  Dim reader As SqlDataReader

  Try
    con.Open()
    reader = cmd.ExecuteReader()


    Do While reader.Read()
      Dim newItem As New ListItem()
      newItem.Value = reader("Option1").ToString()
      newItem.Text = reader("Option2")
      ddl1.Items.Add(newItem)
    Loop
    reader.Close()

  Catch ex As Exception
    Label1.Text = "Error Reading list" & "  " & Err.Description
  Finally
    con.Close()
  End Try

End Sub

<br />
<asp:dropdownlist ontextchanged="OnTextChanged" xmlns:asp="#unknown"><br />
                                     SelectedValue='<%# Bind("fake_flag1")%>' <br />
                                     ID="ddl_test1" <br />
                                     DataSourceID="TestDS" <br />
                                     DataTextField="someDescription" <br />
                                     DataValueField="someID" <br />
                                     runat="server"><br />
</asp:dropdownlist><br />

<br />
 <asp:sqldatasource id="TestDS" runat="server" connectionstring="<%$ ConnectionStrings:ConnectionString %>" xmlns:asp="#unknown"><br />
        SelectCommand="SELECT * FROM TEST"><br />
    </asp:sqldatasource><br />

Sandraa wrote:

but your code is for aspx and I am using aspx.vb

Dim InsertComboUsuarios As DropDownList = DirectCast(detailsView.FindControl("InsertComboUsuarios"), DropDownList)

<asp:TemplateField HeaderText="Usuario del Servicio" >
 <ItemTemplate>
    <asp:Label ID="lblUsuario" Text='<%# Eval("Id_Usuario") %>' runat="server"></asp:Label>
 </ItemTemplate>
 <EditItemTemplate>
    <asp:DropDownList ID="EditComboUsuarios" runat="server"></asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
    <asp:DropDownList ID="InsertComboUsuarios" runat="server"></asp:DropDownList>
</InsertItemTemplate>
</asp:TemplateField>