Issue in Auto Generate Number in VB.Net

Question

Hi Sunny Now only i got issue in Auto generate number as we Discussed yesterday. The problem is it is working fine but if first time i have inserted ABC12300001 no. in database and i ll close application then again i ll run application and insert data relate to ABC and 123 that time again it is taking ABC12300001. But it should not happen means repeatition should not be there I just want to ask you that should i run sql query and check whether that particular auto number exist or not or how i should avoid this problem. I am waiting for reply.

rachayita jaiswal · Answer

Thanks all for replying me. I got solution so it is working fine. before insertion i ve mention code for checking value and based on that i am inserting my auto number. Thanks.

Muralidharan Deenathayalan · Answer

Before inserting the data into sql server please check the current autonumber exists in the database or not. If possible please share the code behind and sp code we will help you to fix that issue.

Sanjeeb Lenka · Answer

Then in code behind you have to check the last inserted id from database and then increment that.

rachayita jaiswal · Answer

Hi But this auto generate no i am not inserting from front end in code behind only i ve written code  so when u ll insert new record from front end auto number will save automatically in data base. then how can i show message?

Sanjeeb Lenka · Answer

Yes you have to check that in database. if its exits show a msg.