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

hoshiar ali

13y2.4kVisual Basic .NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
Accepted answer
try this one

decimal sum = 0.00m;
        decimal s, s1;

        for (int i = 0; i < tbl_main_subDataGridView.Rows.Count; 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;
        }
0
hoshiar ali13y ago
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
0
Iftikar Hussain13y ago
try like this

decimal s;
decimal s1;
for (int i = 0; i < tbl_main_subDataGridView.Rows.Count; 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
0
hoshiar ali13y ago
This is My Code Mr.Iftikar

decimal sum = 0.00m;

for (int i = 0; i < tbl_main_subDataGridView.Rows.Count; 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;

}
0
Iftikar Hussain13y ago
Hi,
You need to check null before multiply. Please share your code.

Regards,
Iftikar
0