How to get check box selected value from grid view? c#

Question

I want to insert specific row values based on check box click. The design and source is given below. From the design I have to select some Items. If I click approve, I have to store those check box checked row values into DB. Help me to find a proper solution.

Design:

enter image description here

ASPX:

enter image description here

C#:

The given below code is getting the entire gridview value and storing into db. How can I modify this code as per above requirements.

protected void btnApprove_Click(object sender, EventArgs e)
    {

       ShadingAnalysisDataSetTableAdapters.tbl_ItemRequest_StatusTableAdapter rs;
       rs = new ShadingAnalysisDataSetTableAdapters.tbl_ItemRequest_StatusTableAdapter();

       foreach (GridViewRow row in GridView2.Rows)
        {
            string ItemName = row.Cells[0].Text;
            string Quantity = row.Cells[1].Text;

            rs.testInsert(ItemName, Quantity);
        }
    }

Where is the C# behind your button clicks? Nobody wants to write the entire check for selected items and database queries for each. — grovesNL, Dec 01 '14 at 06:25

score 3 · Accepted Answer · answered Dec 01 '14 at 06:27

You need to iterate through your gridview and find check box by Id in cell of current row.

foreach (GridViewRow row in GridView2.Rows)
    {
        if (row.RowType == DataControlRowType.DataRow)
        {
            CheckBox chkRow = (row.Cells[2].FindControl("CheckBox1") as CheckBox);
            bool chk = chkRow.Checked;
            // Do your stuff
        }
    }

Source: http://www.aspsnippets.com/Articles/GridView-with-CheckBox-Get-Selected-Rows-in-ASPNet.aspx

score 1 · Answer 2 · answered Dec 01 '14 at 07:00

The given below code is working perfectly.

foreach (GridViewRow row in GridView2.Rows)
    {
      if (row.RowType == DataControlRowType.DataRow)
        {
           CheckBox chkRow = (row.Cells[2].FindControl("CheckBox1") as CheckBox);
             if (chkRow.Checked)
                {
                   string ItemName = row.Cells[0].Text;
                   string Quantity = row.Cells[1].Text;

                   rs.testInsert(ItemName, Quantity);
                }
        }
    }

score 0 · Answer 3 · answered Nov 08 '22 at 07:34

Here is my GridView

<asp:GridView
                ID="grdAccounts"
                class="table table-condensed"
                runat="server"
                AutoGenerateColumns="False"
                CellPadding="4"
                ForeColor="#333333"
                GridLines="None">
                <AlternatingRowStyle BackColor="White" />
                <Columns>
                    <asp:BoundField DataField="CUST_NAME" HeaderText="Name" />
                    <asp:BoundField DataField="CUST_NUMBER" HeaderText="Account Number" />
                    <asp:BoundField DataField="BR_CODE" HeaderText="CIF Number" />
                    <asp:TemplateField HeaderText="Select" >
                        <EditItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" ItemStyle-HorizontalAlign="Right"  />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" onclick="SingleCheckboxCheck(this)" OnCheckedChanged="CheckBox1_CheckedChanged" />
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
                <EditRowStyle BackColor="#7C6F57" />
                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <PagerStyle CssClass="pagination-ys" />
                <RowStyle BackColor="#E3EAEB" HorizontalAlign="Center" />
                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                <SortedAscendingCellStyle BackColor="#F8FAFA" />
                <SortedAscendingHeaderStyle BackColor="#246B61" />
                <SortedDescendingCellStyle BackColor="#D4DFE1" />
                <SortedDescendingHeaderStyle BackColor="#15524A" />
            </asp:GridView>

c#(I assumed as the required value is in the 1 cell of the selected row.)

string accnbr = string.Empty;
                foreach (GridViewRow gvrow in grdAccounts.Rows)
                {
                    CheckBox chk = (CheckBox)gvrow.FindControl("CheckBox1");
                    if (chk != null & chk.Checked)
                    {
                        cif += gvrow.Cells[1].Text + ',';
                    }
                }

How to get check box selected value from grid view? c#

3 Answers3

The given below code is working perfectly.