bindingsource.filter

[pierrewhy]

I'm trying to filter by HouseNo "String" and RequestNo "Integer"
I've tried all kind of way and nothing work.

[SIZE=2]TypeOfRenoBindingSource.Filter = [/SIZE][SIZE=2][COLOR=#a31515]"HouseNumber like '"[/COLOR][/SIZE][SIZE=2] + HouseNo + [/SIZE][SIZE=2][COLOR=#a31515]" ' " AND " [SIZE=2][COLOR=#008000][SIZE=2][COLOR=#a31515]"RequestNumber = " ' "[/COLOR][/SIZE][SIZE=2][COLOR=#000000] + RequestNo + [/COLOR][/SIZE][SIZE=2][COLOR=#a31515]" ' "[/COLOR][/SIZE]
[/COLOR][/SIZE][/COLOR][/SIZE]

Help please.

Thanks,
Pierre

 

[Paszt]

and nothing work.

Why doesn't it work? Are you getting an error? If so, what error?

 

[cjard]

.Filter = string.Format("[HouseNumber] LIKE '{0}%' And [RequestNo] = {1}", houseNo, requestNo)


Thats how we build multipart strings now. We dont continuously start and stop the string ("a" & b & "c" & d & " e") becuase it looks a MESS!

+ is NOT the operator for string concat in VB. you dont use string concat when you use string.Format, but if you ever do perform string concat (not in this case), use &

 

[cjard]

Why doesn't it work? Are you getting an error? If so, what error?

well, " ' " AND " "RequestNumber = " ' " is a bit of a mess, froma string literal point of view, and thats just for starters..

 

[Paszt]

Thanks cjard but I was in a roundabout way trying to say "give us more information" (to pierrewhy). You know, instead of saying "nothing work" tell us what happened. I thought this may get pierrewhy thinking about why it didn't work.

But thanks for the info.

 

[cjard]

Thanks cjard but I was in a roundabout way trying to say "give us more information" (to pierrewhy). You know, instead of saying "nothing work" tell us what happened. I thought this may get pierrewhy thinking about why it didn't work.

Good call..

I do this from time to time.. Like when someone says "I'm getting an error of "abc" is not a valid Integer - why?" I also normally tell them to go and think about it, cause put it one way; if the compiler is so clearly leading the donkey to the water and it doesnt want to drink, then sure as heck you or I wont succeed without a lot of work