Click here to Skip to main content
Rate this: bad
good
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 1: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
0 OriginalGriff 520
1 Maciej Los 290
2 Richard MacCutchan 265
3 BillWoodruff 235
4 Suraj Sahoo | Coding Passion 155
0 OriginalGriff 8,764
1 Sergey Alexandrovich Kryukov 7,437
2 DamithSL 5,639
3 Maciej Los 5,279
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web03 | 2.8.1411028.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2014
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