data bound listbox + data table select command

[Brian Henry]

I have a data set full of data, and a list box, I want to be able to filter
that set of data to a specific clase then put the returned filtred data into
the list box... how would i do this? I already tried a few ways but haven't
found one that doesn't cause an exception yet... thanks!

[Cor]

Hi Brian,

I have a data set full of data, and a list box, I want to be able to filter that set of data to a specific clase then put the returned filtred data into the list box... how would i do this? I already tried a few ways but haven't found one that doesn't cause an exception yet... thanks!

Why not the the dataview rowfilter
\\\
dim ds as newdataview(mydatatable)
dv.rowfilter = "mycolomn = 'Mytext'"
mylistbox.datasource = dv
mylistbox.displaymember = "mycolomn"
mylistbox.valuemember = "myothercolomn"
///
I am curious why you do not want to use this by the framework supported
class.

Cor

[William Ryan eMVP]

One easy way is binding it to a dataview and setting the rowfilter to filter
out everything you don't want. As soon as the rowfilter is set, the
underlying data will change too.
"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:#E**************@TK2MSFTNGP10.phx.gbl...

I have a data set full of data, and a list box, I want to be able to filter that set of data to a specific clase then put the returned filtred data into the list box... how would i do this? I already tried a few ways but haven't found one that doesn't cause an exception yet... thanks!

[Brian Henry]

because i didn't know about it :)
"Cor" <no*@non.com> wrote in message
news:uJ**************@TK2MSFTNGP11.phx.gbl...

Hi Brian,

I have a data set full of data, and a list box, I want to be able to

filter

that set of data to a specific clase then put the returned filtred data

into

the list box... how would i do this? I already tried a few ways but

haven't

found one that doesn't cause an exception yet... thanks!

Why not the the dataview rowfilter
\\\
dim ds as newdataview(mydatatable)
dv.rowfilter = "mycolomn = 'Mytext'"
mylistbox.datasource = dv
mylistbox.displaymember = "mycolomn"
mylistbox.valuemember = "myothercolomn"
///
I am curious why you do not want to use this by the framework supported
class.

Cor