<div>
SelectCommand=&quot;SELECT id, firstname, lastname, code, phone FROM dbo.Customers WHERE (firstname LIKE @firstname) OR (lastname LIKE @lastname)&quot;<br />
<br />
SelectCommand.Parameters.A<wbr />dd(&quot;@first<wbr />name&quot;, FirstName.Text + &nbsp;'%');<br />
SelectCommand.Parameters.A<wbr />dd(&quot;@lastn<wbr />ame&quot;, LastName.Text + '%');<br />
<br />
<br />
<br />
I think that might work.
</div>


SelectCommand="SELECT id, firstname, lastname, code, phone FROM dbo.Customers WHERE (firstname LIKE @firstname) OR (lastname LIKE @lastname)"

SelectCommand.Parameters.Add("@firstname", FirstName.Text +  '%');
SelectCommand.Parameters.Add("@lastname", LastName.Text + '%');



I think that might work.

<div>
No, there is no such method available.
</div>


<div>
And the '%' doesn't work even if I hardcode it using the SelectParameters collection.
</div>


And the '%' doesn't work even if I hardcode it using the SelectParameters collection.

<div>
If you use objectdatasource in 2.0 then you do something like this.<br />
<br />
&lt;asp:ControlParameter DefaultValue=&quot;%&quot; Name=&quot;firstname&quot; ControlID=&quot;Dropdownlist1&quot; Type=&quot;String&quot; /&gt;
</div>


If you use objectdatasource in 2.0 then you do something like this.

<asp:ControlParameter DefaultValue="%" Name="firstname" ControlID="Dropdownlist1" Type="String" />

<div>
<div class="content wysiwyg-content">
SelectCommand=&quot;SELECT id, firstname, lastname, code, phone FROM dbo.Customers WHERE (firstname LIKE @firstname '%') OR (lastname LIKE @lastname)&quot;<br />
<br />
I need to be able to look up Firstnames and lastnames using the Like% clause ( text/wildcard ). How can I implement this wit the command paramters in ASP.NET?
</div>
</div>


SelectCommand="SELECT id, firstname, lastname, code, phone FROM dbo.Customers WHERE (firstname LIKE @firstname '%') OR (lastname LIKE @lastname)"

I need to be able to look up Firstnames and lastnames using the Like% clause ( text/wildcard ). How can I implement this wit the command paramters in ASP.NET?

SQL LIKE Clause With CommandParamters in ASP.NET

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications