ASP.NET

avi_dadi2002 wrote:

Because that coluumn sometime contains morethan 4k data

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