string queryString = "SELECT [movie].* FROM [movie] WHERE ([movie].[showname] like +'%'@showname+'%'); 这个样子吗,不行啊,提示这样写就出错了
string queryString = "SELECT [movie].* FROM [movie] WHERE ([movie].[showname] like "+"%"+showname+"%";
string queryString = "SELECT [movie].* FROM [movie] WHERE ([movie].[showname] like "+"%"+@showname+"%";
不好意思,搞错了,下面的代码试验通过: OleDbDataAdapter daa=new OleDbDataAdapter("select * from 表1 where a like '%'+@abc+'%'",this.oleDbConnection1); daa.SelectCommand.Parameters.Add(new OleDbParameter("@abc","b")); DataSet ds=new DataSet(); daa.Fill(ds,"abc"); this.dataGrid1.DataSource=ds; this.dataGrid1.DataMember="abc";
如果要查找包含的,要前面也加上 %, %ab%
这个样子吗,不行啊,提示这样写就出错了
OleDbDataAdapter daa=new OleDbDataAdapter("select * from 表1 where a like '%'+@abc+'%'",this.oleDbConnection1);
daa.SelectCommand.Parameters.Add(new OleDbParameter("@abc","b"));
DataSet ds=new DataSet();
daa.Fill(ds,"abc");
this.dataGrid1.DataSource=ds;
this.dataGrid1.DataMember="abc";