C#

private void SaveImageToDb(string fileName, SqlConnection sqlConnection)
{
  // save image to a memory stream
  using (MemoryStream ms = new MemoryStream())
  {
    Image.FromFile( fileName ).Save( ms, System.Drawing.Imaging.ImageFormat.Bmp );

    using (SqlCommand sqlCmd = new SqlCommand( 
      "INSERT INTO MyTable(MyImage) VALUES (@Image)", sqlConnection ))
    {
      sqlCmd.Parameters.Add( "@Image", SqlDbType.Image );

      // The image is set based on the byte array in the MemoryStream.
      sqlCmd.Parameters [ "@Image" ].Value = ms.GetBuffer( );

      // execute command
      sqlCmd.ExecuteNonQuery( );
    }
  }
}

Luc Pattyn wrote:

Not sure why, but the OP actually asked for a VarBinary field, not an Image field.

Luc Pattyn wrote:

The way you suggest the data moves from file to Image to MemoryStream to byte array (BTW the Image isn't disposed of).

Luc Pattyn wrote:

I guess I'm missing something.

private void SaveImageToDb(string fileName, SqlConnection sqlConnection)
{
    using (SqlCommand sqlCmd = new SqlCommand( 
      "INSERT INTO MyTable(MyImage) VALUES (@Image)", sqlConnection ))
    {
        sqlCmd.Parameters.Add( "@Image", SqlDbType.VarBinary);
        sqlCmd.Parameters [ "@Image" ].Value = File.ReadAllBytes(fileName);
        sqlCmd.ExecuteNonQuery( );
    }
  }
}

using (SqlConnection sqlConnection = new SqlConnection(strConn))
 {
     sqlConnection.Open();
     foreach (string file in fileList)
     {
         FileStream fileStream = new FileStream(file, FileMode.Open, FileAccess.Read);
         byte[] byteImage = new byte[fileStream.Length];
         fileStream.Read(byteImage, 0, (int)fileStream.Length);

         string commandText = "Insert into ImageTable(ImagePath, Image)Values(@ImagePath, @Image)";
         SqlCommand sqlCommand = new SqlCommand(commandText, sqlConnection);
         sqlCommand.Parameters.Add("@ImagePath", SqlDbType.Text);
         sqlCommand.Parameters.Add("@Image", SqlDbType.Binary);
         sqlCommand.Parameters["@ImagePath"].Value = file;
         sqlCommand.Parameters["@Image"].Value = byteImage;

         sqlCommand.ExecuteNonQuery();

         System.Windows.Forms.Application.DoEvents();
     }
 }

shoubi wrote:

it is not efficient to repeat that

NetworkStream aStream = _client.GetStream();
StreamReader  reader = new StreamReader(aStream);