error when multiply two columns to the third in gridview c#

Question

when i multiply two columns in gridview in c# the error is Object cannot be cast from DBNull to other types.

Sanjeeb Lenka · Answer

try this one decimal sum = 0.00m; decimal s, s1; for (int i = 0; i { if (tbl_main_subDataGridView.CurrentRow.Cells[4].Value != DBNull.Value) s = Convert.ToDecimal(tbl_main_subDataGridView.CurrentRow.Cells[4].Value); else s = 0.00m; if (tbl_main_subDataGridView.CurrentRow.Cells[5].Value != DBNull.Value) s1 = Convert.ToDecimal(tbl_main_subDataGridView.CurrentRow.Cells[5].Value); else s1 = 0.00m; decimal s13 = s1 * s; tbl_main_subDataGridView.CurrentRow.Cells[6].Value = s13; }

hoshiar ali · Answer

Thank you very much i exactly want this code if you don't boring i think may be have question in the future Regards Hoshiar Ali

Iftikar Hussain · Answer

try like this decimal s; decimal s1; for (int i = 0; i { object d1 = tbl_main_subDataGridView.CurrentRow.Cells[4].Value; if (d1 != null) { s = Convert.ToDecimal(d1); } object d2 = tbl_main_subDataGridView.CurrentRow.Cells[6].Value; if (d2 != null) { s1 = Convert.ToDecimal(d2); } decimal s13 = s1 * s; tbl_main_subDataGridView.CurrentRow.Cells[6].Value = s13; } Regards, Iftikar

hoshiar ali · Answer

This is My Code Mr. Iftikar decimal sum = 0.00m; for (int i = 0; i { decimal s = Convert.ToInt32(tbl_main_subDataGridView.CurrentRow.Cells[4].Value); decimal s1 = Convert.ToInt32(tbl_main_subDataGridView.CurrentRow.Cells[5].Value); decimal s13 = s1 * s; tbl_main_subDataGridView.CurrentRow.Cells[6].Value = s13; }

Iftikar Hussain · Answer

Hi, You need to check null before multiply. Please share your code. Regards, Iftikar