Repeater控件使用(含删除,分页功能)
以SQL SERVER2000自带数据库Northwind中Customers表示例.
前台aspx代以码:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Repeater.aspx.cs" Inherits="Repeater" %>
<!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 runat="server"> <title>Repeater控件使用</title> <script language="javascript" type="text/javascript">
function Check(parentChk,ChildId)
{ var oElements = document.getElementsByTagName("INPUT"); var bIsChecked = parentChk.checked; for(i=0; i<oElements.length;i++) { if( IsCheckBox(oElements[i]) && IsMatch(oElements[i].id, ChildId)) { oElements[i].checked = bIsChecked;
} } } function IsMatch(id, ChildId) { var sPattern =’^Repeater1.*’+ChildId+’$'; var oRegExp = new RegExp(sPattern); if(oRegExp.exec(id)) return true; else return false; } function IsCheckBox(chk) { if(chk.type == 'checkbox') return true; else return false; }
</script></head><body> <form id="form1" runat="server"> <div style="margin-bottom:20px;text-align:center; width:1006px;">Repeater控件使用</div><asp:Repeater ID="Repeater1" runat="server"> <%--SeparatorTemplate描述一个介于每条记录之间的分隔符--%> <%--<SeparatorTemplate> <tr> <td colspan="5"><hr /></td> </tr> </SeparatorTemplate>--%> <HeaderTemplate> <table border="1" cellpadding="0" cellspacing="0" style="width:1006px;border-collapse:collapse; text-align:center;"> <tr> <td style="background-color:#cccccc; font-weight:bold; height:25px;"><input id="chkAll" name="chkAll" runat="server" type="checkbox" onclick="Check(this,’chkItem')" title="全选" />全</td> <td style="background-color:#cccccc; font-weight:bold; height:25px;">View</td> <td style="background-color:#cccccc; font-weight:bold; height:25px;">CustomerID</td> <td style="background-color:#cccccc; font-weight:bold;">CompanyName</td> <td style="background-color:#cccccc; font-weight:bold;">ContactName</td> <td style="background-color:#cccccc; font-weight:bold;">ContactTitle</td> <td style="background-color:#cccccc; font-weight:bold;">Address</td> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td><asp:CheckBox ID="chkItem" runat="server" /></td> <td><a href='<%# "View.aspx?id="+DataBinder.Eval(Container.DataItem, "CustomerID") %>' target="_blank">View</a></td> <td><asp:Label ID="lblID" Text='<%# DataBinder.Eval(Container.DataItem, "CustomerID")%>' runat="server"></asp:Label></td> <td><%# DataBinder.Eval(Container.DataItem, "CompanyName")%></td> <td><%# DataBinder.Eval(Container.DataItem, "ContactName")%></td> <td><%# DataBinder.Eval(Container.DataItem, "ContactTitle")%></td> <td><%# DataBinder.Eval(Container.DataItem, "Address")%></td> </tr> </ItemTemplate> <%--AlternatingItemTemplate描述交替输出行的另一种外观--%> <AlternatingItemTemplate> <tr bgcolor="#e8e8e8"> <td><asp:CheckBox ID="chkItem" runat="server" /></td> <td><a href='<%# "View.aspx?id="+DataBinder.Eval(Container.DataItem, "CustomerID") %>' target="_blank">View</a></td> <td><asp:Label ID="lblID" Text='<%# DataBinder.Eval(Container.DataItem, "CustomerID")%>' runat="server"></asp:Label></td> <td><%# DataBinder.Eval(Container.DataItem, "CompanyName")%></td> <td><%# DataBinder.Eval(Container.DataItem, "ContactName")%></td> <td><%# DataBinder.Eval(Container.DataItem, "ContactTitle")%></td> <td><%# DataBinder.Eval(Container.DataItem, "Address")%></td> </tr> </AlternatingItemTemplate> <FooterTemplate> </table> </FooterTemplate></asp:Repeater><div style="background-color:#dedede; width:1006px;"> <asp:Button ID="btnDel" runat="server" Text="删除" OnClick="btnDel_Click" /> <asp:label ID="lblCurrentPage" runat="server"></asp:label> <asp:HyperLink id="lnkFrist" runat="server">首页</asp:HyperLink> <asp:HyperLink id="lnkPrev" runat="server">上一页</asp:HyperLink> <asp:HyperLink id="lnkNext" runat="server">下一页</asp:HyperLink> <asp:HyperLink id="lnkEnd" runat="server">尾页</asp:HyperLink></div> </form></body></html>后台CS部分代码:
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class Repeater : System.Web.UI.Page{ PagedDataSource PDS = new PagedDataSource(); private string ConnStr = ConfigurationManager.AppSettings["dbConnectionString"]; private string strsql = ""; protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { this.bind(); } } private void bind() { int TotalCount = 0;//总记录数 int TotalPage = 1; //总页数 SqlConnection conn = new SqlConnection(ConnStr); conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select CustomerID,CompanyName,ContactName,ContactTitle,Address from Customers order by CustomerID desc", conn); DataSet ds = new DataSet(); da.Fill(ds, "Customers"); DataView dv = ds.Tables[0].DefaultView; TotalCount = dv.Count; PDS.DataSource = dv; conn.Close(); PDS.AllowPaging = true; PDS.PageSize = 20; int CurPage; if (Request.QueryString["Page"] != null) CurPage=Convert.ToInt32(Request.QueryString["Page"]); else CurPage=1; if (TotalCount == 0) TotalPage = 1; else { if (TotalCount % PDS.PageSize == 0) TotalPage = TotalCount / PDS.PageSize; else TotalPage = TotalCount / PDS.PageSize + 1; } PDS.CurrentPageIndex = CurPage-1; lblCurrentPage.Text = "共" + TotalCount.ToString() + "条记录 当前页：" + CurPage.ToString() + "/" + TotalPage; lnkFrist.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1"; if (!PDS.IsFirstPage) lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage – 1); if (!PDS.IsLastPage) lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); lnkEnd.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TotalPage; Repeater1.DataSource=PDS; Repeater1.DataBind(); } protected void btnDel_Click(object sender, EventArgs e) { string ID = ""; for (int i = 0; i < this.Repeater1.Items.Count; i++) { CheckBox cbox = (CheckBox)this.Repeater1.Items[i].FindControl("chkItem"); if (cbox.Checked == true) { if (ID == "") { ID = "'"+((Label)this.Repeater1.Items[i].FindControl("lblID")).Text+"'"; } else { ID += "," + "'" + ((Label)this.Repeater1.Items[i].FindControl("lblID")).Text + "'"; } } } strsql = "delete from Customers where CustomerID in (" + ID + ")"; try { SqlConnection conn = new SqlConnection(ConnStr); SqlCommand comm = new SqlCommand(strsql, conn); comm.Connection.Open(); comm.ExecuteNonQuery(); comm.Connection.Close(); System.Web.HttpContext.Current.Response.Write("<script language=’javascript'>alert('刪除成功!');</script>"); } catch (System.Data.SqlClient.SqlException E) { throw new Exception(E.Message); } finally { if (conn.State == ConnectionState.Open) conn.Close(); } this.bind(); }}