Dataset to listbox

[cokedev]

I been having trouble finding out a way to quary my dataset and take the results and put it in a listbox.

 

-----------------------------------

Function LoadDiscreps()

dsJobDiscreps.ReadXml("../Data/JobDiscreps.xml")

Dim tDs As DataSet

Dim aRow As DataRow() = dsJobDiscreps.Tables("Discrepancy").Select("Job_ID = '000'")

lstDesc.DataSource = aRow

lstDesc.DisplayMember = "Discrep_ID"

lstDesc.ValueMember = "Discrep_ID"

 

 

End Function

------------------------------------

 

This is what i tought i can do but i guess it isn't possible...I guess i just need a nudge in the right direction.

[quwiltw]

I don't really get what you're trying to do since it seems like this would result in only a single value in the listbox but, you could set the RowFilter to "Job_ID='000'" and set your lstDesc data source to that and it should be fine.

 

Something like

Dim dv as DataView = dsJobDiscreps.Tables("Descrpancy").DefaultView
dv.RowFilter = "Job_ID='000'"