<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet 
id="rs1stCatalogs"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_Habook") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_Habook") %>'
CommandText='<%# "SELECT *  FROM tCatalogs  ORDER BY CatalogID ASC" %>'
Debug="true"
></MM:DataSet>
<MM:DataSet 
id="rs2ndProducts"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_Habook") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_Habook") %>'
CommandText='<%# "SELECT *  FROM tProducts  WHERE (Name LIKE MMColParam)  or (BookNo LIKE MMColParam)  or (Detail LIKE MMColParam)  ORDER BY ProductID DESC" %>'
Debug="true"
>
  <Parameters>
<Parameter  Name="MMColParam"  Value='<%# "%" + (IIf((Request.QueryString("Keyin") <> Nothing), Request.QueryString("Keyin"), "")) + "%" %>'  Type="WChar"   /></Parameters></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />