请教大神们~如图所示，如何将gridview中每一行及checkbox勾选值存入另一个数据库？最好能有示例代码~

Question

数据库，gridview

Answer 1

jquery判断，然后将相应的id给隐藏域，后台获取隐藏域插入数据库

Answer 2

foreach(gridrow gd in gridview1.rows)
{
           if(dg.cell[3].values==true)
           {
                       //插入数据
          }
}

Answer 3

首先,for循环肯定是要的,你在你的每一个checkbox加个隐藏域hidden 把当行的ID给隐藏域的value  然后就可以取值啦  根据ID可以取出所有行的数据吧?

Answer 4

这个是我用repeater常用的手法  repeater里<%#Eval('PepleID')%> 就可以把后台绑定的字段取到啊

Answer 5

for (int i = 0; i < Repeater1.Items.Count; i++)
        {
            HiddenField hd = (HiddenField)Repeater1.Items[i].FindControl("hd");
            CheckBox cb = (CheckBox)Repeater1.Items[i].FindControl("cb");
            string id = hd.Value.ToString();
            if (cb.Checked)
            {
                string sql = "delete from HOUSE where HOUSEID ='"+id+"' ";
                SQLHELPER.sqlhelper.Excute(sql);
            }
                    }
        Bind();这个是我用repeater控件做的  你看一下啊 
前台
<asp:Repeater ID="Repeater1" runat="server" 
            onitemcommand="Repeater1_ItemCommand"  >
        <HeaderTemplate>
              <table id="Table01"  width="809" height="100" border="0" cellspacing="1" cellpadding="1"  bgcolor="Silver" style=" font-family:宋体; font-size:14px">
                <tr class="TableHeader">
                <th style=" width:100px" align="center">全选<asp:CheckBox ID="cball" runat="server" 
            oncheckedchanged="cball_CheckedChanged" AutoPostBack="true" /></th>
                    <th style=" width:100px">房屋编号</th>
                    <th style=" width:100px">小区名称</th>
                    <th style=" width:100px">房屋标题</th>
                    <th style=" width:150px" align="center">发布时间</th>
                    <th style=" width:100px" align="center">操作</th>
                </tr>
            </HeaderTemplate>
            <ItemTemplate>
                <tr >
                    <td bordercolor="0" align="center" ><asp:CheckBox ID="cb" runat="server" /><asp:HiddenField ID="hd" runat="server" Value=<%#Eval("HOUSEID")%>   />
                    </td>
                    <td bordercolor="0" align="center"><%#Eval("HOUSEID")%> </td>
                    <td bordercolor="0" align="center"><%#Eval("VILLAGE")%> </td>
                    <td bordercolor="0" align="center"><%#Eval("TITLE")%> </td>
                    <td bordercolor="0" align="center"><%#Eval("PUBLISHDATE")%></td>
                    <td bordercolor="0" align="center"> <a href="<%#Eval("houseId","houseAdd.aspx?id={0}") %>">更新</a> &nbsp <asp:LinkButton  ID="lbtnDel" runat="server" CommandArgument='<%#Eval("HOUSEID")%>' CommandName="del" OnClientClick="return confirm('确定删除吗?')">删除</asp:LinkButton></td>
                    
                     
                </tr>
            </ItemTemplate>
            <%--<AlternatingItemTemplate>
            <tr bgcolor="#f9f9f9" onmousemove="javascript:this.style.backgroundColor='#FFFF99'" onmouseout="javascript:this.style.backgroundColor='#f9f9f9'" >
                    <td bordercolor="0" align="center" ><asp:CheckBox ID="cb" runat="server" /><asp:HiddenField ID="hd" runat="server" Value=<%#Eval("HOUSEID")%>  />
                    </td>
                    <td bordercolor="0" align="center"><%#Eval("HOUSEID")%> </td>
                    <td bordercolor="0" align="center" ><%#Eval("VILLAGE")%> </td>
                    <td bordercolor="0" align="center" ><%#Eval("TITLE")%> </td>
                    <td bordercolor="0" align="center" ><%#Eval("PUBLISHDATE")%></td>
                    <td bordercolor="0" align="center" ><a href="<%#Eval("houseId","houseAdd.aspx?id={0}") %>">更新</a> &nbsp <asp:LinkButton ID="lbtnDel" runat="server" CommandArgument='<%#Eval("HOUSEID")%>' CommandName="del">删除</asp:LinkButton></td>
                    
                </tr>
            </AlternatingItemTemplate>--%>
            <FooterTemplate>
                </table>
            </FooterTemplate>
        </asp:Repeater>
        </br>
    <table width="809" height="37" border="0" cellspacing="1" cellpadding="1"  >
  <tr>
    <td bgcolor="#FFFFFF" class="style1">
        <asp:Button ID="Button1" runat="server" Text="新增" onclick="Button1_Click" />&nbsp;
        <asp:Button ID="Button2" runat="server" Text="修改" onclick="Button2_Click" />&nbsp;
        <asp:Button ID="Button3" runat="server" Text="删除" onclick="Button3_Click"  OnClientClick="return confirm('确定删除选中行吗?')" />&nbsp;
</td>