"select * from Produceprice where procatalog like '%@keyword%' AND protype like @type AND proprice > @start and proprice < @end"是不是第二个条件掉了%
---->"select * from Produceprice where procatalog like '%@keyword%' AND protype like '%@type%' AND proprice > @start and proprice < @end"
---->"select * from Produceprice where procatalog like '%@keyword%' AND protype like '%@type%' AND proprice > @start and proprice < @end"
like '%@keyword%'应该这样写
like @keywordselect * from Produceprice where procatalog like @keyword AND protype = @type AND proprice > @start and proprice < @end
strkeyword="%"+strkeyword+"%";
dadnew.SelectCommand.Parameters.Add("@keyword", strkeyword);