StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Add photo and Retrieve photo to/from sql server 2008

Add photo and Retrieve photo to/from sql server 2008

Diu King,Tiong — Tue, 23 Nov 2010 22:49:20 GMT

Hi all,

Please someone guide me a steps how to add photo and retrieve to/from sql server 2008.

For example i have a employee profile form and i wish to attach photo at that form.
Please don't only give the link because before i write this post i did search through all the post but i fail to understand it.

Thanks

(Using vb.net 2010 and sql server 2008)

RE: Add photo and Retrieve photo to/from sql server 2008

Edhy Rijo — Tue, 23 Nov 2010 22:49:20 GMT

Hi Diu,

I am glad you figured out, I was pretty busy today and could not provide any help in the forums.

RE: Add photo and Retrieve photo to/from sql server 2008

Diu King,Tiong — Tue, 23 Nov 2010 18:35:40 GMT

Hi Edhy,

I did it with your recommended strataflix sample already.

Thanks

RE: Add photo and Retrieve photo to/from sql server 2008

Diu King,Tiong — Tue, 23 Nov 2010 02:32:43 GMT

Hi Edhy,

i follow exactly from the straflix sample and i get the error. what step do i missed and please advice.
i just create the property (bitmap/binary conversion) inside BO and bind to my image field. Then i drag and drop a picturebox at my form and bind to my custom property.
i got the error message as below after run my form and click the new button.

Please advice.

Error Message:

BusinessLayerException
An error occurred while refreshing the data from field 'BO_hresEmployee.Photo' to property 'Image' on control 'PictureBox1.'
TargetInvocationException
Exception has been thrown by the target of an invocation.
MissingManifestResourceException
Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "BO_Library.Resources.resources" was correctly embedded or linked into assembly "BO_Library" at compile time, or that all the satellite assemblies required are loadable and fully signed.

Source : MicroFour StrataFrame Business

RE: Add photo and Retrieve photo to/from sql server 2008

Edhy Rijo — Sun, 21 Nov 2010 22:14:55 GMT

Hi,

Take a look at the StrataFlix sample application which have such a feature in one of its forms.