Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
Register
Login
8
Reply
Increment of number after grabbing it from DB
tommy
Feb 3 2009 9:27 PM
2.9k
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
Family Name issue
send and recieve messages via Bluetooth