Dispaly Auto Incremnetd ID

Question

Hi Experts! i need to give a unique id to a product on some user selections and display it to user now i'm accomplishing it first go into db and get the max number add one to this and finally display complete ID to the user. and now user select some other options and finally hit submit button and get record saved message. Is it good way? i'm hitting database twice or more depends upon user's selection on changing. Is there any best solution then plz feel free to suggest

Sivaraman Dhamodaran · Answer

Use Auto Incremented Identity column (Are you using sql server :) ) The below link is useful: Link

Abdul Quddos · Answer

in my scenario there is only one user! so i will't be problem for me! but as per your concurrency question yes it will cause problem that's why i'm here to take advice from experts

Jignesh Trivedi · Answer

ok Are you think about the concurrent activity on this table? I mean to say what happened when more the one user is requesting the max id of the table probably they all are get same max id....

Abdul Quddos · Answer

it is not incremented in database it is just shown to user in incremented form

Jignesh Trivedi · Answer

hi I think there is no other way to achieve this. but in you current logic what happen when user abort the current transaction? because your number is already increment before it shown to the user.

Abdul Quddos · Answer

Yes I'm Using sql server. there are three categories each category has it's own credential to make unique key. let's say there are two categories A and B and one entry is going to be made against A the id of this category will be displayed to user like A1 and then user hit submit in second insertion user will be displayed as A2 automatically. but when user enter record against B it would be showed to him as B1 for first time and B2 and B3 for second and third time respectively.