Auto increment problem in c#.net

Question

0.00/5 (No votes)

See more:

I am using vs 2008 and sql server. Problem is whenever i insert a new record in a table, it is inserted but auto increment value skips the number. Any solution plz?

Posted 6-Nov-13 18:40pm

Pankaj Mahor

Add a Solution

Comments

ArunRajendra 7-Nov-13 0:47am

What do mean by skip? is it inserting 1,3,5 etc?

Pankaj Mahor 7-Nov-13 0:52am

yes

Gopi Kishan Mariyala 7-Nov-13 0:53am

Are you using identity column for the primary key in your table. After insertion are you returning the inserted row id. Can you show us the code that you have written to insert the record

Prasad Khandekar 7-Nov-13 0:55am

Please check the definition for your IDENTITY Column it should be of form IDENTITY [ (seed , increment) ]. So for number to start from 1 and increment by 1 it will e IDENTITY(1, 1). Please also note that a transaction inserting multiple rows is not guaranteed to get consecutive values for the rows because other concurrent inserts might occur on the table. If values must be consecutive then the transaction should use an exclusive lock on the table or use the SERIALIZABLE isolation level.

Regards,

Thanks7872 7-Nov-13 0:58am

This should be posted as a solution. My virtual +5 :-)

Pankaj Mahor 7-Nov-13 1:06am

I have id column with primary key and auto increment. If i delete a row and then insert a new record, it is then incrementing like 1, 2,..10, 12,13...

♥…ЯҠ…♥ 7-Nov-13 3:16am

Have a practice to post question as much as clear because no one can read your mind and suggest solution for that.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

♥…ЯҠ…♥ · Accepted Answer · 2013-11-06T18:59:00

Hi,
I reckon, the so called problem is

You have inserted 3 records initially like

ID Name Value
1 RK 100
2 Karthick 200
3 Prabakar 300

You have deleted ID 2 and 3 from the table,

now you are inserting another set of records like

Mani 400
Kaajal 500

into the table, now it is inserted as

4 Mani 400
5 Kaajal 500

Final table content would be like this

ID Name Value
1 RK 100
4 Mani 400
5 Kaajal 500

If am right then this is not a problem in sql server,then you should refer this link[^]
Hope this could help you a bit.

Regards,
RK

Auto increment problem in c#.net

1 solution

Solution 1

Add your solution here

Preview 0

Auto increment problem in c#.net

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us