.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> ASP.NET Controls >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Phoito resize and store in database

Posted By:Brijesh Kumar       Posted Date: March 15, 2011    Points: 40    Category: ASP.NET Controls    URL: http://www.dotnetspark.com  

This article refer for the create photo resize in differenet size and after store in the SQL Database.
 

1)  Indicate these directory above of Program:-

using System.Data.SqlClient;

using System.Drawing.Imaging;

using System.Drawing.Drawing2D;

using System.Drawing;


2)  Drag a Button named "Upload" and a File Upload control from toolbox and a gridview for the show the image.


3)  Write this code to button click:-


 string strImageName = txtName.Text.ToString();

 if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != "")

 {

    string strExtension = System.IO.Path.GetExtension(FileUpload1.FileName);

    if ((strExtension.ToUpper() == ".JPG") | (strExtension.ToUpper() == ".GIF"))

    {

     // Resize Image Before Uploading to DataBase

      System.Drawing.Image imageToBeResized = System.Drawing.Image.FromStream(FileUpload1.PostedFile.InputStream);

      int imageHeight = imageToBeResized.Height;

      int imageWidth = imageToBeResized.Width;

      int maxHeight = 240;

      int maxWidth = 320;

      imageHeight = (imageHeight * maxWidth) / imageWidth;

      imageWidth = maxWidth;

 

              if (imageHeight > maxHeight)

                {

                    imageWidth = (imageWidth * maxHeight) / imageHeight;

                    imageHeight = maxHeight;

                }

 

                Bitmap bitmap = new Bitmap(imageToBeResized, imageWidth, imageHeight);

                System.IO.MemoryStream stream = new MemoryStream();

                bitmap.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);

                stream.Position = 0;

                byte[] image = new byte[stream.Length + 1];

                stream.Read(image, 0, image.Length);

 

 

 

                // Create SQL Connection

                SqlConnection con = new SqlConnection();

                con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

 

                // Create SQL Command

 

                SqlCommand cmd = new SqlCommand();

                cmd.CommandText = "INSERT INTO Images(ImageName,Image) VALUES (@ImageName,@Image)";

                cmd.CommandType = CommandType.Text;

                cmd.Connection = con;

 

                SqlParameter ImageName = new SqlParameter("@ImageName", SqlDbType.VarChar, 50);

                ImageName.Value = strImageName.ToString();

                cmd.Parameters.Add(ImageName);

 

                SqlParameter UploadedImage = new SqlParameter("@Image", SqlDbType.Image, image.Length);

                UploadedImage.Value = image;

                cmd.Parameters.Add(UploadedImage);

                con.Open();

                int result = cmd.ExecuteNonQuery();

                con.Close();

                if (result > 0)

                    lblMessage.Text = "File Uploaded";

                GridView1.DataBind();

            }

        }



     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend