InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumWed, 10 Jun 2026 20:36:14 GMT20http://forum.strataframe.net/FindPost4739.aspxI was going to try out this serializable thingy, i.e. try to store a bitmap (are other image types supported?) in a table field. What should the SQL column be defined as? varbinary? varchar?Wed, 22 Nov 2006 16:39:40 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4758.aspxThanks!Wed, 22 Nov 2006 16:39:40 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4756.aspx[quote]f MyPictureBox is bound via SF, then saving it should save the serialized bitmap back to db right? [/quote]</P><P>Correct.&nbsp;</P><P>[quote] The Generic Nullable didn't work. What is an appropriate replacement value? [/quote]</P><P>Just return an alternate value and put something like this:</P><P>[codesnippet]New CType(System.Drawing.Bitmap(1,1), System.Drawing.Image)[/codesnippet]Wed, 22 Nov 2006 16:22:58 GMTTrent L. Taylorhttp://forum.strataframe.net/FindPost4754.aspxAh...one more question (ok, maybe there will be more): How do I handle NULLs in the BO? I.e. the image may not be required, so how do I handle that. The Generic Nullable didn't work. What is an appropriate replacement value?Wed, 22 Nov 2006 15:52:37 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4753.aspxActually, I'm talking about WinForms. I think I might have figured it out. Something like:<br> <br> [codesnippet]<br> ' imageFile is the full path to an image<br> MyPictureBox.Image = CType(New Bitmap(imageFile), Image)<br> [/codesnippet]<br> <br> If MyPictureBox is bound via SF, then saving it should save the serialized bitmap back to db right?Wed, 22 Nov 2006 15:50:58 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4752.aspxThe column will be created as a Byte[] field on the business object, so if you set the field to any byte array, then you can just save it and it will dump it to the database.&nbsp; </P><P>However, if you're talking about letting your users upload things on your website... I'm not sure.&nbsp; There are controls you can use to upload objects to your webserver, and there might be one in the basic ASP.NET controls, but I've never used one.Wed, 22 Nov 2006 15:36:11 GMTStrataFrame Teamhttp://forum.strataframe.net/FindPost4749.aspxThanks! <br> <br> Next question: how do you allow a user to upload an image into this sort of field, so it can be saved?Wed, 22 Nov 2006 15:21:43 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4741.aspxYou will use a VarBinary(MAX) for SQL Server 2005 and Image for SQL Server 2000.Wed, 22 Nov 2006 13:13:38 GMTTrent L. Taylor