Repeater实现批量删除代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】 Repeater实现批量删除
作者:Dezai.CN / 发布于2013/1/17/ 903
aspx页面的body区域：

<body> 
<form id="form1" runat="server"> 
<div> 
 
</div> 
<asp:Repeater ID="rptNews" runat="server" onprerender="rptNews_PreRender"> 
<HeaderTemplate> 
<table border="1"> 
<tr> 
<th>选择</th> 
<th>id</th> 
<th>标题</th> 
</tr> 
</HeaderTemplate> 
<ItemTemplate> 
<tr> 
<td><asp:CheckBox ID="cbx" runat="server" /></td> 
<td><asp:Label id="lbl" Text='<%#Eval("id_news_") %>' runat="server" ></asp:Label></td> 
<td><%#Eval("title_news_") %></td> 
</tr> 
</ItemTemplate> 
<FooterTemplate> 
</table> 
</FooterTemplate> 
</asp:Repeater> 
<asp:Button ID="btnDel" runat="server" onclick="btnDel_Click" Text="批量删除" OnClientClick="return delIt()" /> 
</form> 
</body> 


head区域JS代码：

主要是按下“批量删除”之后要判断是否有选中了Repeater中的CheckBox，就是上面按钮中的

OnClientClick="return delIt()"


function delIt() 
{ 
var cbxBool = 0; 
for(var i = 0;i < cbxArray.length;i++){ 
var obj = document.getElementById(cbxArray[i]); 
if(obj.checked == true){ 
cbxBool = 1; 
break; 
} 
} 
 
if(cbxBool == 1){ 
var result = confirm("操作不可以恢复，确定当前操作吗？"); 
if(result){ 
return true; 
} 
}else{ 
alert("您还没有选中项"); 
return false; 
} 
return false; 
 
} 


.cs的全部代码：

using System; 
using System.Configuration; 
using System.Data; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.HtmlControls; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Data.SqlClient; 
 
public partial class _Default : System.Web.UI.Page 
{ 
protected void Page_Load(object sender, EventArgs e) 
{ 
if (!Page.IsPostBack) 
{ 
bind(); 
} 
} 
 
//绑定数据 
private void bind() 
{ 
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ToString()); 
conn.Open(); 
DataSet ds = new DataSet(); 
SqlDataAdapter da = new SqlDataAdapter("select top 10 id_news_,title_news_ from news_sosuo8_", conn); 
da.Fill(ds); 
this.rptNews.DataSource = ds; //绑定dataset 
this.rptNews.DataBind();//开始绑定 
conn.Close(); 
 
} 
 
protected void btnDel_Click(object sender, EventArgs e) 
{ 
string delId = ""; 
//先遍历取得选中项 
for (int i = 0; i < this.rptNews.Items.Count; i++) 
{ 
CheckBox cbx = (CheckBox)rptNews.Items[i].FindControl("cbx"); 
Label lbl = (Label)rptNews.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 + ")"); 
//自己写删除语句吧 
bind(); 
} 
 
 
protected void rptNews_PreRender(object sender, EventArgs e) 
{ 
prerepater(rptNews, this); 
} 
 
 
//这个是通用方法用于在公用类库中调用 
public static void prerepater(Repeater repeater, System.Web.UI.Page page) 
{ 
ClientScriptManager cs = page.ClientScript; 
for (int i = 0; i < repeater.Items.Count; i++) 
{ 
CheckBox cbx = (CheckBox)repeater.Items[i].FindControl("cbx"); 
//将相应的服务器控件的ClientId注册到客户端JavaScript数组 
cs.RegisterArrayDeclaration("cbxArray", String.Concat("'", cbx.ClientID, "'")); 
} 
} 
}
试试其它关键字
　批量删除　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)