last inserted id into a textbox-vb.net

Question

User-1578974752 posted

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)"
         

            cmd.ExecuteNonQuery()

HOW can i store this value in to a text box?There may be multiple inserts at a time. Appreciate the help.

Answer 1

User409696431 posted

Check out the second response here: https://community.oracle.com/thread/356998

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.