快捷導(dǎo)航

Repeater全選刪除和分頁實(shí)現(xiàn)思路及代碼

更新時間：2013年03月14日 09:31:01 作者：

Repeater控件想必熟悉.net web開發(fā)的人員是很了解不過的了，接下來將與大家共同學(xué)習(xí)下它的全選刪除和分頁，感興趣的你可不要錯過了哈，希望可以幫助到你

 
<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>報(bào)到號</th><th>考生號</th><th>姓名</th><th>身份證號碼</th><th>家庭地址</th><th>類別</th><th>專業(yè)</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('確定要刪除嗎？該操作不可恢復(fù)?。?！')" /> 
<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";//這句在大型數(shù)據(jù)中應(yīng)該用：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 = ""; 
//先遍歷取得選中項(xiàng) 
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(); 
} 