BindingSource question, help me
-
Hi, I want to filter the productID that starts with "MDF", so I use
bindingsource1.filter = "productID like 'NAPLE 5'-02'"(look like sql query), but it's not working. After that I corrected bindingsource1.filter =bindingsource1.filter ="productID like 'NAPLE 5%-02'", it's also not working and appear error "The expression contains an invalid string constant:'. " Somebody could correct the code will be appreciated. Thanks in advance.It seem to be a solution or an answer.
-
Hi, I want to filter the productID that starts with "MDF", so I use
bindingsource1.filter = "productID like 'NAPLE 5'-02'"(look like sql query), but it's not working. After that I corrected bindingsource1.filter =bindingsource1.filter ="productID like 'NAPLE 5%-02'", it's also not working and appear error "The expression contains an invalid string constant:'. " Somebody could correct the code will be appreciated. Thanks in advance.It seem to be a solution or an answer.
phantanagu wrote:
I want to filter the productID that starts with "MDF"
for what ur saying here it should be something like this, I think.. bindingsource1.Filter = "ProductID LIKE 'MDF%'";
phantanagu wrote:
bindingsource1.filter = "productID like 'NAPLE 5'-02'"
What ur trying to do here is a ? for me hope it helps Rocky