[(ASP.NET) codebehind = VB.NET) to populate a ListBox WebServer Control]

Would you please tell me what is wrong with the following code? It is not populating the ListBox control. 

        Dim strCmd As String
        strCmd = "select beat_no, descr from crv_gelbeat"
        CRSDBConnect.Open()
        Dim oCMD As New SqlDataAdapter(strCmd, CRSDBConnect)
        Dim oDS As New DataSet
        oCMD.Fill(oDS, "BeatList")
        Dim dt As DataTable = oDS.Tables("BeatList")
        dt.Columns.Add("BeatNumberDesc", Type.GetType
("System.String"), "beat_no + ' - ' + descr")
        lstGeoLeftPane.DataSource = oDS.Tables("BeatList").DefaultView
        lstGeoLeftPane.DataTextField = "BeatNumberDesc"
        lstGeoLeftPane.DataValueField = "beat_no"

Are you calling lstGeoLeftPane.DataBind() after that?

This was first published in October 2003

Back to top