How To Retrieve an image SQL Server Data type into Picture Box Using C#

Note: Before reading this blog,  you need to know (How To Store an Image to image SQL Server Data type Using C#)

Images are stored in SQL Server database as series of bytes; to retrieve an image into Picture Box follow these steps

1- Crete a stored procedure that do select command on an image
2- In C# code get the array byte retrieved from the database and convert it to Image 
        
        public static Image byteArrayToImage(byte[] byteArrayIn)
        {
            MemoryStream ms = new MemoryStream(byteArrayIn);
            Image returnImage = Image.FromStream(ms);
            return returnImage;
        }

3- Set the converted image to the picture box 


For more details watch this video

and download the source code for experiment purposes

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 

 

How to Create and Publish a Data Cube using SQL Server Analysis Services

For data mining purposes, Microsoft developed a tool called  SQL Server Analysis Services,

with this tool you can analyze a large number of data, which is characterized as the accumulation of several years,and most large companies use data analysis tools for decision-making service

This video explain how to:

• Create Data Cube using businesses intelligence development studio (BIDS)
• Publish the project & Deploy it to SQL Server with analysis services tool
• Doing some OLAP operation like (Slice, Dice, Pivot..)