Error when retrieve an empty money data type

(0) Share

Report

Posted on by Community Member Microsoft Employee

I keep getting an error says "The given key was not present in the dictionary" when trying to retrieve a record with empty money field.

decimal estRevBase = ((Money)cloudent["estimatedvalue"]).Value;

Above code is succes when the money field is not empty. But when money field is empty, 
it's returning an error.

I tried using

decimal ?

and Convert the decimal to string, to check wether the estrevbase is null or not.

decimal estRevBase = ((Money)cloudent["estimatedvalue"]).Value;
string des = estRevBase.ToString(); 
if (!string.IsNullOrEmpty(des))
    {
      estRev = Convert.ToDecimal(des);
    }
    else
    {
     estRev = 0 ;
    }

Still no luck :(

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

Nithya Gopinath 17,076 on at

Like (0)

Report
RE: Error when retrieve an empty money data type

Hi,

Please try the following code.

var estRevBase = (Money)cloudent["estimatedvalue"]; if(estRevBase !=null) { decimal estRevBaseValue = estRevBase.Value; }

Hope this helps.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Error when retrieve an empty money data type

Thanks
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report
RE: Error when retrieve an empty money data type

Please use a check before assigning values :

if (cloudent.Attributes.Contains("estimatedvalue")){ decimal estRevBase = ((Money)cloudent["estimatedvalue"]).Value; }