Database

Question

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 ....