[LINQ] Problem binding data to drop down box

        Dim Table1 As DataTable
        Table1 = New DataTable("DAT List")

        Dim datFiles As DataColumn = New DataColumn("Files")
        datFiles.DataType = System.Type.GetType("System.String")
        Table1.Columns.Add(datFiles)

        Dim datName As DataColumn = New DataColumn("Name")
        datFiles.DataType = System.Type.GetType("System.String")
        Table1.Columns.Add(datName)

        Dim datPath As String = txtPath.Text & "\SnapDriveInfo\"
        Dim datFile As String() = IO.Directory.GetFiles(txtPath.Text & "\SnapDriveInfo\")
        Dim file = From p In datFile Where p.Contains(".dat") Select p
        'Dim logName = From q In file Where q.Contains(".dat") Select q.Replace(datPath, String.Empty).Trim
        Dim logName = From q In file Where q.Contains(".dat") Select q.Replace(datPath, String.Empty).Trim


        For Each log In file
            txtOut.Text &= log
            txtOut.Text &= vbCrLf

            Dim Row1 As DataRow
            Try
                Row1 = Table1.NewRow()
                Row1.Item(datFiles) = log
                Row1.Item(datName) = logName
                Table1.Rows.Add(Row1)
            Catch ex As Exception

            End Try


        Next

        drpDatFiles.DataSource = Table1
        drpDatFiles.DataTextField = Table1.Columns(1).ToString
        drpDatFiles.DataValueField = Table1.Columns(0).ToString
        drpDatFiles.DataBind()

Select all Open in new window