快捷導(dǎo)航

asp.net repeater實現(xiàn)批量刪除

更新時間：2009年03月26日 01:52:38 作者：

asp.net repeater實現(xiàn)批量刪除實現(xiàn)效果代碼

詳細的代碼：
aspx頁面的body區(qū)域：

<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區(qū)域主要是一段按下“批量刪除”之后要處理的事件，就是上面的

代碼如下：

復(fù)制代碼代碼如下:

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("操作不可以恢復(fù)，確定當(dāng)前操作嗎？"); 
if(result){ 
return true; 
} 
}else{ 
alert("您還沒有選中項"); 
return false; 
} 
return false; 

} 

cs的全部代碼：

復(fù)制代碼代碼如下:

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(); 
} 
} 

//綁定數(shù)據(jù) 
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); 
} 


//這個是通用方法用于在公用類庫中調(diào)用 
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"); 
//將相應(yīng)的服務(wù)器控件的ClientId注冊到客戶端JavaScript數(shù)組 
cs.RegisterArrayDeclaration("cbxArray", String.Concat("'", cbx.ClientID, "'")); 
} 
} 
} 