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

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

Answers (1)