Resizing image to header's style

Question

0.00/5 (No votes)

See more:

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:

SQL

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);

Posted 1-May-17 23:37pm

Scribling Doodle

Updated 2-May-17 0:16am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Accepted Answer · 2017-05-02T00:07:00

Solution 1

When you are storing images of your client, There should be one real image and one thumbnail images.

For view purpose thumbnail will be fine as per your requirement, when somebody clicks on it, It will be enlarged.

Let us know if you have any query or concern for same.

Posted 2-May-17 0:07am

Nirav Prabtani

Comments

Scribling Doodle 2-May-17 6:18am

Done, Actually I do not have any thumbnail, but as I was thinking, The size wouldn't really matter, because the picturebox can resize to it's actual size. Instead I was simply thinking about resizing the image and insert it in the database and then the picturebox would stretch it out on the Updating form. Would this be a good ideia?

Nirav Prabtani 2-May-17 6:40am

Storage of thumbnail would be a better instead of stretching original one.

Scribling Doodle 2-May-17 8:05am

So, by your logic, I should create a thumbnail column, and then resize the image programmatically and then insert into the thumbnail column. Is that what you're saying?

Nirav Prabtani 4-May-17 3:43am

You should store thumbnail and real image, either you store physically to directory and store path in database column or you can store both images to database directly and get images according to your need

The logic is upon you but I have just guided that you can use thumbnail during listing.

Scribling Doodle 4-May-17 3:47am

What I did to minimize the impact on the memory spent dealing with this tasks was simply create a column called thumbnail and simply resize the image to a 100x100 image and then instead of converting the real image and processing the thumbnail directly on the datagrid, it simply loads the thumbnail photo, leaving me much more memory for other tasks. Thanks in advance.