Repeater全选删除和分页实现思路及代码

时间:2022-03-26 03:58:46

代码如下:


<script type="text/javascript"> 
function SelectAll(box) 

for(var i=0;i <document.form1.elements.length;i++) 

var e=document.form1.elements[i]; 
if((e.type=='checkbox')) 

var o=e.name.lastIndexOf('cbx'); 
if(o!=-1) 

e.checked=box.checked; 




</script> 
<body> 
<form id="form1" runat="server"> 
<div> 
</div> 
<asp:Repeater ID="Repeater1" runat="server"> 
<HeaderTemplate> 
<table> 
<tr><th><input id= "chkHeader" type= "checkbox" onclick= "SelectAll(this)"/>全选</th><th>报到号</th><th>考生号</th><th>姓名</th><th>身份证号码</th><th>家庭地址</th><th>类别</th><th>专业</th></tr> 
</HeaderTemplate> 
<ItemTemplate> 
<tr><td align="center" ><asp:CheckBox ID="cbx" runat="server" /></td><td><asp:Label id="lbl" Text='<%#Eval("id") %>' runat="server" ></asp:Label></td><td><%#Eval("ksh") %></td><td><%#Eval("xm") %></td><td><%#Eval("sfzh") %></td><td><%#Eval("jtdz") %></td><td><%#Eval("jhxzmc") %></td><td><%#Eval("lqzy") %></td></tr> 
</ItemTemplate> 
<FooterTemplate> 
</table> 
</FooterTemplate> 
</asp:Repeater> 
<br /> 
<asp:Button ID="btnDel" runat="server" onclick="btnDel_Click" Text="批量删除" OnClientClick="return confirm('确定要删除吗?该操作不可恢复!!!')" /> 
<br /> 
<br /> 
<webdiyer:AspNetPager ID="benren" runat="server" pagesize="2" 
CssClass="anpager" onpagechanged="AspNetPager1_PageChanged" 
FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页" 
ShowMoreButtons="False" ShowPageIndexBox="Never" AlwaysShow="True"> 
</webdiyer:AspNetPager> 
</form> 
</body> 
================== 
protected void Page_Load(object sender, EventArgs e) 

if (!IsPostBack) 

string username = Session["username"].ToString(); 
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["shan"].ConnectionString); 
conn.Open(); 
SqlCommand count = new SqlCommand("select count(*) from do.so where baosongren = '"+username+"'", conn); 
benren.RecordCount = (int)count.ExecuteScalar(); 
conn.Close(); 
BindData(); 


public void BindData() 

string username = Session["username"].ToString(); 
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["shnn"].ConnectionString); 
string sql = "select * from dao where baosongren = '"+username+"' order by ID desc";//这句在大型数据中应该用:select top查询语句 
SqlDataAdapter da = new SqlDataAdapter(sql, conn); 
DataSet ds = new DataSet(); 
da.Fill(ds, benren.PageSize * (benren.CurrentPageIndex - 1), benren.PageSize, "temptbl"); 
DataTable dt = ds.Tables["temptbl"]; 
Repeater1.DataSource = dt; 
Repeater1.DataBind(); 

protected void AspNetPager1_PageChanged(object src, EventArgs e) 

//AspNetPager1.CurrentPageIndex = e.NewPageIndex; 
BindData(); 

protected void btnDel_Click(object sender, EventArgs e) 

string delId = ""; 
//先遍历取得选中项 
for (int i = 0; i < this.Repeater1.Items.Count; i++) 

CheckBox cbx = (CheckBox)Repeater1.Items[i].FindControl("cbx"); 
Label lbl = (Label)Repeater1.Items[i].FindControl("lbl"); 
if (cbx != null) 

if (cbx.Checked) 

delId += lbl.Text + ","; 



//去掉最后一个, 
delId = (delId + ")").Replace(",)", ""); 
//Response.Write("删除的语句是:delete news_sosuo8_ where id_news_ in(" + delId + ")"); 
//自己写删除语句吧 
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["shann"].ConnectionString); 
SqlCommand del = new SqlCommand("delete so where id in(" + delId + ")", conn); 
conn.Open(); 
int myupdate = del.ExecuteNonQuery(); 
conn.Close(); 
if (myupdate > 0) 

Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript'>alert('删除成功!');</script>"); 

BindData();