Repeater select delete and pagination implementation ideas and code

  • 2020-05-27 04:45:34
  • OfStack

 
<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)"/> Future generations </th><th> To report for duty, </th><th> The examinee, </th><th> The name </th><th> Id card number </th><th> Home address </th><th> category </th><th> professional </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=" Batch delete " OnClientClick="return confirm(' Are you sure you want to delete it? This operation is not recoverable!! ')" /> 
<br /> 
<br /> 
<webdiyer:AspNetPager ID="benren" runat="server" pagesize="2" 
CssClass="anpager" onpagechanged="AspNetPager1_PageChanged" 
FirstPageText=" Home page " LastPageText=" back " NextPageText=" Under the 1 page " PrevPageText=" on 1 page " 
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";// This sentence should be used in large data sets: select top The query  
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 = ""; 
// Let's go through to get the selected item  
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 + ","; 
} 
} 
} 
// Get rid of the last 1 a , 
delId = (delId + ")").Replace(",)", ""); 
//Response.Write(" The deleted statement is: delete news_sosuo8_ where id_news_ in(" + delId + ")"); 
// Write your own delete statements  
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(' Deleted successfully! ');</script>"); 
} 
BindData(); 
} 

Related articles: