ASP.NET

avi_dadi2002 wrote:

Because that coluumn sometime contains morethan 4k data

Dio22 wrote:

autosuggestmenu.com

C#Coudou wrote:

i used log4net to track the error of my page. in my localhost or my in developing machine. the log4net is 100% working.

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 />