Cannot perform 'Like' operation on System.Int32 and System.String.

Question

1.00/5 (1 vote)

See more:

XML

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Highlight the Search Keywords in Gridview </title>
<style type="text/css">
.GridviewDiv {font-size: 100%; font-family: 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Arial, Helevetica, sans-serif; color: #303933;}
Table.Gridview{border:solid 1px #df5015;}
.Gridview th{color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;padding:0.5em 0.5em 0.5em 0.5em;text-align:center}
.Gridview td{border-bottom-color:#f0f2da;border-right-color:#f0f2da;padding:0.5em 0.5em 0.5em 0.5em;}
.Gridview tr{color: Black; background-color: White; text-align:left}
:link,:visited { color: #DF4F13; text-decoration:none }
.highlight {text-decoration: none;color:black;background:yellow;}
</style>
</head>
<body>
<form id="form1" runat="server">
<div class="GridviewDiv">
<p>
Enter UserName :
<asp:TextBox ID="txtSearch" runat="server"  />&nbsp;&nbsp;
<asp:ImageButton ID="btnSearch" ImageUrl="~/SearchButton.png" runat="server"
Style="top: 5px; position: relative" onclick="btnSearch_Click" />&nbsp;&nbsp;
<asp:ImageButton ID="btnClear" ImageUrl="~/Clearbutton.png" runat="server" Style="top: 5px;
position: relative" onclick="btnClear_Click" /><br />
<br />
</p>
<asp:GridView ID="gvDetails" runat="server" AutoGenerateColumns="False" AllowPaging="True"
AllowSorting="True" DataSourceID="dsDetails" Width="540px" CssClass="Gridview"
            DataKeyNames="voucherID" >
<HeaderStyle BackColor="#df5015" />
<Columns>
    <asp:BoundField DataField="voucherID" HeaderText="voucherID" InsertVisible="False"
        ReadOnly="True" SortExpression="voucherID" />
    <asp:BoundField DataField="voucher" HeaderText="voucher"
        SortExpression="voucher" />
    <asp:BoundField DataField="RS" HeaderText="RS"
        SortExpression="RS" />
    <asp:BoundField DataField="CPoints" HeaderText="CPoints"
        SortExpression="CPoints" />
    <asp:BoundField DataField="Datec" HeaderText="Datec" SortExpression="Datec" />
</Columns>
</asp:GridView>
</div>

<asp:AccessDataSource ID="dsDetails" runat="server"
        DataFile="~/App_Data/DatabasePCG03.mdb"
        SelectCommand="SELECT * FROM [coupen]"

        FilterExpression="voucherID LIKE '%{0}%' OR voucher LIKE '%{0}%' OR RS LIKE '%{0}%'OR CPoints LIKE '%{0}%'OR Datec LIKE '%{0}%'">
<FilterParameters>
<asp:ControlParameter Name="voucherID" ControlID="txtSearch" PropertyName="Text" />
<asp:ControlParameter Name="voucher" ControlID="txtSearch" PropertyName="Text" />
<asp:ControlParameter Name="RS" ControlID="txtSearch" PropertyName="Text" />
<asp:ControlParameter Name="CPoints" ControlID="txtSearch" PropertyName="Text" />
<asp:ControlParameter Name="Datec" ControlID="txtSearch" PropertyName="Text" />

</FilterParameters>
</asp:AccessDataSource>
</form>
</body>
</html>

Posted 1-Apr-13 1:48am

Amirsalgar1

Add a Solution

Comments

[no name] 1-Apr-13 8:19am

What is your actual need and where you got stuck is not mentioned there. Please be very specific in your question.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RajeshRaushan · Answer 1 · 2013-04-01T02:36:00

Solution 1

LIKE you shouldn't be doing with integer values. Can you check if putting white-space before OR condition helps with this. I can see at two places you have missed it(RS LIKE '%{0}%'OR CPoints LIKE '%{0}%'OR Datec).

voucherID LIKE '%{0}%' OR voucher LIKE '%{0}%' OR RS LIKE '%{0}%' OR CPoints LIKE '%{0}%' OR Datec LIKE '%{0}%'

Posted 1-Apr-13 2:36am

RajeshRaushan

Comments

Amirsalgar1 1-Apr-13 8:52am

thanks for reply sir ,
what should i do if i want to filter integer value ?

Dave Kreskowiak · Answer 2 · 2013-04-01T02:51:00

Solution 2

The LIKE expression only works on strings and string columns. You can't use an integer or numeric column with LIKE, well, unless you convert the number involved to a string.

Posted 1-Apr-13 2:51am

Dave Kreskowiak

Comments

RajeshRaushan 1-Apr-13 9:04am

This is correct: You can do something like following using CAST function - assuming RS is an integer column.

CAST(RS as varchar(10)) LIKE '%{0}%'