Increment of number after grabbing it from DB

Question

The situation is I have connected to my Oracle database and grabbed an INT number i wanted and display into my form textbox.No prob thus far...But i want it to +1 or increment and at lost of how to do so.

localSQL = "SELECT MAX(ITEM_ID) FROM SYS_ITEM";  

                    OracleCommand cmdOracle = new OracleCommand(localSQL, localConnection);  

                    cmdOracle.CommandType = CommandType.Text;  

                    OracleDataReader drOracle = cmdOracle.ExecuteReader();  

                        if (drOracle.Read())  

                        {addlocaidBox.Text = drOracle.GetOracleValue(0).ToString();}

The code look like this.I'd welcome any suggestions or advice.

tommy · Answer

Well as they say 3 times a charm. Thanks! it finally worked with addlocaidBox.Text = OracleDecimal.Add(drOracle.GetOracleDecimal(0),1).ToString();

Jan Montano · Answer

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();

tommy · Answer

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...

Jan Montano · Answer

I see. so it's a numeric data type already. Try this: addlocaidBox.Text = ( drOracle .GetOracleValue(0) + 1).ToString();

tommy · Answer

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)

Jan Montano · Answer

what is the data type of the field we are retrieving? try this instead addlocaidBox.Text = (Convert.ToDouble( drOracle .GetOracleValue(0)) + 1).ToString();

tommy · Answer

Thanks for your help,but when i ran the code the exception error of "Specified Cast not vaild" appeared.

Jan Montano · Answer

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

Increment of number after grabbing it from DB

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (8)