I got this error when i call image fix it please

Guest User

	Name	Value	Type
?	ReadTimeout	'ms.ReadTimeout' threw an exception of type 'System.InvalidOperationException'	int {System.InvalidOperationException}

	Name	Value	Type
?	WriteTimeout	'ms.WriteTimeout' threw an exception of type 'System.InvalidOperationException'	int {System.InvalidOperationException}

if(dataSet1.Tables[0].Rows.Count > 0)
            {
                //bunifuPictureBox6.Image = null;
                if(dataSet1.Tables[0].Rows[0][2] != System.DBNull.Value) 
                {
                    photo_aray = (byte[])dataSet1.Tables[0].Rows[0][2];
                    MemoryStream ms = new MemoryStream(photo_aray);
               
                    bunifuPictureBox6.Image = Image.FromStream(ms);
                    bunifuPictureBox6.SizeMode = PictureBoxSizeMode.StretchImage;

                }
            }

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User3y ago
RAJANIKANT HAWALDAR

Can u help on Anydesk
Guest User3y ago
i will try all method please help me
Rajanikant Hawaldar3y ago
https://www.c-sharpcorner.com/UploadFile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/

Guest User3y ago

I Will Upload Image where i call data Check Desktop.zip File

USE [BiometricDB]
GO
/****** Object:  StoredProcedure [dbo].[sp_GetTop3VolunteerReport]    Script Date: 11/11/2022 05:08:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_GetTop3VolunteerReport]
AS
BEGIN
-- Top 3 Volunteer Report
SELECT 
	TOP 3 v.[displayfullname] AS [Full Name], SUM(t.duration) AS [Total Duration], CAST(v.[profilephoto] as Varbinary) AS [Profile Photo]
FROM 
	tblattendancelog t INNER JOIN 
	tblvolunteer v ON v.[volunteerid] = t.[volunteerid] 
WHERE
	t.[type] = 'Present' 
GROUP BY
	v.[volunteerid], v.[displayfullname], CAST(v.[profilephoto] as Varbinary) 
ORDER BY 
	SUM(duration) DESC
END

Guest User3y ago
How to use tell me

I will try but same error
Guest User3y ago
can u send me full code

Rajanikant Hawaldar3y ago

bunifuPictureBox6.Invoke(new MethodInvoker(
        delegate()
        {
          bunifuPictureBox6.Image = Image.FromStream(ms);
          bunifuPictureBox6.SizeMode = PictureBoxSizeMode.StretchImage;
        }));

Guest User3y ago
Can u send me code or post link
Rajanikant Hawaldar3y ago
Use UI thread to set image