Loading images from SQL 2000 to VB6
-
I need help in displaying personnel photos stored in a SQL 2000 table either in a field with datatype image or a field with datatype nvarchar which has the path to the photo. Which is better to use? I have a vb6 project with a Picture box, but when I set the DataField property to the field name, the photo does not display. I have a DataGrid that lists each personnel name, so I want to be able to select a record and the person's picture displays in the Picture box. The DataGrid's DataSource property is set to an ADODC data control. I can do this easily with the table being in Access using the OLE control and setting the DataField property to the field name in the Access table. But the user wants to move the tables to SQL 2000 and wants to update the VB6 project to use ADODC data controls instead of the intrinsic data control. Any help would be greatly appreciated. And I thought this would be an easy task. :confused: