Repeater + CheckBox 的问题?

Question

主键绑定到id上<asp:CheckBox ID="<%#Eval("id")%>" runat="server"> </asp:CheckBox>

Answer 1

可以用隐藏的标签记录键值<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
    <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text='<%# Eval("productid") %>' Visible="false"></asp:Label>
        <asp:Label ID="Label2" runat="server" Text='<%# Eval("productname") %>'></asp:Label>
        <asp:CheckBox ID="CheckBox1" runat="server" />
        <br />
    </ItemTemplate>
</asp:Repeater>
<br />
<asp:Button ID="Button1" runat="server" Text="删除" OnClick="Button1_Click" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=.\sqlexpress;Initial Catalog=Northwind;Integrated Security=True" ProviderName="System.Data.SqlClient" SelectCommand="select productid, productname from products"></asp:SqlDataSource>protected void Button1_Click(object sender, EventArgs e)
{
    CheckBox chk;
    foreach (RepeaterItem item in Repeater1.Items)
    {
        chk = item.FindControl("CheckBox1") as CheckBox;
        if (chk != null && chk.Checked)
        {
            Response.Write(((Label)(item.FindControl("Label1"))).Text);
        }
    }
}

Answer 2

Response.Write(((Label)(item.FindControl("Label1"))).Text);SQL = "delete from Mac_Product where ID in('我如何将Lablel1中的ID值,全部记录在这里呢') "

Answer 3

HTML Code <asp:Repeater ID="Repeater1" runat="server"> 
<ItemTemplate> 
    <tr bgcolor="#FFFFFF"> 
      <td align="center">&nbsp; </td> 
      <td height="30" align="center"> <%# ReplaceOut(Eval("RefNo").ToString())%> </td> 
      <td align="center">&nbsp; </td> 
      <td align="center">&nbsp; </td> 
      <td align="center">&nbsp; </td> 
      <td align="center">&nbsp; </td> 
      <td align="center"> <input type="chkbox" name="mychk" values="<%#Eval("id")%>" /> </td> 
    </tr> 
</ItemTemplate> 
</asp:Repeater> C# Code response.write(request.form["mychk"]);

Answer 4

如果你的id在数据库里是数字类型protected void Button1_Click(object sender, EventArgs e)
{
    string idList = string.Empty;
    CheckBox chk;
    foreach (RepeaterItem item in Repeater1.Items)
    {
        chk = item.FindControl("CheckBox1") as CheckBox;
        if (chk != null && chk.Checked)
        {
            idList += ((Label)(item.FindControl("Label1"))).Text + ",";
        }
    }
    Response.Write("delete from Mac_Product where ID in(" + idList.TrimEnd(',')+ ")");
}

Answer 5

如果你的id在数据库里是字符类型 
protected void Button1_Click(object sender, EventArgs e)
{
    string idList = string.Empty;
    CheckBox chk;
    foreach (RepeaterItem item in Repeater1.Items)
    {
        chk = item.FindControl("CheckBox1") as CheckBox;
        if (chk != null && chk.Checked)
        {
            //字符类型
            idList += "'" + ((Label)(item.FindControl("Label1"))).Text + "',";
        }
    }
    Response.Write("delete from Mac_Product where ID in(" + idList.TrimEnd(',') + ")");
}

Answer 6

加一问题，用JQuery/javascript做“全选”和"反选“功能。。呵呵。。