Populate Listbox from Dataview 1

[LFCfan]

Hi

I have a listbox on a windows form that i want to populate with items from a dataview.
i have the following:

Dim dsDatabases As DataSet
Dim dtDatabases As DataTable
Dim dvDatabases As DataView

dsDatabases = GetDatabases()
dtDatabases = dsDatabases.Tables("Databases&quot
dvDatabases = dtDatabases.DefaultView
dvDatabases.RowFilter = "DBName LIKE 'CCRAccount_[%]' AND DBName LIKE '[%]dk'"

Me.ListBox1.DataSource = dvDatabases
Me.ListBox1.DisplayMember = "DBName"
Me.ListBox1.ValueMember = "DBName"
Me.ListBox1.Refresh()


...but unfortunately the listbox is empty!
i'm totally baffled, and i've hunted high and low to find an example or something in the online help and various forums, but nothing's helped. (i'm quite new at all this, in case this wasn't glaringly obvious!)

i'm probably missing something very basic here - any suggestions would be very much appreciated.

TIA
LFCfan

 

[kbalaji]

I have used datarow and iterated through the rows and populated the listbox. I tried this method below and works fine for me. This might not be the most efficient method, but it works

Private Sub loadListbox(ByVal selectString As String)

oConn.Open()
oQuery = "Select * from JOBLIST"
oCommand = New OleDbCommand(oQuery, oConn)
oAdapter = New OleDbDataAdapter(oCommand)
oJobDataset = New DataSet()
oAdapter.Fill(oJobDataset)

JobListBox.Items.Clear()

Dim oDataRow As DataRow
oTable = oJobDataset.Tables(0)
Dim objResults() As DataRow
objResults = oTable.Select("JOBLIST_NAME LIKE '" & selectString & "%'", "&quot
For Each oDataRow In objResults
JobListBox.Items.Add(oDataRow("JOBLIST_NAME&quot)
Next

End Sub

 

[LFCfan]

Thanks kbalaji
That's done the trick!
I couldn't get the .DataSource way to work, and i've been trying to for most of the day!!

Thanks again

LFCfan