Last post Feb 28, 2019 04:35 AM by KathyW
Feb 28, 2019 02:09 AM|shsu|LINK
I have created the sequence with name ID_sn in oracle
Now this statemnet will insert the next value in to the database.
cmd.CommandText = "insert into packa(ID) values (ID_sn.NEXTVAL)"
HOW can i store this value in to a text box?There may be multiple inserts at a time. Appreciate the help.
Feb 28, 2019 04:35 AM|KathyW|LINK
Check out the second response here:
It shows setting an output variable and using RETURNING to put the inserted .nextval column value into that variable. You can then set the Textbox text value to that variable's value.