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; } }
RAJANIKANT HAWALDAR
Can u help on Anydesk
i will try all method please help me
https://www.c-sharpcorner.com/UploadFile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/
Attachment: Desktop.rar
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
How to use tell me
I will try but same error
can u send me full code
bunifuPictureBox6.Invoke(new MethodInvoker( delegate() { bunifuPictureBox6.Image = Image.FromStream(ms); bunifuPictureBox6.SizeMode = PictureBoxSizeMode.StretchImage; }));
Can u send me code or post link
Use UI thread to set image