如果是access 就用这个SQLHELPER http://hi.csdn.net/link.php?url=http://blog.csdn.net/zzxap
如果是MSSQL 就用这个sqlhelper http://www.cnblogs.com/zzxap/archive/2009/11/05/1596773.html
前台 如果你用的是 gridview 就把Repeater替换成gridview 。一样的。。
<form id="frm01" action="" method="post" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div id="center-top" > <div class="fon">中间1</div> </div>
<div id="center-content_Default2" >
<asp:Repeater runat="server" Id="mainlist" >
<ItemTemplate>
<div id="pic-out" >
<li class="pic-a" > Eval("product_type").ToString() </li>
<li class="pic-b" >Eval("product_desc").ToString() </li>
<li>价格<%#Eval("price")%> </li>
</div>
</ItemTemplate>
</asp:Repeater>
</div>
<div style="PADDING-TOP:10px; text-align:center" mce_style="PADDING-TOP:10px; text-align:center" >
共<asp:label id="LPageCount" ForeColor="#ff0000" Runat="server"></asp:label>页
<asp:label id="LTotalCount" ForeColor="#ff0000" Runat="server"></asp:label>条记录
<asp:linkbutton id="Fistpage" Runat="server" CommandName="0" OnClick="Pager_Click">首頁</asp:linkbutton>
<asp:linkbutton id="Prevpage" Runat="server" CommandName="prev" OnClick="Pager_Click">上一頁</asp:linkbutton>
<asp:linkbutton id="Nextpage" Runat="serv
