How can I display a recovered image from sql on image control in wpf?

Question

I put my pictures of letters in a separate table and I defined an foriegn key for that I now want to click on any data in the data grid view to show the photos of that level in the control of the image. I wrote the order for the retrieval of the photos, Of course, I do not know if it's right and I do not know how to control the image. code

        SqlConnection imageConnection = new SqlConnection(@"Data Source = ZAHRA; Initial Catalog = Baygani; inte");

        SqlCommand imageCommand = new SqlCommand(@"select Pictures.pic1,Pictures.pic2,Pictures.pic3,Pictures.pic4,Pictures.pic5,Pictures.pic6,Pictures.pic7,Pictures.pic8,Pictures.pic9,
         Pictures.pic10 from Pictures,Latters where Pictures.idlatter=Latters.id ", imageConnection);

        imageConnection.Open();
        SqlDataReader imageReader = imageCommand.ExecuteReader();

        string imageFilename = (string)imageReader.GetValue(0);
        byte[] imageBytes = (byte[])imageReader.GetValue(1);
        MemoryStream ms = new MemoryStream(imageBytes);

Assign the MemoryStream to the StreamSource property of a BitmapImage. Then assign the BitmapImage to the Source property of an Image element in your UI. — Clemens
– Clemens, Commented Nov 8, 2017 at 20:58

Clemens · Accepted Answer · 2017-11-09 09:32:37Z

1

Assuming that you are using Bindings to display your data in your UI and thus using viewmodels, I would suggest utilizing an ImageSource.

To initialize an ImageSource from a byte array I wrote the following method:

public ImageSource LoadImageSourceFromBytes(byte[] imageBytes)
{
    BitmapImage bitmapImage = new BitmapImage();

    using (MemoryStream imageStream = new MemoryStream(imageBytes))
    {
        bitmapImage.BeginInit();
        bitmapImage.StreamSource = imageStream;
        bitmapImage.CacheOption = BitmapCacheOption.OnLoad;
        bitmapImage.EndInit();
    }

    bitmapImage.Freeze();

    return bitmapImage;
}

edited Nov 9, 2017 at 9:32

Clemens

129k13 gold badges163 silver badges296 bronze badges

answered Nov 8, 2017 at 22:17

Wr4thon

5541 gold badge5 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

zahra Over a year ago

Can you explain more where should I write it? I added this function, but still I do not know how to display the photos in image control?

zahra Over a year ago

The app is made with WPF

Wr4thon Over a year ago

Do you use the MVVM Pattern in your Application? If so you have to put the Property in your ViewModel and from the View you use the Binding MarkupExtension to display the Image in the View. If not Assign a x:Name to the Image Control and in Code behind set the Source Property of that control to the Image you got from the Database. But I Highly recommend locking up MVVM (and use it) if you are not already.

Collectives™ on Stack Overflow

How can I display a recovered image from sql on image control in wpf?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related