Display of BLOB field in Ultrawingrid

Hello sweish,

sweish said:
Image is stored in daatbase by the users

For me is interesting to see the code that stored the image in the database, because during this process we are able to convert images in a byte[] array and our BLOB field will keep this byte[] array. After that, while retrieving the images from the database, our grid will represent this image without any additional conversion. This is the approach that I used in my sample. If you are using different approach and if you need to convert your images into byte[] array, while retrieving these images from database, then you could try the code below:

conn.Open();
using (Command cmd = new Command(sqlCommand, conn))
{
      using (IDataReader dataReader = cmd.ExecuteReader())
      {
          while (dataReader.Read())
          {
             byte[] byteArray= (Byte[])dataReader["BLOBField"];

          }

         ultraGrid1.ActiveRow.Cells["bimage"].SetValue(byteArray,false);
      }
   }

Also for me is interesting to know what is your approach to connect with database. Are you using TableAdapters, SQL commands and so on...? Did you set Style property of your column to be Image ?

sweish said:
So there will not be any physical image file. Without storing the image anywhere while retrieving

OK. We do not need to have physical image file. I do not use such physical image file in my scenario.

If you have any questions, feel free to write me