asp.net gridview checkbox selection

Question

Need some help to solve this.

I have a gridview and inside the gridview I have a checkbox and after clicking the checkbox, I am doing a postback event and trying to update this particular row only on the database.

This is my gridview checkbox code. see the OnCheckedChanged.

<asp:TemplateField HeaderText="Sample">
  <ItemTemplate>
     <asp:CheckBox runat="server" 
                   ID="chkSample" 
                   Checked='<%# Bind("Sample") %>' 
                   OnCheckedChanged="UpdateSupplyLed" 
                   AutoPostBack="True">
    </asp:CheckBox> 
  </ItemTemplate>
</asp:TemplateField>

Code:

protected void UpdateSupplyLed(object sender, EventArgs e)
{
    foreach (GridViewRow di in SamplingGridView.Rows)    
    {        
        CheckBox chkBx = (CheckBox)di.FindControl("chkSample");
        if (chkBx != null && chkBx.Checked)
        {
            //update database logic here.
        }
    }
}

The above code works fine but it is getting me all the checkboxes that are checked irresepective of the one that I just checked. I don't want all of them.

How can I get the only one row value that have been just checked. Some of the rows might have been checked already because the status is true for those records and I don't want to update those records.

I think I've got my question right!

Update: The answer is:

protected void UpdateSupplyLed(object sender, EventArgs e)
{
    CheckBox chkSampleStatus = sender as CheckBox;        
    bool sample = chkSampleStatus.Checked;            
    GridViewRow row = chkSampleStatus.NamingContainer as GridViewRow;        
    TextBox txtId = row.FindControl("Id") as TextBox;            
    int id = Int32.Parse(txtId.Text);
}

Leniel Maccaferri · Accepted Answer · 2012-02-21 18:12:18Z

7

Try this:

CheckBox chkBx = sender as CheckBox;

Rather than iterate all the rows.

I haven't used CheckBox's in a GridView in this way myself. Usually I would use the GridView's OnRowCommand event instead and use the RowIndex or CommandArgument value to update the database.

Thinking about it OnRowcommand could be tricky for a CheckBox to fire, a better solution might be sticking with the CheckChanged event of the checkbox and navigate up to the GridViewRow serverside using controls NamingContainer. Something like:

GridViewRow row = chkBx.NamingContainer as GridViewRow;

I'm assuming the goes CheckBox => Cell => Row if you Google ASP.NET NamingContainer you'll get some more specifics.

edited Feb 21, 2012 at 18:12

Leniel Maccaferri

103k48 gold badges381 silver badges495 bronze badges

answered Aug 27, 2009 at 13:00

hollystyles

5,0592 gold badges38 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Supremestar Over a year ago

Thank you for your answer. But I need some other values from that same row so how can I get the row Id of that particular gridview row. so that I can get Id of the record.

hollystyles Over a year ago

Then I recommend not binding the checkbox's OnCheckChanged, use the GridViews OnRowCommand instead, the row is supplied in the GridVieweCommandEventArgs

Supremestar Over a year ago

HollyStyles, I don't have a select command field in the Gridview so Gridview row command is not firing. What should I do my friend? Please help.

hollystyles Over a year ago

Made some edits. Yuo could attach a selectedIndexChanged to the CheckBox but as I was writing it I thought that really smells as a solution.

Supremestar Over a year ago

Man you are a star, really you are! It is working like a charm with slight modification i.e GridViewRow row = chkBx.NamingContainer as GridViewRow; Thanking you for this. How can I mark your comments as answer. Cheers

|

Khalid Rafique · Accepted Answer · 2012-01-27 06:21:10Z

Try this also if above not working exactly

DataTable dtGetStTable = (DataTable)ViewState["dtNewStudents"];

//Looping throgh Grid and deleting row after finding the checked row
for (int i = dtGetStTable.Rows.Count - 1; i > -1; i--)
{
GridViewRow row = GridView1.Rows[i];
bool isChecked = ((CheckBox)row.FindControl("CheckBox1")).Checked;

if (isChecked)
{
    try
    {
        string RollNo = dtGetStTable.Rows[i]["RollNo"].ToString();
        string Class = dtGetStTable.Rows[i]["Class"].ToString();
        string Division = dtGetStTable.Rows[i]["Division"].ToString();
        //Deleting the Reocrd from DataBase
        TotalRecordDeleted += objSRE.DeleteTheSelectedRecord(RollNo, Class, Division);

        dtGetStTable.Rows[i].Delete();
        dtGetStTable.AcceptChanges();
    }
    catch (Exception ex)
    {

        //throw;
    }
}

}

Collectives™ on Stack Overflow

asp.net gridview checkbox selection

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related