c# Help joining textbox value, LIKE and a string variable

Question

Hi all,

What is wrong with my line below?

table.DefaultView.RowFilter = cmbBox.Text + 'LIKE' + strName";

The line below works fine but is obviously no use.

table.DefaultView.RowFilter = 'FirstName LIKE James';

Thanks

Answer 1

It could be a problem with spacing

table.DefaultView.RowFilter = cmbBox.Text + " LIKE " + strName;

Answer 2

For one, when you do it that way, you aren't adding spaces.

Also, please don't do this for SQL queries if you are. This leaves you open to sql injection attacks (in the web world). Learn parameterized SQL at the very least. If you already know this, please ignore.

Answer 3

Seems as if you are missing the wildcards?

table.DefaultView.RowFilter = cmbBox.Text + " LIKE '%" + strName + "%'";