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

Samuel Toh

for (int i = 0; i < applicationDataGridView.Rows.Count; 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".

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted 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);
}
}
}

}
Samuel Toh4y ago
@Sachin Singh, thanks so much, it is working now.
Samuel Toh4y ago
@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?
Sachin Singh4y ago
if case is the issue then test this
for (int i = 0; i < applicationDataGridView.Rows.Count; 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);

                    }
                }
            }
Samuel Toh4y ago
@kirtesh Shah, It does not delete now.
Kirtesh Shah4y ago
Try this, Trim ad upper case might help you,
for (int i = 0; i < applicationDataGridView.Rows.Count; 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 Toh4y ago
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 Toh4y ago
@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".
Sachin Singh4y ago
Test this
for (int i = 0; i < applicationDataGridView.Rows.Count; 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 Toh4y ago
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 Shah4y ago
@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;
                     }
                 }
Kirtesh Shah4y ago
Hi,

You are trying to compare datagridvalue with array and that will not work.

Please try the below code ,
for (int i = 0; i < applicationDataGridView.Rows.Count; 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 Ramamoorthi4y ago
Don’t delete the records in the grid. Delete the rows or columns in dataset or data table and rebind to gridview