请参阅此处，

C＃Datagridview更新和删除 [ ^ ]

根据您的要求修改以下代码。

Modify below code accordign to your requirement.

private void Bind()
        {
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter("Select * from Table Name", con);
            DataTable dt = new DataTable();
            da.Fill(dt);
            dataGridView1.DataSource = dt;
            con.Close();
        }

private void DeleteData()
{
    string sql = "DELETE FROM Table Name WHERE  [id] = '" + dataGridView2.Rows[i].Cells["[id]"].Value.ToString() + "' ";
    SqlCommand cmd = new SqlCommand(sql, objConn1);
    objConn1.Open();
    cmd.ExecuteNonQuery();
    objConn1.Close();
	
    Bind();
}