469,943 Members | 2,608 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,943 developers. It's quick & easy.

filtering data view with row filter using boolean value

say i have a dataset called dv

and i have a boolean value i want to filter by "b_DoesWork"

while the column name in the data view that i want to filter on is called
"Works" how would i filter this since the rowfilter is a string? i tried

dv.rowfilter = "Works = " & b_DoesWork

and get errors back in the IDE that says

Cannot bind to the new value member. Parameter name: value

when I try to set the value of b_DoesWork through a property. what it does
is sets the b_DoesWork = value when the property is set then updates the row
filter to be what i stated above... but that error happens... how would you
go about doing this with a boolean? and technically i will need 5 boolean
filters on that same row filter in the end... because 5 properties can be
set boolean wise on this custom control that will be displaying data based
on the filtered data thanks!
Feb 3 '06 #1
2 3164
concatenate it so that it looks like = "ColumnName = true'
"Brian Henry" <no****@nospam.com> wrote in message
news:O1**************@TK2MSFTNGP09.phx.gbl...
say i have a dataset called dv

and i have a boolean value i want to filter by "b_DoesWork"

while the column name in the data view that i want to filter on is called
"Works" how would i filter this since the rowfilter is a string? i tried

dv.rowfilter = "Works = " & b_DoesWork

and get errors back in the IDE that says

Cannot bind to the new value member. Parameter name: value

when I try to set the value of b_DoesWork through a property. what it does
is sets the b_DoesWork = value when the property is set then updates the
row filter to be what i stated above... but that error happens... how
would you go about doing this with a boolean? and technically i will need
5 boolean filters on that same row filter in the end... because 5
properties can be set boolean wise on this custom control that will be
displaying data based on the filtered data thanks!

Feb 3 '06 #2
Hi Brian,

You can try

dv.rowfilter = "Works = " & b_DoesWork.ToString()

HTH

Elton Wang


"Brian Henry" wrote:
say i have a dataset called dv

and i have a boolean value i want to filter by "b_DoesWork"

while the column name in the data view that i want to filter on is called
"Works" how would i filter this since the rowfilter is a string? i tried

dv.rowfilter = "Works = " & b_DoesWork

and get errors back in the IDE that says

Cannot bind to the new value member. Parameter name: value

when I try to set the value of b_DoesWork through a property. what it does
is sets the b_DoesWork = value when the property is set then updates the row
filter to be what i stated above... but that error happens... how would you
go about doing this with a boolean? and technically i will need 5 boolean
filters on that same row filter in the end... because 5 properties can be
set boolean wise on this custom control that will be displaying data based
on the filtered data thanks!

Feb 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by WindAndWaves | last post: by
4 posts views Thread by Simon Jefferies | last post: by
1 post views Thread by Sundararajan | last post: by
reply views Thread by Paul | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.