我想实现每页显示一条搜索记录
共有10条
但现在 只能显示第一条，再单击下一条时 就出错了，提示System.Data.OleDb.OleDbException: 语法错误 (操作符丢失) 在查询表达式 'LIKE '%%'' 中。
。以下是我的源代码：
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
id="trsearchdata"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_dwconn") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_dwconn") %>'
Debug="false" PageSize="1" CurrentPage='<%# IIf((Request.QueryString("trsearchdata_CurrentPage") <> Nothing), Request.QueryString("trsearchdata_CurrentPage"), 0) %>'
></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<script runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
TrSearchData.CommandText="SELECT * FROM DWCP WHERE " _
&Trim(Request.QueryString("keyindex"))& " LIKE '%" _
&Trim(Request.QueryString("keyfield"))&"%' ORDER BY CPID ASC"
TrSearchData.Debug=true
End Sub
</script>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE1 {
font-family: "宋体";
font-weight: bold;
font-size: 16px;
color: #0000CC;
}
.STYLE6 {font-family: "宋体"; font-size: 12px; }
-->
</style>
<script type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
</head>
<body>
<form id="form1" name="form1" method="post" action="" runat="server">
<table width="960" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#999999"><p class="STYLE1">产品搜索结果</p></td>
</tr>
<tr>
<td><asp:DataList ID="searchlist"
runat="server"
RepeatColumns="1"
RepeatDirection="Vertical"
RepeatLayout="Table"
DataSource="<%# trsearchdata.DefaultView %>" >
<itemtemplate>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="150" rowspan="8"><img src=<%# "image/" + trsearchdata.FieldValue("CPID", Container)+".jpg" %> width="120" height="84" onClick="MM_openBrWindow('cpzl.aspx?cpid=<%# trsearchdata.FieldValue("CPID", Container) %>','','width=500,height=350')" /></td>
<td colspan="4" align="center" valign="middle"><span class="STYLE7">产品简介</span></td>
</tr>
<tr>
<td width="200" align="center" valign="middle"><span class="STYLE6">产品编号：</span></td>
<td width="200" align="center" valign="middle"><%# trsearchdata.FieldValue("CPID", Container) %></td>
<td width="200" align="center" valign="middle"><span class="STYLE6">产品名称：</span></td>
<td width="210" align="center" valign="middle"><%# trsearchdata.FieldValue("CPNAME", Container) %></td>
</tr>
<tr>
<td width="200" align="center" valign="middle"><span class="STYLE6">产品分类：</span></td>
<td width="200" align="center" valign="middle"><%# trsearchdata.FieldValue("CPFL", Container) %></td>
<td width="200" align="center" valign="middle"><span class="STYLE6">产品规格：</span></td>
<td width="210" align="center" valign="middle"><%# trsearchdata.FieldValue("CPCC", Container) %></td>
</tr>
<tr>
<td width="200" align="center" valign="middle"><span class="STYLE6">内箱：</span></td>
<td width="200" align="center" valign="middle"><%# trsearchdata.FieldValue("NX", Container) %></td>
<td width="200" align="center" valign="middle"><span class="STYLE6">毛重：</span></td>
<td width="210" align="center" valign="middle"><%# trsearchdata.FieldValue("MZ", Container) %></td>
</tr>
<tr>
<td width="200" align="center" valign="middle"><span class="STYLE6">净重：</span></td>
<td width="200" align="center" valign="middle"><%# trsearchdata.FieldValue("JZ", Container) %></td>
<td width="200" align="center" valign="middle"><span class="STYLE6">体积：</span></td>
<td width="210" align="center" valign="middle"><%# trsearchdata.FieldValue("TJ", Container) %></td>
</tr>
<tr>
<td width="200" align="center" valign="middle"><span class="STYLE6">材积：</span></td>
<td width="200" align="center" valign="middle"><%# trsearchdata.FieldValue("CJ", Container) %></td>
<td width="200" align="center" valign="middle"><span class="STYLE6">单价：</span></td>
<td width="210" align="center" valign="middle"><%# trsearchdata.FieldValue("CPDJ", Container) %></td>
</tr>
<tr>
<td width="200" height="3" align="center" valign="middle"><img src="image/buya.gif" width="34" height="15" onClick="MM_openBrWindow('cpby.aspx?cpid=<%# trsearchdata.FieldValue("CPID", Container) %>','bycp','scrollbars=yes,width=500,height=350')" /></td>
<td width="200" height="3" align="center" valign="middle"><img src="image/xiang.gif" width="34" height="15" onClick="MM_openBrWindow('cpzl.aspx?cpid=<%# trsearchdata.FieldValue("CPID", Container) %>','','width=500,height=350')" /></td>
<td width="200" height="3" align="center" valign="middle"> </td>
<td width="210" height="3" align="center" valign="middle"> </td>
</tr>
<tr>
<td width="200" height="2" align="center" valign="middle" bgcolor="#0066FF"> </td>
<td width="200" height="2" align="center" valign="middle" bgcolor="#0066FF"> </td>
<td width="200" height="2" align="center" valign="middle" bgcolor="#0066FF"> </td>
<td width="210" height="2" align="center" valign="middle" bgcolor="#0066FF"> </td>
</tr>
</table>
</itemtemplate>
</asp:DataList></td>
</tr>
<tr>
<td align="center" valign="middle">
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center"><MM:If runat="server" Expression='<%# (trsearchdata.CurrentPage <> 0) %>'>
<ContentsTemplate> <a href="<%# Request.ServerVariables("SCRIPT_NAME") %>?trsearchdata_currentPage=0">第一页</a> </ContentsTemplate>
</MM:If> </td>
<td width="31%" align="center"><MM:If runat="server" Expression='<%# (trsearchdata.CurrentPage <> 0) %>'>
<ContentsTemplate> <a href="<%# Request.ServerVariables("SCRIPT_NAME") %>?trsearchdata_currentPage=<%# Math.Max(trsearchdata.CurrentPage - 1, 0) %>">前一页</a> </ContentsTemplate>
</MM:If> </td>
<td width="23%" align="center"><MM:If runat="server" Expression='<%# (trsearchdata.CurrentPage < trsearchdata.LastPage) %>'>
<ContentsTemplate> <a href="<%# Request.ServerVariables("SCRIPT_NAME") %>?trsearchdata_currentPage=<%# Math.Min(trsearchdata.CurrentPage + 1, trsearchdata.LastPage) %>">下一页</a> </ContentsTemplate>
</MM:If> </td>
<td width="23%" align="center"><MM:If runat="server" Expression='<%# (trsearchdata.CurrentPage < trsearchdata.LastPage) %>'>
<ContentsTemplate> <a href="<%# Request.ServerVariables("SCRIPT_NAME") %>?trsearchdata_currentPage=<%# trsearchdata.LastPage %>">最后一页</a> </ContentsTemplate>
</MM:If> </td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
有高手指教啊 谢谢了
首页
搜索
用户列表
FAQ
注册
登录
