how to arrange the id after delete the row from datagridview in c#

Question

i want to re-arrange the id number after delete the selected row from the datagridview .
if id was 1,2,3,4,5 then after delete the third row output should be 1,2,3,4.

please help!!

private void DeleteRow_Click(object sender, EventArgs e)

    {  
        if(DataGridView.SelectedRows.Count > 0)  
        {  

            using (SqlCommand cmd = con.CreateCommand())  
            {  
                int id = Convert.ToInt32(DataGridView.SelectedRows[0].Cells[0].Value);  
                cmd.CommandText = "Delete from [Table] where id='" + id + "'";  


                con.Open();  
                cmd.ExecuteNonQuery();  
                con.Close();  
                DisplayData();  

                DataGridView.Refresh();  
                commentbox.Text = "削除しました ";  
                commentbox.BackColor = Color.Yellow;  

            }  

        }  
        else  
        {  
            commentbox.Text = "削除する生を選択してください ";  
            commentbox.BackColor = Color.Yellow;  

        }  

    }  

//display

private void DisplayData()

    {  
        con.Open();  
        DataTable dt = new DataTable();  
        SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM [Table] ", con);  
        adp.Fill(dt);  
        DataGridView.DataSource = dt;  


        con.Close();  


    }  

Answer 1

@denesh neupane , Welcome to Microsoft Q&A, you could try to update every row's id to arrange the id after deleting the row in the datagirdview.

Code:

Note: I can not show the code use the code block so I used picture to replace it.

You could refer to the txt file.
211498-code.txt

Result:

Best Regards,
Jack

---

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

It is not clear why you cannot avoid such renumbering.

Try something like this:

using (SqlCommand cmd = con.CreateCommand())  
{  
   cmd.CommandText = "update t set id = new_id from (select *, row_number() over (order by id) as new_id from [Table]) t";  
   con.Open();  
   cmd.ExecuteNonQuery();  
   con.Close();  
}  

Maybe you do not need this.