How can I check the null cell value in the DataGridView?

Question

How can I check the null cell value in a DataGridView in C#? I've used DBNull for checking, but it is not working.

Can anybody help me?

The code I currently have is:

string[] ar=new string[dataGridView1.Columns.Count];
for(int i=0;i<dataGridView1.Columns.Count;i++)
{
   if (dataGridView1.Rows[0].Cells[i].Value != DBNull.Value)
   {
     if (i != 0)
    {
       ar[i] = dataGridView1.Rows[0].Cells[i].Value.ToString ();
    }
    else
    {
       ar[i] = dataGridView1.Rows[0].Cells[i].Value.ToString();
    }
}

when you say you have tried DBNull, did you try something like `if (dataGridView1.Rows[j].Cells[1].Value == DBNull.Value)` ? — Bala R, Feb 26 '11 at 04:52
thanx for ur help but i've already used this condition but it is not working correctly. But i got my answer of this question — priyanka, Feb 26 '11 at 05:42
Please post the code that you've tried so far. Explain to us *how* it's "not working". What result did you get, compared to what result did you expect? — Cody Gray - on strike, Feb 26 '11 at 05:43
I formatted the code for you already. You just indent each line by 4 spaces, or select the block and click the `{}` on the toolbar. — Cody Gray - on strike, Feb 26 '11 at 05:56

score 4 · Accepted Answer · edited Aug 29 '13 at 19:35

4

you can use this

if(!Convert.IsDBNull(dataGridView1.Rows[0].Cells[i].Value))
{
    if (i != 0)
    {
       ar[i] = dataGridView1.Rows[0].Cells[i].Value.ToString ();
    }
    else
    {
       ar[i] = dataGridView1.Rows[0].Cells[i].Value.ToString();
    }
}

edited Aug 29 '13 at 19:35

Rémi

3,867
5
28
44

answered Feb 26 '11 at 05:58

Deepak

7,507
3
24
26

The correcte function name is `Convert.IsDBNull` I will edit to fix the typo. – Rémi Aug 29 '13 at 19:30

How can I check the null cell value in the DataGridView?

1 Answers1