Click here to Skip to main content
15,883,809 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Friends

I have insert image into SQL server using following code:

SQL
----------------------------------
CREATE TABLE Employees 
( 
    Id int, 
    Name varchar(50) not null, 
    Photo varbinary(max) not null 
) 
 
 
INSERT INTO Employees (Id, Name, Photo)  
SELECT 10, 'John', BulkColumn  
FROM Openrowset( Bulk 'D:\logo.bmp', Single_Blob) as EmployeePicture 

------------------------------

Now i want to show it in picture box in C# GUI . Please help me to fatch image from SQL to GUI . The main purose of this code is that i want when i update new image in SQL then it should be changed in GUI because its link from SQl.

Thanks in advance.
Posted

1 solution

See this CP article:
Sending/Receiving PictureBox Image in C# To/From Microsoft SQL SERVER[^]

Found it on a simple search here[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900