Click here to Skip to main content
12,508,112 members (54,662 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# SQL
Dear Friends

I have insert image into SQL server using following code:

----------------------------------
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 17-Sep-12 0:52am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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

Found it on a simple search here[^]
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160927.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100