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);
                }
        }
    }

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

2 Answers2

The given below code is working perfectly.