EDN Admin
Well-known member
Hello I am using the bindingsource.filter to filter all rows in a DataGridView according to user input...
I realize to filter all the rows according to an integer I use the command:
filterCommand = "FormID = " + 98;
This would filter out every single row that did not have the exact valueof 98 within the column of FormID...
However this is not the effect Im trying to achieve...
I want to filter all rows that START WITH the numbers 98, thus rows with the numbers <b>98</b>000201, <b>98</b>20302 would be shown as well.
How do I construct a filterstring to achieve this behaviour?
Thanks!
View the full article
I realize to filter all the rows according to an integer I use the command:
filterCommand = "FormID = " + 98;
This would filter out every single row that did not have the exact valueof 98 within the column of FormID...
However this is not the effect Im trying to achieve...
I want to filter all rows that START WITH the numbers 98, thus rows with the numbers <b>98</b>000201, <b>98</b>20302 would be shown as well.
How do I construct a filterstring to achieve this behaviour?
Thanks!
View the full article