S
Sin Jeong-hun
I have an .MDB which has a table, and let VS.NET generate all the
necessary classes for my DataGridView. Now, I want to filter the rows
on user's requests. I could simply use .Filter property, like
..Filter = "ColumnName ='%" + keyword + "%'";
But come to think of it, the keyword, which is input by users, could
contain characters like ', % or whatever special characters that the
Filter method uses. Do I need to manually escape special characters
for BindingSource.Filter? As told before I should not reinvent the
wheel, if there already is a method for this, I would like to use
that. Escaping special characters should be required for all
applications like this so I thought there probably be a method. I
tried to find a method like that would do that, but couldn't find any.
Would you please give me an advice?
necessary classes for my DataGridView. Now, I want to filter the rows
on user's requests. I could simply use .Filter property, like
..Filter = "ColumnName ='%" + keyword + "%'";
But come to think of it, the keyword, which is input by users, could
contain characters like ', % or whatever special characters that the
Filter method uses. Do I need to manually escape special characters
for BindingSource.Filter? As told before I should not reinvent the
wheel, if there already is a method for this, I would like to use
that. Escaping special characters should be required for all
applications like this so I thought there probably be a method. I
tried to find a method like that would do that, but couldn't find any.
Would you please give me an advice?