我想用模糊查询,可是当输入一个字的时候Dropdownlist里不会显示我想要查询的信息,输入两个字就可以了,这是什么原因啊?如何只输入一个字就能进行模糊查询呢?我写的语句如下:
string sql = "select Caption+'----'+Name as 负责人 from Auth_TB_Operator where Caption like '"+str+"'";
string sql = "select Caption+'----'+Name as 负责人 from Auth_TB_Operator where Caption like '"+str+"'";
string sql = "select Caption+'----'+Name as 负责人 from Auth_TB_Operator where Caption like '%"+str+"%'";
如下不知是否可行
string sql = "select Caption+'----'+Name as 负责人 from Auth_TB_Operator where Caption like '"+str+"%'";
like '%"+str+"%'";
如果你想查询以某个字为开头的就不要第一个%