Delete Rows that does not contain the value that I want.

Question

for (int i = 0; i { string[] Jobs = { "Network Engineer", "Financial Analyst", "Accountant", "Payroll Administrator", "Accountant Manager", "Sales Consultant" }; if (!applicationDataGridView.Rows[i].IsNewRow) { if (applicationDataGridView[4, i].Value.ToString() != Jobs) { applicationDataGridView.Rows.RemoveAt(i); i--; } } } Above is the code that I have tried but It does not work. I want to delete the rows that doesn't contain the values in "Jobs" which I have assigned as a string. The Job column is column "4".

Sachin Singh · Answer

yes, yr code is already correct and should work private void btnDelete(object sender,....) { string[] Jobs = { "Network Engineer" , "Financial Analyst" , "Accountant" , "Payroll Administrator" , "Accountant Manager" , "Sales Consultant" }; foreach (DataGridViewRow row in applicationDataGridView .Rows) { if (!applicationDataGridView.Rows[i].IsNewRow) { if (!Jobs.Contains(applicationDataGridView[4, i].Value.ToString() )) { applicationDataGridView.Rows.RemoveAt(i); } } } }

Sachin Singh · Answer

if case is the issue then test this for ( int i = 0; i { string[] Jobs = { "Network Engineer" , "Financial Analyst" , "Accountant" , "Payroll Administrator" , "Accountant Manager" , "Sales Consultant" }; if (!applicationDataGridView.Rows[i].IsNewRow) { if (Jobs.Any(x=>x.ToLower()==applicationDataGridView[4, i].Value.ToString()ToLower() )) { applicationDataGridView.Rows.RemoveAt(i); } } }

Sachin Singh · Answer

Test this for ( int i = 0; i { string[] Jobs = { "Network Engineer" , "Financial Analyst" , "Accountant" , "Payroll Administrator" , "Accountant Manager" , "Sales Consultant" }; if (!applicationDataGridView.Rows[i].IsNewRow) { if (!Jobs.Contains(applicationDataGridView[4, i].Value.ToString() )) { applicationDataGridView.Rows.RemoveAt(i); } } }

Samuel Toh · Answer

@Sachin Singh, thanks so much, it is working now.

Samuel Toh · Answer

@Sachin Singh, it does not delete now. The previous code you provided works fine. Just that I will need to continuous click the delete button to delete one at a time. I want to delete everything at once. Is it possible?

Samuel Toh · Answer

@kirtesh Shah, It does not delete now.

Kirtesh Shah · Answer

Try this, Trim ad upper case might help you, for ( int i = 0; i { string [] Jobs = { "Network Engineer" , "Financial Analyst" , "Accountant" , "Payroll Administrator" , "Accountant Manager" , "Sales Consultant" }; if (!applicationDataGridView.Rows[i].IsNewRow) { foreach (var item in Jobs) { if (applicationDataGridView[0, i].Value.ToString().Trim().ToUpper().Equals(item.Trim().ToUpper()) { applicationDataGridView.Rows.RemoveAt(i); break ; } } } }

Samuel Toh · Answer

Okay, I think I understand what went wrong. I will have to click the delete multiple times to delete every value that does not match with the string "Jobs". So is there any way if I can just click once and it will check every row for matching values?

Samuel Toh · Answer

@Kirtesh Shah, I understand. However, when I have "Automotive Engineering" under my "Job" Column. It will still be there after clicking the delete button. So it did not work as intended. It also deleted some of the matching values from the string "Jobs".

Samuel Toh · Answer

Although it is working now, it is still inconsistent in terms of deleting the rows. After deleting the rows, some of the results still shows values that does not equals to the values in "Jobs".

Kirtesh Shah · Answer

Hi, You are trying to compare datagridvalue with array and that will not work. Please try the below code , for ( int i = 0; i { string [] Jobs = { "Network Engineer" , "Financial Analyst" , "Accountant" , "Payroll Administrator" , "Accountant Manager" , "Sales Consultant" }; if (!applicationDataGridView.Rows[i].IsNewRow) { foreach (var item in Jobs) { if (applicationDataGridView[4, i].Value.ToString() != item) { applicationDataGridView.Rows.RemoveAt(i); break ; } } } }

Srinivasan Ramamoorthi · Answer

Don’t delete the records in the grid. Delete the rows or columns in dataset or data table and rebind to gridview

Kirtesh Shah · Answer

@Samule - I think, it will remove value that not match with below condition, foreach (var item in Jobs) { if (applicationDataGridView[4, i].Value.ToString() != item) { applicationDataGridView.Rows.RemoveAt(i); break ; } }