Spread provides data binding feature which allows you to bind Spread to different types of data sources. Please refer to the following link that describes how you can bind Spread to a data source: http://helpcentral.componentone.com/NetHelp/SpreadNet6/ASP2/spweb-databound.html The data kept in the database varies from text to boolean to images. Spread loads the textual, numeric or boolean data directly by assigning the specific celltypes to the specific column. The celltype of the column depends on the type of data contained in it. As an example, textual data is loaded with TextCellType, while numbers are loaded with CurrencyCellType, IntegerCellType or DoubleCellType. However, the images saved in the database are not loaded directly. The images are basically saved as byte arrays, so when a Spread column is bound to any such column, it simply loads the byte array object in the cell. This blog discusses how you can load the images in Spread. Spread follows the general approach used by other grids to load the images from the database. The byte arrays kept in the database are converted to a bitmap image. Once, the bitmap image is created, it is saved within a folder in the project so that it can be accessed directly. Here is the code snippet:
At the end, you would need to change the celltype for the cell to an ImageCellType. The ImageCellType is used to display images in Spread. Please refer to the following link that describes the same: http://helpcentral.componentone.com/NetHelp/SpreadNet6/ASP2/spweb-setimagecell.html As described in the link above, the ImageUrl property of ImageCellType is used to load the images in the cell. So, simply assign the specific image url to the celltype, and assign the celltype to the cell. You would need to create a new instance of ImageCellType for each cell as a new image is to be loaded in each cell. Here is the code snippet that describes the same:
Samples with complete implementations are attached. Download Sample C# Download Sample VB