Remove last empty row in Gridview

Question

0.00/5 (No votes)

See more:

HI All

I have Gridview in winform, I want to remove last empty row in gridview I try to use below code but it show me error

My Code

C#

bool Empty = true;

            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                Empty = true;
                for (int j = 0; j < dataGridView1.Columns.Count; j++)
                {
                    if (dataGridView1.Rows[i].Cells[j].Value != null && dataGridView1.Rows[i].Cells[j].Value.ToString() != "")
                    {
                        Empty = false;
                        break;
                    }
                }
                if (Empty)
                {
                    dataGridView1.Rows.RemoveAt(i);
                }

Showing Error

Uncommitted new row cannot be deleted.

Please help me

Thanks

Posted 12-Jan-15 1:14am

mjawadkhatri

Updated 24-Apr-21 16:44pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Babu Mahimairaj · Answer 1 · 2015-01-12T02:46:00

Solution 2

C#

for (int i = 1; i < dataGridView1.RowCount - 1; i++)
{
   Boolean isEmpty = true;
   for(int j=0;j<dataGridView1.Columns.Count; j++)
   {
     if (dataGridView1.Rows[i].Cells[j].Value.ToString() != "" )
      {
          isEmpty = false;
          break;
      }
    }
    if (isEmpty)
    {
       dataGridView1.Rows.RemoveAt(i);
       i--;
    }
 }

Posted 12-Jan-15 2:46am

Santhosh Babu Mahimairaj

Comments

mjawadkhatri 12-Jan-15 9:10am

HI.
above code is not working for me.. code do nothing.. I use above code in button_click event. please help me where i do mistake

Thanks

[no name] 12-Jan-15 9:13am

which button click event Grid view button or form button click event

mjawadkhatri 12-Jan-15 9:17am

form button click event

*dan!sh* · Answer 2 · 2015-01-12T01:19:00

Solution 1

Set AllowUsersToAddRow as false. BTW, you might want to specify DataGridView instead of GridView since latter is web control.

Posted 12-Jan-15 1:19am

dan!sh

Member 15168774 · Answer 3 · 2021-04-24T16:44:00

Solution 3

Only uncheck checkbox Enable Adding of grid data view. That is easier way without any code ..

Posted 24-Apr-21 16:44pm

Member 15168774

Updated 24-Apr-21 16:48pm

v3

Comments

Richard Deeming 26-Apr-21 5:47am

Which is exactly what Solution 1 said, six years ago. You have added nothing to the discussion.