Invalid Cast

[Guest]

When I run the following code:

private string GetSystemPriorityRange()
{
decimal fromPriority = Convert.ToDecimal(systemPriorityFromList.SelectedItem);
decimal toPriority = Convert.ToDecimal(systemPriorityToList.SelectedItem);
if (systemPriorityRangeCheck.Checked == true)
{
return " and wo6 between " + "'" + fromPriority + "'" + " and " + "'" + toPriority + "'";
}
else
{
return null;
}
}

I get the following error:

Specified cast is not valid.

The values involved are things like 0, 1.00, 1.60, 2.50

Aren't these decimal types. How should I alter my code to handle this?

Thanks,

Dave

 

[ilPostino]

http://www.typemismatch.com/viewforum.php?f=1

 

[Guest]

I SelectedItem property will return the textual representation of the item (e.g. High Prioirity, Low Priority, etc) rather than the actual values themselves (1.0, 1.5). Try SelectedValue instead

Not
systemPriorityFromList.SelectedIte
systemPriorityToList.SelectedIte

Try this
systemPriorityFromList.SelectedValu
systemPriorityToList.SelectedValue

 

[Guest]

What is the return type of systemPriorityFromList.SelectedItem and systemPriorityToList.SelectedItem

If you switch out those values with an object with a value of 1.60 or a string with a value of "1.60", verything works just fine, so I'd say you're trying to convert to a deciaml from a type that's not supported.