C # Concept :

Question

Hi,

I have class called Item which has Id ,Name column  and Creating Item table in DB.

Suppose i have retrieve  a table like this in DataGrid .

Id  Name

1 pen

2 pencil

3 eraser

4 book

5 sharpener

If i delete Id having 3.Then after deleting Id should be in ascending Order.Like this and it should reflect in Datagrid after Deleting

Id  Name

1 pen

2 pencil

3 book

4 sharpener

Kindly help!!