How do I create a thumbnail after setting up the parameter to add an image to SQL database?

Question

0.00/5 (No votes)

See more:

Hello,
I have this problem regarding table management, that simply loads up client data. But my issue is that I have large images that are being displayed on the gridview making the rows enormous.

What I simply want is to add the original picture to the field `Photo` and a resized image to the field `Thumbnail` on my database.

What I have tried:

I have this code, but it simply inserts the same image on the database, instead of inserting a resized one. Any ideias?

string cb = "insert into Customer(C_ID,CustomerID,Name,Address,City,ContactNo,Email,Photo,Thumbnail) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9)";
                cc.cmd = new SqlCommand(cb);
                cc.cmd.Connection = cc.con;
                cc.cmd.Parameters.AddWithValue("@d1", txtID.Text);
                cc.cmd.Parameters.AddWithValue("@d2", txtCustomerID.Text);
                cc.cmd.Parameters.AddWithValue("@d3",txtCustomerName.Text);
                cc.cmd.Parameters.AddWithValue("@d4", txtAddress.Text);
                cc.cmd.Parameters.AddWithValue("@d5", txtCity.Text);
                cc.cmd.Parameters.AddWithValue("@d6", txtContactNo.Text);
                cc.cmd.Parameters.AddWithValue("@d7",txtEmailID.Text);
                MemoryStream ms = new MemoryStream();
                Bitmap bmpImage = new Bitmap(Picture.Image);
                bmpImage.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                byte[] data = ms.GetBuffer();
                SqlParameter p = new SqlParameter("@d8", SqlDbType.Image);
                p.Value = data;
                cc.cmd.Parameters.Add(p);
                MemoryStream thumb = new MemoryStream();
                Bitmap bmpThumb = new Bitmap(Picture.Image);
                bmpImage.GetThumbnailImage(80, 80, () => false, IntPtr.Zero);
                byte[] thumbnail = thumb.GetBuffer();
                SqlParameter tp = new SqlParameter("@d9", SqlDbType.Image);
                tp.Value = thumbnail;
                cc.cmd.Parameters.Add(tp);
                cc.cmd.ExecuteReader();
                cc.con.Close();
                st1 = lblUser.Text;
                st2 = "Adicionou o cliente '" + txtCustomerName.Text + "' com o ID: '" + txtCustomerID.Text + "'";
                cf.LogFunc(st1, System.DateTime.Now, st2);
                btnSave.Enabled = false;
                MessageBox.Show("Gravado com sucesso", "Registo", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

Posted 26-May-17 3:16am

Scribling Doodle

Updated 29-May-17 2:50am

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)

OriginalGriff · Accepted Answer · 2017-05-26T04:12:00

Solution 1

Two things: firstly, if your images are large, then it's better to not store them in the DB - use a file and store the path to the file in the DB instead.

Second, your code tells it to store the large image twice because you do nothing with the thumbnail image once you have created it, just add the ms buffer twice. You need to save the new thumbnail image to the thumb stream and fetch that buffer before you set the parameter value.

Your code would also be a little more obvious if you used "proper" names fro teh SQL parameters, and AddWithValue instead of Add:

string cb = "insert into Customer(C_ID,CustomerID,Name,Address,City,ContactNo,Email,Photo,Thumbnail) VALUES (@ID,@CID,@NAM,@ADDR,@CITY,@CNO,@EML,@IMAGE,@THUMB)";
cc.cmd = new SqlCommand(cb);
...
byte[] data = ms.GetBuffer();
cc.cmd.Parameters.AddWithValue("@IMAGE", data);
...
byte[] thumbnail = thumb.GetBuffer();
cc.cmd.Parameters.AddWithValue("@THUMB", thumbnail);
...

Posted 26-May-17 4:12am

OriginalGriff

Comments

Scribling Doodle 26-May-17 10:29am

Didn't quite understand your second part. I'm a beginner and I actually cannot seem to find a way to fix this problem. Could you be more explicit?

OriginalGriff 26-May-17 10:51am

You wrote the code to get the image data from the image, yes? So you need to do something similar to get the thumbnail data.

Scribling Doodle 26-May-17 11:30am

That's what I did, the actual code does insert the 2 images, but the thumbnail is actually inserting as the same resolution as the normal one, instead of 120x120 like I've done in the code.

OriginalGriff 26-May-17 11:39am

Yes, because you used the same data buffer for both instead of accessing the thumbnail data after you created it.
Look at your code: what do you do with the thumbnail image when you call GetThumbnailImage? Where do you store the thumbnail image itself?

Scribling Doodle 26-May-17 12:13pm

I store it on the d9 field that represents the thumbnail column in my database. I have a photo column and a thumb, but only the thumb should be during the view of all the data.

OriginalGriff 26-May-17 15:13pm

No, you don't - that's the whole point!

Look at the code.
You call GetThumbnailImage. What do you do with the Image that it returns?

Scribling Doodle 29-May-17 5:53am

Technically I would insert it into the database. According to my needs, I simply need a thumbnail to stop the rows from being too large in terms of height.

OriginalGriff 29-May-17 5:57am

"would" is a "future tense" word here - not what you have done with it so far...

Scribling Doodle 29-May-17 7:07am

That's why I used "Technically". It simply should insert the same image as a thumbnail on the database for it to show on the datagrid without any excessive row height.

OriginalGriff 29-May-17 7:18am

But your code doesn't.
It doesn't even use it ... or store it ... or save it ... or reference it ...

Scribling Doodle 29-May-17 8:08am

It inserts the byte. But it's not resizing. That's my actual problem.

OriginalGriff 29-May-17 8:24am

:sigh:
OK - you aren't going to look at your code, or the documents or anything, so I'll spell it out.
GetThumbnailImage takes an image and some size information and *returns a new image* containing the thumbnail. It doesn't change the original image, or any buffers you created from it, it *returns a new image*

Which you ignore completely and it gets discarded...make sense now?

Scribling Doodle 29-May-17 8:54am

byte[] thumbnail = thumb.GetBuffer();
SqlParameter tp = new SqlParameter("@d9", SqlDbType.Image);
tp.Value = thumbnail;
cc.cmd.Parameters.Add(tp);

What this actually means to you? I create a byte and store the value from the buffer. Then I create the sql parameter to insert it on the column thumbnail. After that I simply set the value of the var 'tp' to the have the same value as the thumbnail byte. After that I simply add it to the database as a parameter. Isn't that what's on the code? How can I not be using the value if this is exactly what I've made? The value is on the database, but it's not resized

OriginalGriff 29-May-17 10:02am

And what - exactly - is in "thumb"?
Let me give you a clue as to where you should start thinking:

Image thisIsTheThumbNailImageYouJustCreatedPrehapsUsingItMightBeAGoodIdea = bmpImage.GetThumbnailImage(80, 80, () => false, IntPtr.Zero);