How to write select SQL to use like when using control parameter?
<ol>
<li>How to change to use like instead of = ?</li>
</ol>

<p>([Card_no] = @Search)</p>

<ol>
<li><p>Moreover, if i want to show all in default, this method force to user to type 
something first. How to show all in default when using control parameter?</p>

<p>

<pre><code>SelectCommand="SELECT [Serial_no], [Transaction_Date], [Card_no], [Company],[IsCredit], [Fee] FROM [CarPark] WHERE ([Card_no] = @Search) or ([Company] = @Search)"
UpdateCommand="UPDATE [CarPark] SET
Card_no=@Card_no,
Company=@Company, 
IsCredit=@IsCredit,
Fee=@Fee
WHERE Serial_no=@Serial_no"&gt;
&lt;UpdateParameters&gt;
    &lt;asp:Parameter Name="Card_no" Type="String" /&gt;
    &lt;asp:Parameter Name="Company" Type="String" /&gt;
    &lt;asp:Parameter Name="IsCredit" Type="Boolean" /&gt;
        &lt;asp:Parameter Name="Fee" Type="Double" /&gt;
    &lt;/UpdateParameters&gt;
    &lt;SelectParameters&gt;
    &lt;asp:ControlParameter ControlID="Search_TextBox" DefaultValue="" Name="Search" 
            PropertyName="Text" Type="String" /&gt;
&lt;/SelectParameters&gt;    
</code></pre>

<p></p></li>
</ol>
