无法在System.Int32和System.String上执行“Like”操作。

本文介绍了无法在System.Int32和System.String上执行“Like”操作。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

<%@ 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>

Int32和System

无法在System.Int32和System.String上执行“Like”操作。

问题描述

推荐答案