Get The Value of a Gridview Using a Checkbox and Save in DB

Once again I need some assistance.

I have a gridview where its data comes from a certain table in my database. In the gridview, I added a checkbox. Once the checkbox is checked, the value of the ClauseCode will be saved in another table in my database. The sad part is that I don't know how to do it. Below is my markup:

<asp:GridView ID="gvClauses" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" AutoGenerateColumns="False" DataKeyNames="ClauseCode">
<AlternatingRowStyle BackColor="#CCCCCC" />
<Columns>
<asp:TemplateField HeaderText="ClauseID" InsertVisible="False" SortExpression="ClauseID">
<EditItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("ClauseID") %>'>asp:Label>
EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("ClauseID") %>'>asp:Label>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="ClauseCode" SortExpression="ClauseCode">
<EditItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("ClauseCode") %>'>asp:Label>
EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblClauseCode" runat="server" Text='<%# Bind("ClauseCode") %>'>asp:Label>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="ClauseDescription" SortExpression="ClauseDescription">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ClauseDescription") %>'>asp:TextBox>
EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("ClauseDescription") %>'>asp:Label>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Wordings" SortExpression="Wordings" Visible="False">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Wordings") %>'>asp:TextBox>
EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("Wordings") %>'>asp:Label>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox ID="cbSelect" runat="server" OnCheckedChanged="cbSelect_CheckedChanged" />
ItemTemplate>
asp:TemplateField>
Columns>
<FooterStyle BackColor="#CCCCCC" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#808080" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#383838" />
asp:GridView>

I tried to search in google for several hours but I haven't found a requirement the same as mine. Hope someone can assist me. Thanks in advance.

After trying several attempts...now eventually got the right code. Here's what I did:

private void saveCheckedItem()
{
foreach (GridViewRow row in gvClauses.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox clausecode = (CheckBox)row.FindControl("cbSelect");
if (clausecode != null && clausecode.Checked)
{
Label lblClauseCode = (Label)row.FindControl("lblClauseCode");
using(SqlConnection con = DBConnection.GetDbCon())
{
SqlCommand cmd = new SqlCommand("INSERT INTO tblNonMotorInsurance VALUES(@ClauseCode)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ClauseCode", lblClauseCode.Text.Trim());
con.Open();
cmd.ExecuteNonQuery();
}
}
}
}
}

Hope this code can help users who need it.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jes Sie8y ago
After trying several attempts...now eventually got the right code. Here's what I did:
private void saveCheckedItem()
        {
            foreach (GridViewRow row in gvClauses.Rows)
            {
                if (row.RowType == DataControlRowType.DataRow)
                {
                    CheckBox clausecode = (CheckBox)row.FindControl("cbSelect");
                    if (clausecode != null && clausecode.Checked)
                    {
                        Label lblClauseCode = (Label)row.FindControl("lblClauseCode");
                        using(SqlConnection con = DBConnection.GetDbCon())
                        {
                            SqlCommand cmd = new SqlCommand("INSERT INTO tblNonMotorInsurance VALUES(@ClauseCode)", con);
                            cmd.CommandType = CommandType.Text;
                            cmd.Parameters.AddWithValue("@ClauseCode", lblClauseCode.Text.Trim());
                            con.Open();
                            cmd.ExecuteNonQuery();

                        }
                    }
                }

            }
        }
Hope this code can help users who need it.
0