I`m agree with Mike`s suggestion. Also as far as I know the equivalent of BLOB field (in MySQL) is VarBinary data type into MS SQL - please take a look at the attached screenshot and http://www.mssqltips.com/sqlservertutorial/2203/mysql-to-sql-server-data-type-comparisons/ . So I think that if you have an image in byte[] array format, you will be able to store this image into your MySQL database and also you will be able to represent the image back into our UltraGrid. To be sure that my assumption is correct, I created a small sample. In the sample I used MySql database with a column from BLOB data type. Also I convert my Bitmap and JPAG images into byte[] array format using the code below:

Bitmap bmp = new Bitmap(Resource1.Su_37);

ImageConverter converter = new ImageConverter();

ultraGrid1.ActiveRow.Cells["bimage"].SetValue(converter.ConvertTo(bmp, typeof(byte[])), false);

Please take a look at the attached video file for more details and if you have any questions, feel free to write us.

Regards

Hi,

What kind of data is in your BLOB and what do you want to do with it? The grid doesn't have any built-in support for BLOBs, so you probably just have to convert your BLOB into some kind of DotNet object before the grid can do anything with it.