Object cannot be cast from DBNull to other types.

Question

hi all any clear the error Object cannot be cast from DBNull to other types. i have attached screen shot

Amit Gupta · Answer

Try this if (e.Row.RowType == DataControlRowType.DataRow) { var GrowthItem =DataBinder.Eval(e.Row.DataItem Growth ); decimal value = GrowthItem==DBNull.Value? 0: Convert.ToDecimal(GrowthItem); if (value ..... }

Nitin Sontakke · Answer

Somehow I tend to do it differently. It is a small bit of business logic which can safely be moved to back-end. Why not select row colour in your original query itself and just use that column here as in: select .... case when growth and use this value in your code.

Kumaran P · Answer

thank u Amit Gupta so much my code running successfully

Kumaran P · Answer

if (e.Row.RowType == DataControlRowType.DataRow) // { // decimal value = (decimal)DataBinder.Eval(e.Row.DataItem Growth); // if (value // { // // for apply to entire row // foreach (TableCell cell in e.Row.Cells) // { // cell.BackColor = Color.FromName(#f480a1); // } // // for only one cell // //e.Row.Cells[1].BackColor = Color.FromName(#f480a1); // } // }

Kumaran P · Answer

STILL am getting same same please help me any one

Amit Gupta · Answer

Your eval expression returns a DBNull value apply a if condition before converting to Int32. This will fix the issue