请问OleDB如何实现带参数的模糊查询

Question

代码大概如下OleDbParameter[] parameters ={
                new OleDbParameter("number",context.Request["str"].ToString())
                              };
            
OleDbDataReader dr=OleDBHelper.ExecuteSQLDataReader("select BI05,BI04 from CQ_BGY_INFO where BI05 like ?"+"%", parameters);
?相等于@number，通用的工具写死了，只能用OleDB访问
把%换成*也无效不能用字符串拼接

Answer 1

OleDbParameter[] parameters ={
                new OleDbParameter("@number",context.Request["str"].ToString())
                              };
            
OleDbDataReader dr=OleDBHelper.ExecuteSQLDataReader("select BI05,BI04 from CQ_BGY_INFO where BI05 like '*@number*'", parameters);

Answer 2

OleDbParameter[] parameters ={
                new OleDbParameter("number",context.Request["str"].ToString())
                              };
在这里面写%* 

Answer 3

问题解决OleDbParameter[] parameters ={
                new OleDbParameter("number",context.Request["str"].ToString()+"%")
                              };
            
OleDbDataReader dr=OleDBHelper.ExecuteSQLDataReader("select BI05,BI04 from CQ_BGY_INFO where BI05 like ?", parameters);

Answer 4

OleDbParameter[] parameters ={
                new OleDbParameter("number",context.Request["str"].ToString()+"%")
                              };
            
OleDbDataReader dr=OleDBHelper.ExecuteSQLDataReader("select BI05,BI04 from CQ_BGY_INFO where BI05 like ?", parameters);