Image column from DataSource mapping

Question

Hi, I have a problem with the GGC that I can't figure out. I have to display Users in my GGC with a column image representing the Profile Picture.

How can I map the Image Column to the datasource field that contains the image data?
Which data type should the field use? Byte array, Bitmap, Image...

The column is already set with Apperance.AnyRecordFieldCell.CellType = Image.

Thanks

Arulpriya Ramalingam · Answer

Hi Alessandro,   
   
Thanks for using Syncfusion products.   
   
Suggestion 1   
   
We could understand your scenario. In order to populate the images from the datasource, the corresponding column type can be set as Byte[] array in DataSource. The images will be loaded into the grid by its corresponding byte values. Please make use of below code and sample,   
   
Code example:   
   




   
//To add the image column into DataTable   
dataTable.Columns.Add("Image", typeof(byte[]));   
   
//To add the image for the ImageColumn   
Byte[] imageArray = System.IO.File.ReadAllBytes(FindFile(@"flower" + i % 3 + ".jpg"));   
dataRow[3] = imageArray;   
   
//To set the datasource   
this.gridGroupingControl1.DataSource = dataTable;   
   
   
Sample link: http://www.syncfusion.com/downloads/support/forum/132638/ze/ByteArray_Image-1025487481    
   
Suggestion 2   
   
In order to load the image for an Image CellType column, the following ways can also be used,   

QueryCellStyleInfo event.
Using Appearance property.
  
Please refer to the below KB link.   
KB link: https://www.syncfusion.com/kb/6279/how-to-load-a-image-for-a-column-in-gridgroupingcontrol   
   
Regards,   
Arulpriya