delete checked record from the data base and gridview

Question

hi..
i am using gridview. and i have a checkbox as a template column in gridview . when i checked single record and press delete button, then record is successfully perform delete. but when i check multiple record and click the delete then it gives following error:
Index was out of range. Must be non-negative and less than the size of the collection.<br>Parameter name: index

Server Error in '/' Application.

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Source Error:

Line 101:                if (chkBox.Checked)
Line 102:                {
Line 103:                    int id = Convert.ToInt32(gvEmployee.DataKeys[objData.RowIndex].Value.ToString());
Line 104:
Line 105:                    objB.Delete(id);

i am using below code to perform delete operation i am developing application in three-tire architecture.

protected void btnDelete_Click(object sender, EventArgs e)
        {
            foreach (GridViewRow objData in gvEmployee.Rows)
            {
                CheckBox chkBox = (CheckBox)objData.FindControl("chkDelete");
                if (chkBox.Checked)
                {
                    int id = Convert.ToInt32(gvEmployee.DataKeys[objData.RowIndex].Value.ToString());

                    objB.Delete(id);
                    fillEmployeeDetail();

                }

            }

        }

can anyone give me solution. with code in asp.net,C#

Vijaya Kadiyala · Answer

HI Not sure why are you calling Fillemployeedetail for each and every record. If you have multiple updates / deletes then call this method at the end of request . now comming back to the problem check out the below code this is working at my end so replace the names with your object names. protected void btnMultipleRowDelete_Click( object sender EventArgs e) { // Looping through all the rows in the GridView foreach ( GridViewRow row in GridView1.Rows) { CheckBox checkbox = ( CheckBox )row.FindControl( cbRows ); //Check if the checkbox is checked. //value in the HtmlInputCheckBox's Value property is set as the //value of the delete command's parameter. if (checkbox.Checked) { // Retreive the Employee ID int employeeID = Convert .ToInt32(GridView1.DataKeys[row.RowIndex].Value); // Pass the value of the selected Employye ID to the Delete //command. SqlDataSource1.DeleteParameters[ EmployeeID ].DefaultValue = employeeID.ToString(); SqlDataSource1.Delete(); } } } Thanks -- Vj http :// dotnetvj . blogspot . com http :// oravj . blogspot . com

Vijaya Kadiyala · Answer

I am glad that the solution is working. Thanks -- Vj http :// dotnetvj . blogspot . com http :// oravj . blogspot . com

jignesh kadvani · Answer

done. i putted fillEmployeeDetail(); in a wrong place. it comes after foreach loop over. thanks for giving replay.

delete checked record from the data base and gridview

Server Error in '/' Application.

Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index