How to check empty and null cells in datagridview using C#

Question

i am trying to check the datagridview cells for empty and null value... but i can not do it right...

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
    if ((String)dataGridView1.Rows[i].Cells[3].Value == String.Empty)
    {
        MessageBox.Show(" cell is empty");
        return;
    }

    if ((String)dataGridView1.Rows[i].Cells[3].Value == "")
    {
        MessageBox.Show("cell in empty");
        return ;
    }
}

i even tried this codes

if (String.IsNullOrEmpty(dataGridView1.Rows[i].Cells[3].Value))
{
  MessageBox.Show("cell is empty");
  return;
}

can any one help me.. with this...

it is not showing any error message even though.. i leave the cell blank... — Vincent
– Vincent, Commented Nov 24, 2011 at 10:14

Davide Piras · Accepted Answer · 2018-07-07 01:14:19Z

28

I would try like this:

foreach (DataGridViewRow rw in this.dataGridView1.Rows)
{
  for (int i = 0; i < rw.Cells.Count; i++)
  {
    if (rw.Cells[i].Value == null || rw.Cells[i].Value == DBNull.Value || String.IsNullOrWhiteSpace(rw.Cells[i].Value.ToString())
    {
      // here is your message box...
    }
  } 
}

edited Jul 7, 2018 at 1:14

answered Nov 24, 2011 at 10:07

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ahmed Faizan Over a year ago

IsNullOrWhitespace has error saying 'string' does not contain definition for 'IsNullOrWhitespace' can you tell me why?

Programmer Over a year ago

The "s" in "Whitespace" needs to be capitalized.

Mystic Lin · Accepted Answer · 2015-09-04 05:20:13Z

6

if (String.IsNullOrEmpty(dataGridView1.Rows[i].Cells[3].Value as String))
{
    MessageBox.Show("cell is empty");
    return;
}

Add as String, it works for me.

answered Sep 4, 2015 at 5:20

Mystic Lin

3754 silver badges16 bronze badges

Comments

H Aßdøµ · Accepted Answer · 2016-03-02 11:52:45Z

4

if (!GridView1.Rows[GridView1.CurrentCell.RowIndex].IsNewRow)
{
     foreach (DataGridViewCell cell in GridView1.Rows[GridView1.CurrentCell.RowIndex].Cells)
    {
        //here you must test for all and then return only if it is false
        if (cell.Value == System.DBNull.Value)
        {
            return false;
        }
    }
}

edited Mar 2, 2016 at 11:52

H Aßdøµ

3,0555 gold badges30 silver badges37 bronze badges

answered Mar 8, 2015 at 9:03

IT Forward

3952 gold badges8 silver badges30 bronze badges

Comments

Deniz · Accepted Answer · 2018-07-04 07:08:56Z

4

I think you should use this:

for (int i = 0; i < dataGridView1.RowCount; i++)
{
    for (int j = 0; j < dataGridView1.ColumnCount; j++) 
    {
        if (dataGridView1.Rows[i].Cells[j].Value == DBNull.Value)
        {
            dataGridView1.Rows[i].Cells[j].Value = "null";
        }
    }
}
dataGridView1.Update();

edited Jul 4, 2018 at 7:08

Deniz

4561 gold badge4 silver badges21 bronze badges

answered Jun 29, 2012 at 13:52

Mujtaba

852 silver badges10 bronze badges

Comments

V4Vendetta · Accepted Answer · 2011-11-24 10:48:05Z

1

I think you should check for null first

Convert.IsDBNull(dataGridView1.Rows[j].Cells[1].FormattedValue)

edited Nov 24, 2011 at 10:48

answered Nov 24, 2011 at 10:10

V4Vendetta

38.5k9 gold badges83 silver badges84 bronze badges

2 Comments

Davide Piras Over a year ago

are you sure? this is not the usual way to check for nulls and also, why do you check against FormattedValue and not Value only?

V4Vendetta Over a year ago

@David Suggested FormattedValue which would after any specific formats being applied to the cell, post those compare the values

demongolem · Accepted Answer · 2017-03-13 19:02:51Z

0

for (int i = 0; i < GV1.Rows.Count; i++)
{
    if ((String)GV1.Rows[i].Cells[4].Value == null)
    {
        MessageBox.Show(" cell is empty");
        return;
    }
}

It's working fine.

edited Mar 13, 2017 at 19:02

demongolem

9,75436 gold badges97 silver badges107 bronze badges

answered Mar 13, 2017 at 17:35

Govind Lumia

1

Comments

Deniz · Accepted Answer · 2018-07-04 08:00:18Z

0

Try this :

foreach (DataGridViewRow row in dataGridView.Rows)
{
    IEnumerable<DataGridViewCell> cellsWithValusInRows = from DataGridViewCell cell in row.Cells
        where string.IsNullOrEmpty((string)cell.Value)
        select cell;

     if (cellsWithValusInRows != null && cellsWithValusInRows.Any())
     {
         //Then cells with null or empty values where found  
     }
}

Then check for the collection if it is null or it has elements.

I hope this was helpful.

edited Jul 4, 2018 at 8:00

Deniz

4561 gold badge4 silver badges21 bronze badges

answered Nov 8, 2016 at 9:21

Ali Ezzat Odeh

2,1631 gold badge20 silver badges18 bronze badges

Comments

Deniz · Accepted Answer · 2018-07-04 10:16:01Z

Works perfect for me:

for (int i = dataGridView1.Rows.Count - 1; i >= 0; i--)
{
    DataGridViewRow dataGridViewRow = dataGridView1.Rows[i];

    foreach (DataGridViewCell cell in dataGridViewRow.Cells)
    {
        string val = cell.Value as string;
        if (string.IsNullOrEmpty(val))
        {
            if (string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[3].Value as string)) // If you want to check more then just one cell you could also add "&& (string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[ANY NUMBER].Value as string)
            {
                MessageBox.Show(" cell is empty");
                return;
                /* or to delete replace with:
                dataGridView1.Rows.Remove(dataGridViewRow);
                break;
                */
            }
        }
    }
}

StephenSoftware · Accepted Answer · 2021-06-05 10:31:00Z

0

        // move cell value to Excel
        for (int i = 0; i < grd.Rows.Count; i++)
        {
            for (int t = 0; t < grd.Columns.Count; t++)
            {
                try
                {
                    worksheet.Cells[i + 2, t + 1] = grd.Rows[i].Cells[t].Value.ToString();
                }
                catch (Exception e)
                {
                    Debug.WriteLine(e.HResult + " " + e.Message + " I've always hated null ");
                }
            }
        }

answered Jun 5, 2021 at 10:31

StephenSoftware

91 silver badge3 bronze badges

2 Comments

Michael Rovinsky Over a year ago

Please add some explanation to your answer

StephenSoftware Over a year ago

I have tried all suggestions provided in this post and nobody works well for me... at end I have opted for catch any type of error during setting value... If there is an error I skip the cell otherwise I set the value... I hope my explanation is exaustive.

Collectives™ on Stack Overflow

How to check empty and null cells in datagridview using C#

9 Answers 9

2 Comments

Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

2 Comments

Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related