Issue in Auto Generate Number in VB.Net

rachayita jaiswal

13y1.6k.NET

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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

rachayita jaiswal13y ago
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.
0
13y ago
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.
0
Sanjeeb Lenka13y ago
Then in code behind you have to check the last inserted id from database and then increment that.
0
rachayita jaiswal13y ago
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?
0
Sanjeeb Lenka13y ago
Yes, you have to check that in database. if its exits show a msg.
0