Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
8
Reply
Increment of number after grabbing it from DB
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
tommy
15y
2.9k
1
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.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
Family Name issue
send and recieve messages via Bluetooth