[Solved] How to load an image to Gridview from .net Datatable

[abhijith]

How can we load an image from SQL database (image stored as byte array) in image colum of gridview.
the grid binding is done through the .net datatable. Is it possible in this manner? if it is possible can i get a code sample...

thanx in advance...

expecting your valuable reply...

Regards
Abhijith

[Ваня]

Hello,abhijith

Check this out:
http://www.telerik.com/community/forums/wpf/gridview/gridviewimagecolumn-problem.aspx

Regards,Vanya

[Ahmet Özgür]

Hi,
can check this too

<telerik:GridViewImageColumn DataMemberBinding="{Binding OrijinalImage,Converter={StaticResource imgConverter}}" Header="Resim" ImageHeight="100" ImageWidth="100"/>

public class ImageConverter : IValueConverter
    {
        object IValueConverter.Convert(object value,
            Type targetType,
            object parameter,
            System.Globalization.CultureInfo culture)
        {
            if (value != null)
            {
                Binary bin = value as Binary;
                byte[] bytes = bin.ToArray();

                MemoryStream stream = new MemoryStream(bytes);

                BitmapImage image = new BitmapImage();
                image.BeginInit();
                image.StreamSource = stream;
                image.EndInit();


                return image;
            }

            return null;
        }

        object IValueConverter.ConvertBack(object value,
            Type targetType,
            object parameter,
            System.Globalization.CultureInfo culture)
        {
            BitmapImage bitmapImage = value as BitmapImage;
            MemoryStream stream = new MemoryStream();
            byte[] bytes = null;
            Binary bin = null;

            bitmapImage.StreamSource.Read(bytes, 0, (int)bitmapImage.StreamSource.Length);
            bin = new Binary(bytes);

            return bin;
        }