title: Convert Byte Array to Image: Parameter is not valid
body: <p>I am storing images in a database and would like to convert them from byte array to image. I have no problem converting an object to byte array but I get an error of "Parameter is not valid" when trying to convert from byte array to image. The object I am passing to my method is from a dataset row.</p>
  
  <p><strong>Stored procedure</strong></p>
  
  <pre><code>USE [----------------]
  GO
  /****** Object:  StoredProcedure [dbo].[usp_imageloader_add_test]    Script Date: 01/16/2012    09:19:46 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  ALTER   procedure [dbo].[usp_imageloader_add_test]
  @p_Image Image
  
  as 
  
  INSERT into Test_Images VALUES(@p_Image)
  </code></pre>
  
  <p><strong>Upload File control</strong> /convert Image file to byte array and save data to database</p>
  
  <pre><code> protected void btnUpload_Click(object sender, EventArgs e)
      {
          if (ctrlUpload.PostedFile != null)
          {
              if (ctrlUpload.PostedFile.ContentLength &gt; 0)
              {
                  // Get Posted File
                  HttpPostedFile objHttpPostedFile = ctrlUpload.PostedFile;
  
                  // Find its length and convert it to byte array
                  int ContentLength = objHttpPostedFile.ContentLength;
  
                  // Create Byte Array
                  byte[] bytImg = new byte[ContentLength];
  
                  // Read Uploaded file in Byte Array
                  objHttpPostedFile.InputStream.Read(bytImg, 0, ContentLength);
  
                  using (SqlConnection dbConnection = new SqlConnection(app_settings.sql_conn_string_db))
                  {
                      try
                      {
                          string sql = "usp_imageloader_add_test";
                          SqlCommand cmd = new SqlCommand(sql, dbConnection);
                          cmd.CommandType = System.Data.CommandType.StoredProcedure;
                          cmd.Parameters.AddWithValue("@p_Image", bytImg).SqlDbType = SqlDbType.Image;
                          cmd.Connection.Open();
                          cmd.ExecuteNonQuery();
                          cmd.Connection.Close();
                      }
  
  
                      catch (Exception ex)
                      {
                          ex.Message.ToString();
                      }
                  }
              }
          }
      }
  </code></pre>
  
  <p><strong>Convert object to byte array and to image</strong></p>
  
  <pre><code> private System.Drawing.Image ObjToImg(object obj)
      {
          byte[] byteArray;
          if (obj == null)
              return null;
          else
          {
              BinaryFormatter bf = new BinaryFormatter();
              MemoryStream ms = new MemoryStream();
              bf.Serialize(ms, obj);
              byteArray = ms.ToArray(); // Byte Array
              ms.Close();
  
              ms = new MemoryStream(byteArray, 0, byteArray.Length);
              ms.Seek(0, SeekOrigin.Begin);
              System.Drawing.Image returnImage = System.Drawing.Image.FromStream(ms);
              return returnImage;
          }
  </code></pre>
  
  <p>Any ideas would be helpful.</p>