I am Developing one Window Application in C#.net and Using SQL Server 2010 as a Back End Tool. Now I have Created One Table.Details is Given Below.
Table Name :- Group
Filed Name Datatype
grpid int - Primary Key
grpnm varchar(50)
Property of the table That I have Set :-
Isidentity :- True
IncrementBy :- 1
Startfrom :- 1.
Group No Group Name
1 AAA
2 BBB
3 CCC
4 DDD
5 EEE
Now I am Deleting Record No:4
and Adding One Record : that is Given Below.
But the thing is Record Will be stored at Position 6 instead of 4. We can see that We can store the Record at position 4.
Group No Group Name
1 AAA
2 BBB
3 CCC
5 EEE
6 FFF
In Short Whenever I Performed Delete Operation On any Record I want that , Database allow me to add First on that Postion that is Empty. Please Help Me Out on this. Because I did So many Research On it. But Cant Get Proper Solution. Thank You ....