storing the image in database

Question

FileUpload img = (FileUpload)FileUpload4;
Byte[] imgByte = null;
if (img.HasFile && img.PostedFile != null)
{

HttpPostedFile File = FileUpload4.PostedFile;

imgByte = new Byte[File.ContentLength];

File.InputStream.Read(imgByte, 0, File.ContentLength);

}

con.Open();
string sql = "INSERT INTO randomimage VALUES(@imgexplain,@imgtype)";
SqlCommand cmd1 = new SqlCommand(sql, con);

cmd1.Parameters.AddWithValue("@imgexplain", TextBox7.Text.Trim());

cmd1.Parameters.AddWithValue("@imgtype", imgByte);

int id = Convert.ToInt32(cmd1.ExecuteNonQuery());

Label17.Text = String.Format("Success to add");

this is the coding i using for storing the image ,when i display that how can i reduce the size of it?

plese tell me

Suthish Nair · Answer

If the query got resolved then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.

John Penn · Answer

Create a System.Drawing.Graphics object from your image data. You can use the various InterpolationMode settings of the Graphics object to determine the quality of the resize. Lastly call the DrawImage method of the Graphics object with the desired dimensions.

Mahesh Chand · Answer

Here are two articles: Inserting & retrieving images from SQL Server database using stored procedures Inserting & Retrieving Images from SQL Server Database without using Stored Procedures In this article there is a line of code: pictureBox1.Image = Image .FromStream(ms); This code basically gets the data from database in a steam and converts it to an Image object. So you need to replace this something like this: Image changedSize = Image .FromStream(ms); Now you need to create a thumbnail with a different size. Here are two articles on it: Create a thumbnail in C# Create Image Thumbnails in C#