C # Use & amp; quot; like "in the program to query access database queries that are empty

Today, we found a particularly strange problem during the development process: the like query in access is executed in the Access database and the query results can be found, which is executed in the database, select * fromKPProjwhereKpNamelike * test *, but the same statement is null in the c # program. What is the situation? This question

Today, we found a particularly strange problem during the development process: the like query in access is executed in the Access database and the query results can be found, which is executed in the database, select * from KPProj where KpName like '* test *', but the same statement is null in the c # program. What is the situation? This question

Today, we found a particularly strange problem during the development process: the like query in access is executed in the Access database and the query results can be found, which is executed in the database, select * from KPProj where KpName like '* test *', but the same statement is null in the c # program. What is the situation?

This problem is really tangled. through previous development experience, like in access needs to use the * number, but the standard % should be used in SQL Server oracle databases. Why can't this happen at this time? After searching for information, I found that the access driver was connected. Previously I used mdb, and the database was accdb. Then I used the win7 64-bit development system, because Access in my program uses the oledb driver, "*" cannot be used here, and "%" must be used ". If you use DAO to Access the Access database, you must use "*".

* Is not used in case of access, so it should be determined based on the actual driver;