object cannot be cast from dbnull to other types

Question

when we run the program then show the following error object cannot be cast from dbnull to other types i vahe calculate the datagraid view cell int sum = 0; for (int a = 0; a { sum += Convert.ToInt32(dataGridView1.Rows[a].Cells[2].Value); } label5.Text= sum.ToString(); }

ketan borsdiya · Answer

Hi Habib Replace line sum += Convert.ToInt32(dataGridView1.Rows[a].Cells[2].Value); With sum += string.IsNullOrEmpty(dataGridView1.Rows[a].Cells[2].Value.ToString()) ? 0 : Convert.ToInt32(dataGridView1.Rows[a].Cells[2].Value);

habib ullah · Answer

Thank you sir for your your feed back this answar is right its works for me

Rafnas T P · Answer

check you grid  I think in grid in 3rd cloumn you have some where null or empty value thats why you are getting this error to avoid this you can do the following changes add this checking red line in your code to skip empty or null values int sum = 0; for ( int a = 0; a { if (dataGridView1.Rows[a].Cells[2].Value!= null && dataGridView1.Rows[a].Cells[2].Value!=  ) sum += Convert.ToInt32(dataGridView1.Rows[a].Cells[2].Value); } label5.Text= sum.ToString(); }

Amit Gupta · Answer

There might be fetching null value from database. You can either use IsNull(columnname0); Or for ( int a = 0; a { var val = dataGridView1.Rows[a].Cells[2].Value; if (val != DBNull.Value) sum += Convert.ToInt32(val); } label5.Text= sum.ToString(); }