将图像大小调整为标题样式

我正在考虑拥有一张动态的桌子，上面有我健身房客户的照片。但是，当我将其设置为相应地调整所有行的大小时，行是巨大的，如果我有10000条记录，那就太烦人了。如果我没有调整行的大小，图像会被裁剪到我无法看到客户脸的位置。





任何想法如何解决这个问题？



我尝试了什么：



其实我有一些带有一些数据的网格，为了安全措施，我不得不隐藏所有敏感数据。

[带照片的DataGridView表。]





SQL查询：

I was thinking about having a dynamic table that has photos of my gym's clients. But when I set it to resize all rows accordingly the rows are huge, and it's so annoying if I have like 10000 records. If I do not resize the rows the image is cropped to the point that I cannot see the client's face.


Any ideias on how to resolve this problem?

What I have tried:

Actually I have this grid with some data, for security measures I had to hide all the sensitive data.
[DataGridView table with photos.]


SQL query:

cc.cmd = new SqlCommand("SELECT RTRIM(C_ID) as [#],RTRIM(CustomerID) as [# de Cliente],RTRIM(Name) as [Nome],RTRIM(Address) as [Morada],RTRIM(City) as [Cidade],RTRIM(ContactNo) as [# de Telemovel],RTRIM(Email) as [Email],Photo from Customer order by name", cc.con);