delete rows in datagridview in c#

Question

I want to delete some rows from datagridview based on condition in c#,but at run time i find that row,though by debugging my code is working properly. My code is as follows:- foreach (DataGridViewRow item in this.dataGridView1.Rows) { if ((item.Cells['Start Time'].Value.ToString() != '22:00:00') || (item.Cells['Start Time'].Value.ToString() != '18:00:00')) { dataGridView1.Rows.Remove(item); } } dataGridView1.Rows.Remove(item); Instead of this line,I have even tried dataGridView1.Rows.RemoveAt(item.Index) i have even tried to delete rows from datatable and then bind in datagridview ,but nothings helped me. why my above code fails to delete record in datagridview,PLZ help me out.

Kanimozhi Shivakumar · Answer

Hi Priyanka, Even I faced this same issue..Later I found the solution and now it is working perfectly..You can try below code : I used for loop instead of Foreach : for ( int i = 0; i { if (dataGridView1[ "Start Time" , i].Value != null && (dataGridView1[ "Start Time" , i].Value.ToString().Trim() == "22:00:00" || dataGridView1[ "Start Time" , i].Value.ToString().Trim() == "18:00:00" ) { DataGridViewRow dgvDelRow = dataGridView1.Rows[i]; dataGridView1.Rows.Remove(dgvDelRow); } } dataGridView1.Refresh(); Please share what error you are getting.. then we can help you to resolve this issue. You can try with DataGridView1_DataError() event in debug mode to find out the error

Yogesh Ghorpade · Answer

Priyanka Try After Remove The Row dataGridView1.Refresh();

Jaish Mathews · Answer

Just noticed this. Here 2 points to share. 1st you should use RemoveAt() and also if you are using data bind and then need to remove the rows, normal List/Collection won't work. You should use a collection which implements IBindingList i.e. BindingList , DataTable etc... Below is an example which I quickly tried and worked. private void Form1_Load( object sender, EventArgs e) { BindingList timeDetails = new BindingList (); timeDetails.Add( new TimeDetail { StartTime = DateTime.Parse( "8/11/2018" ), Month = "Jan" }); timeDetails.Add( new TimeDetail { StartTime = DateTime.Parse( "8/12/2018" ), Month = "May" }); timeDetails.Add( new TimeDetail { StartTime = DateTime.Parse( "12/12/2018" ), Month = "May" }); timeDetails.Add( new TimeDetail { StartTime = DateTime.Parse( "1/11/2018" ), Month = "Jan" }); dataGridView1.DataSource = timeDetails; } private void button1_Click( object sender, EventArgs e) { foreach (DataGridViewRow item in this .dataGridView1.Rows) { if (item.Cells[ "Month" ].Value.ToString() == "Jan" ) { dataGridView1.Rows.RemoveAt(item.Index); } } } public class TimeDetail { public DateTime StartTime { get ; set ; } public string Month { get ; set ; } }

Rafnas T P · Answer

hi, try to write this code in CellFormatting Event of datagrid

Sirisha K · Answer

dataGridView1.Clear();

priyanka · Answer

Thanks all for your reply I have solved this,by copying rows based on condition in another datatable.

Jignesh Kumar · Answer

Hi Priyanka, You can try DeleteRow method dataGridview1.DeleteRow(Item.Index); After this use gridview1.Bind() to bind grid after deleted row.

priyanka · Answer

i am not getting any error,but when i look at runtime,that rows, which i want to delete is still in my datagriview

ejaz mirza · Answer

whats error r u getting

priyanka · Answer

yes,i am getting that

ejaz mirza · Answer

put a break point be sure that u r getting item.id

Sirisha K · Answer

I got success in that, We need to declare datatable has globally and add static and public to datatable declaration.

Karthik Ramachandran · Answer

' CommandName="Select" OnClick="link_pt_delete_Click" OnClientClick="return confirm('Procedure will be deleted permanently. Are you sure?');"> AlternateText="Delete Procedure Details" ImageUrl="~/images/icons/delete.gif" /> protected void link_pt_delete_Click(object sender, EventArgs e) { try { LinkButton lc = (LinkButton)sender; string sid = lc.CommandArgument; string[] str = new string[2]; char[] splitter = { ',' }; str = sid.Split(splitter); string coid = str[0].ToString(); int ptId = int.Parse(coid); // pass this id to your delete stored procedure... } catch (Exception exp) { MessageBox.Show(exp.Message); } }

ejaz mirza · Answer

u r bringing the values from database then u have to delete by writing query

delete rows in datagridview in c#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (14)