I have a column named Emp_Id and set as primary key (not Auto Incr).I am trying to generate an ID (employee) and save it into a SQL database.
The logic goes this way:
Generate the id number with a prefix plus the number (i.e. EMP0001).
Display it on a textbox on a form so that I can save it on the Emp_Id column.
I can't provide any codes since I really do not know how to begin with this.
Appreciate your help. Thanks