CODEWITHSUNDEEP
asp.net
aspfans002
aspfans002

Reputation: 1

How to write select SQL to use like when using control parameter?

  1. How to change to use like instead of = ?

([Card_no] = @Search)

  1. 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?

    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">
<UpdateParameters>
    <asp:Parameter Name="Card_no" Type="String" />
    <asp:Parameter Name="Company" Type="String" />
    <asp:Parameter Name="IsCredit" Type="Boolean" />
        <asp:Parameter Name="Fee" Type="Double" />
    </UpdateParameters>
    <SelectParameters>
    <asp:ControlParameter ControlID="Search_TextBox" DefaultValue="" Name="Search" 
            PropertyName="Text" Type="String" />
</SelectParameters>

Upvotes: 0

Views: 745

Answers (1)

Malk
Malk

Reputation: 12003

Try this:

Card_no like '%{0}%'

Or if you must use named parameters:

Card_no like '%'+@search +'%'

Upvotes: 1

Related Questions