db null coming in property asp.net

Question

i am getting error in the code getting error The value for column 'TotalValue' in table 'wsm_View_PurchaseOrderList' is DBNull.

error image

public decimal TotalValue {
    get {

        try {
            if (object.ReferenceEquals(tablewsm_View_PurchaseOrderList.TotalValueColumn, DBNull.Value)) {
                return 0.0;
            } else {
                return Convert.ToDecimal(this(this.tablewsm_View_PurchaseOrderList.TotalValueColumn));
            }

        } catch (System.InvalidCastException e) {
            throw new global::System.Data.StrongTypingException("The value for column 'TotalValue' in table 'wsm_View_PurchaseOrderList' is DBNull" + ".", e);
        }
    }
    set { this(this.tablewsm_View_PurchaseOrderList.TotalValueColumn) = value; }
}

The error is explanatory. The value on your tablewsm_View_PurchaseOrderList.TotalValueColumn is null. — Willy David Jr
– Willy David Jr, Commented May 31, 2017 at 2:34
What is the Data type of TotalValueColumn? You can check if the value is null or not and use 0 if its null. — Chetan
– Chetan, Commented May 31, 2017 at 2:38
TotalValueColumn seems have DBNull value when it assigned to non-null decimal equivalent. Probably certain check against DBNull.Value is possible. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented May 31, 2017 at 2:44

Cossintan · Accepted Answer · 2017-05-31 05:21:31Z

1

Try checking for DBNull like this:

if (Convert.IsDBNull(tablewsm_View_PurchaseOrderList.TotalValueColumn))
{
    return 0.0;
}

answered May 31, 2017 at 5:21

Cossintan

1143 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

db null coming in property asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related