CODEWITHSUNDEEP
c#entity-frameworkuser-controlspicturebox
Rizwan Qureshi
Rizwan Qureshi

Reputation: 592

Retrieve Image from SQL Server & set to PictureBox Image Property

I want to retrieve image from SQL Server(Database) using Entity Framework and set it to PictureBox Image Property I have maked a user control & inherit it to PictureBox (Name:DisplayImage)

    public static void LoadDisplay(Guid? DisplayID, string Name, byte[] image)
    {
        DisplayImage objDisplayImage = new DisplayImage();
        DisplayList.Add(objDisplayImage);
        objDisplayImage.Name = Name;
        MemoryStream ms = new MemoryStream(image);
        Image myImage = Image.FromStream(ms);
        objDisplayImage.Image = myImage;
        objDisplayImage.DisplayID = DisplayID;
        PlayerForm.Instance.Controls.Add(objDisplayImage);
    }

but Image is not loading on PictureBox

Upvotes: 1

Views: 1489

Answers (1)

Jibran Khan
Jibran Khan

Reputation: 3256

Try this code

try
{
    // get image from object
    byte[] _ImageData = new byte[0];
    _ImageData = (byte[])_SqlRetVal;
    System.IO.MemoryStream _MemoryStream = new System.IO.MemoryStream(_ImageData);
    _Image = System.Drawing.Image.FromStream(_MemoryStream);
}
catch (Exception _Exception)
{
    // Error occurred while trying to create image
    // send error message to console (change below line to customize error handling)
    Console.WriteLine(_Exception.Message);

    return null;
}

Upvotes: 1

Related Questions