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