请问一个sql语句like查询,但是没有返回结果的有关问题_Sql Server

请教一个sql语句like查询,但是没有返回结果的问题
现有一网站,数据不多,想做一个简单的搜索,就用sqldatasource和datalist作了一下,但是sql并没有返回结果,求教原因
比如我搜索"ah5"或"继电器",它都没有结果显示,但是数据表里的字段确实有我要搜的"ah5"或"继电器"关键词,
代码如下:

HTML code

<asp:SqlDataSource ID="SqlDataSource1" runat="server"             ConnectionString="<%$ ConnectionStrings:CKCCon %>"             SelectCommand="SELECT *　from Products WHERE [csProductName] like @csProductName　or [csSpecification] like @csProductName">            <SelectParameters>                <asp:QueryStringParameter Name="csProductName" QueryStringField="pd"                     Type="String" />            </SelectParameters>        </asp:SqlDataSource>    </div>    <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px"         AutoGenerateRows="False" DataSourceID="SqlDataSource1">        <Fields>            <asp:BoundField DataField="csProductName" HeaderText="csProductName"

------解决方案--------------------

HTML code

SELECT *　from Products WHERE [csProductName] like [email protected]%'　or [csSpecification] like [email protected]%'
------解决方案--------------------
SelectCommand="SELECT *　from Products WHERE [csProductName] like [email protected]%'　or [csSpecification] like [email protected]%'">

==>>

SelectCommand="SELECT *　from Products WHERE [csProductName] like '%" + @csProductName + "%'　or [csSpecification] like '%" + @csProductName + "%'">
------解决方案--------------------
SelectCommand="SELECT *　from Products WHERE [csProductName] like [email protected]+'%'　or [csSpecification] like [email protected]+'%'