Saving an Image to Database

 Step1 : Show OpenFileDialog

OpenFileDialog strGetImage = new OpenFileDialog();
            strGetImage.InitialDirectory = strDirectory;
            strGetImage.Filter = "Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files (*.*)|*.*";
            strGetImage.FilterIndex = 1;
            strGetImage.Multiselect = false;
            strGetImage.RestoreDirectory = true;
            DialogResult Result = strGetImage.ShowDialog();

      Step2: After selecting the image convert the image into Bytes.

            if (Result == DialogResult.OK)
            {
                 strImageLocation = strGetImage.FileName;              

                 byte[] data;
                 Image image = System.Drawing.Image.FromFile(strImageLocation);

                 using (System.IO.MemoryStream stream = new System.IO.MemoryStream())
                 {
                     image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
                     data = stream.ToArray(); // Save image into byte.
                 }


             Step3 : Save it to database & return GUID (Primary key) 

              // Create SQL Connection
              SqlConnection con = new SqlConnection();  
              con.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();                                

                       // //Stored procedure to insert image
              SqlCommand cmd = new SqlCommand("InsertImage", con);
              cmd.CommandType = CommandType.StoredProcedure;


              SqlParameter Image= new SqlParameter
                              ("@Image", SqlDbType.Image, data.Length);
              Image.Value = data;
              cmd.Parameters.Add(Image);
                 

              con.Open();

Step 4: Convert the returned value into GUID.      
              Guid newId = (Guid)cmd.ExecuteScalar();
              con.Close();      

            } // Select Image OK ends here