sql 语句的错误 模糊查询

个人觉得不是string的问题，而是like后面应该加一个空格
正确的写法：
string sql = "select * from Enter where Enter_name like '%" + Enter_name_input.Text.ToString().Trim() + "%'"
如果是文本框的话必须加上Text，才能获取文本。

string sql = "select * from Enter where Enter_name like'%" + Enter_name_input.ToString().Trim() + "%'";
=》SQL数据库
string sql = "select * from Enter where Enter_name like'%" +Trim (Enter_name_input.ToString()) + "%'";
=》ACCESS数据库
string sql = "select * from Enter where Enter_name like'*" + Trim(Enter_name_input.ToString()) + "*'";

应该是你Enter_name_input.ToString().Trim() 里的字符串有问题