How To Store an Image to image SQL Server Data type Using C#

Note: It is not recommended to use this method if you want to store a large amount of images (ex. gallery). Instead, try storing images in an external file and use image path as an [nvarchar] data type.

Image in real is a set of color points arranged a certain way to form a picture, in computer language color point called Pixel, each pixel is a combination of different values of Red, Green & Blue (RGB), computer dealing with image as a series of bytes, each byte represent an image pixel, image data type in SQL Server can store up to  (2,147,483,647) bytes.

In this example i used a Picture Box as an image input way, then converted the input image to array byte

        private static byte[] imagetoByte(Image img)
        {
            MemoryStream ms = new MemoryStream();
            img.Save(ms, System.Drawing.Imaging.ImageFormat.Gif);
            return ms.ToArray();
        }

       Byte[] img = imagetoByte(PictureBox1.Image);

For more details watch this video

and download the source code for experiment purposes