How to direct Image retrieve with sql

Question

I will try image 3 diffrent image 3 diffrent pic box

==================================================

Name Duration image

================================================

abc 16350 0xx0xxxx326x26x6x6x656a5

azc 150 0xx0xxxx326x26x6x6x656a5

xyz 2000 0xx0xxxx326x26x6x6x656a5

==================================================

i will make table expale i wan retrive image 3 mulitu picbox

Guest User · Answer

USE [BiometricDB] GO /****** Object: StoredProcedure [dbo].[sp_GetTop3VolunteerReport] Script Date: 28/10/2022 13:07:01 ******/ 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 sql Server Like this Full Name Total Duration Profile Photo H.M Shabbir Shaban Ali Chagani 165235 0xFFD8FFE000104A46494600010100000100010000FFDB0084000606060607 Saleem Nooruddin Mukhida 85598 0xFFD8FFE000104A46494600010100012C012C0000FFE10584457869660000 Aman Amir Ali 81477 0xFFD8FFE000104A46494600010100012C012C0000FFE10584457869660000 Data Get Form configurationBLL.GetTopVolunteer(); I Need image call form profile Photo DataSet dataSet1 = configurationBLL.GetTopVolunteer(); label31.Text = dataSet1.Tables[0].Rows[0][0].ToString(); label34.Text = dataSet1.Tables[0].Rows[1][0].ToString(); label36.Text = dataSet1.Tables[0].Rows[2][0].ToString();

Rajanikant Hawaldar · Answer

Refer below article https://www.c-sharpcorner.com/UploadFile/5089e0/show-image-in-gridview-using-Asp-Net/