Delete GridView Row

Question

Hi I want to delete gridview row on selected checkbox. Suppose I have 10rows in grid and checkbox also. I want to delete those rows which checkbox were checked.

Om prakash Singh · Answer

In place of direct delete from database use like this code and re-bind the grid with this datatable. DataRow dr; for (i = ds_xml.Tables[xmltable].Rows.Count -1; i >= 0; i--) { dr = ds_xml.Tables[xmltable].Rows[i]; if (dr[0].ToString() != Ops.ToString()) ds_xml.Tables[xmltable].Rows.Remove(dr); } This will not delete data from database but from user interface

Jiteendra Sampathirao · Answer

hi I hope you seen my referred links... To achieve this functionality your database table Should have status column. set the default value '1' to it. At the place of Delete query you need to write update query to change the status value to '0'. And then call the Gridview_filling . there write the select query like Select abcdef from data_table where status=1; you need to customize the whole coding.... i hope you got some idea...

Sahil Jani · Answer

Hi Thanks to all. But I dont want to delete this gridrow from the database. I just want to delete it from userInterface only.

Jiteendra Sampathirao · Answer

Hi refer this link: Link1 Link2 i hope it works for you....

Om prakash Singh · Answer

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