Increment of number after grabbing it from DB

Well as they say 3 times a charm.

Thanks! it finally worked with

addlocaidBox.Text = OracleDecimal.Add(drOracle.GetOracleDecimal(0),1).ToString();

Strike 3! I'm out. hehe :)

I need to look at the documentation now.

looking at the documenation from this site:

we could use an OracleDecimal.Add function to add two OracleDecimal variables

addlocaidBox.Text = OracleDecimal.Add(drOracle.GetOracleValue(0),1).ToString();

addlocaidBox.Text = (drOracle.GetOracleValue(0) + 1).ToString();

The underlined section got a compilation error of

Operator '+' cannot be applied to operands of type 'object' and 'int'

I tried addlocaidBox.Text = (drOracle.GetOracleValue(0) )+1.ToString();

But resulted in the number with a 1 behind it...

I see. so it's a numeric data type already.

Try this:

addlocaidBox.Text = (drOracle.GetOracleValue(0) + 1).ToString();

When i tried
addlocaidBox.Text = (Convert.ToDouble(drOracle.GetOracleValue(0)) + 1).ToString();

It prompts...
System.InvalidCastException: Unable to cast object of type 'Oracle.DataAccess.Types.OracleDecimal' to type 'System.|Convertible'.
at System.Convert.ToDouble(Object value)

and even if i convert it to ToDecimal the same error msg appears but at System.Convert.ToDecimal(Object value)

Thanks for your help,but when i ran the code the exception error of

"Specified Cast not vaild" appeared.