如何遍历Repeater的列值并赋值?

Question

foreach (RepeaterItem rt in this.rpList.Items)
  {
  CheckBox check = (CheckBox)rt.FindControl("cb1");
  if (check.Checked == true)
  {
  //赋值
  string sxNumber = rpList.Items[0].ToString();
string cmd="insert into tables value("+sxnumber+")";
using(xxxconnection con=new xxxconnection("connectstr"))
{
using(xxxcommand cmd=new xxxcommand(cmd,con))
{
con.open();
cmd.executenonquery();
}
}
  }
}
大概这样

Answer 1

<asp:Repeater ID="rp1" runat="server"  
                    onitemdatabound="rp1_ItemDataBound" >
                    <ItemTemplate>
                        <tr class="tdbg" align="center">
                    <td>
                        <input type="checkbox" name="C3" value='<%# Eval("LeaveMessageId") %>' runat="server"   />
                    </td>
                    <td>
                        <asp:Label ID="lblt" runat="server" Text='<%# Eval("LeaveMessageTite") %>'></asp:Label>
                    </td>
                    <td>
                        <asp:Label ID="Label2" runat="server" Text='<%# Common.GetCut(Eval("LeaveMessageContent").ToString()) %>'></asp:Label>
                    </td>
                    <td>
                        <asp:Label ID="Label3" runat="server" Text='<%# Eval("LeaveMessageName") %>'></asp:Label>
                    </td>
                    <td>
                        <asp:Label ID="Label4" runat="server" Text='<%# Eval("LeaveMessageDate") %>'></asp:Label>
                    </td>
                    <td align="left">
                    <asp:LinkButton ID="lnkDetail" runat="server">详细</asp:LinkButton>
                    &nbsp;<asp:LinkButton ID="lnkDel" runat="server" value='<%# Eval("LeaveMessageId") %>' OnClick="Delete" >删除</asp:LinkButton>
                    </td>
                </tr>
                    </ItemTemplate>
                </asp:Repeater>

Answer 2

(item.Controls[0] as DataBoundLiteralControl).Text