how to delete multiple row in gridview by select the checkbox in asp.net with c# with example

Question

how to delete multiple row in gridview by select the checkbox with delete button in asp.net with c# with example?

Marish Balasubramanian · Answer

Refer the following Source DataSourceID=SqlDataSource1 AutoGenerateColumns=false CellPadding=2 ForeColor=#333333 GridLines=Both DataKeyNames=ID OnRowDataBound=GridView1_RowDataBound> AutoPostBack=true OnCheckedChanged=chkSelectAll_CheckedChanged/> AutoPostBack=true OnCheckedChanged=chkSelect_CheckedChanged/> SortExpression=ID/> Text=' ' ForeColor=Blue BorderStyle=none BorderWidth=0px ReadOnly=true > =Location> Text=' ' ForeColor=Blue BorderStyle=none ReadOnly=true> ConnectionString=  SelectCommand=SELECT [ID] [Name] [Location] FROM [Details] DeleteCommand=DELETE FROM Details WHERE (ID = @ID) UpdateCommand=UPDATE [Details] SET [Name] = @Name [Location] = @Location WHERE [ID] = @ID> OnClick=btnUpdate_Click Text=Update /> OnClick=btnDelete_Click Text=Delete /> Code behind for that... protected void chkSelectAll_CheckedChanged (object sender EventArgs e) { CheckBox chkAll = (CheckBox)GridView1.HeaderRow.FindControl(chkSelectAll); if (chkAll.Checked == true) { foreach (GridViewRow gvRow in GridView1.Rows) { CheckBox chkSel = (CheckBox)gvRow.FindControl(chkSelect); chkSel.Checked = true; TextBox txtname = (TextBox)gvRow.FindControl(txtName); TextBox txtlocation = (TextBox)gvRow.FindControl(txtLocation); txtname.ReadOnly = false; txtlocation.ReadOnly = false; txtname.ForeColor = System.Drawing.Color.Black; txtlocation.ForeColor = System.Drawing.Color.Black; } } else { foreach (GridViewRow gvRow in GridView1.Rows) { CheckBox chkSel = (CheckBox)gvRow.FindControl(chkSelect); chkSel.Checked = false; TextBox txtname = (TextBox)gvRow.FindControl(txtName); TextBox txtlocation = (TextBox)gvRow.FindControl(txtLocation); txtname.ReadOnly = true; txtlocation.ReadOnly = true; txtname.ForeColor = System.Drawing.Color.Blue; txtlocation.ForeColor = System.Drawing.Color.Blue; } } }