DevForce Community Forum : insert update blobs http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : insert update blobs Thu, 11 Jun 2026 21:11:50 -700 Thu, 06 Sep 2007 14:57:07 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=411 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ insert update blobs : A possible workaround to the DataRowState... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1111#1111 Author: Linguinut
Subject: 411
Posted: 06-Sep-2007 at 2:57pm

A possible workaround to the DataRowState is to modifiy the ModTs property and set it to the current time.  In this little app, it shouldn't have any negative ramifications (beware: possible concurrency issues in larger apps).  That sets the state to Modified; except, the picture does not update, now.  Quite odd.  I comment out the update of ModTs and, now, the picture changes.  Another stumper.
 
***Fixed:  I moved the update of the ModTs before the image was set on the picturebox.  Now, on to the ImageToDatabase class.  Why was this left out of DevForce?  It seems so elementary.


Edited by Linguinut - 06-Sep-2007 at 3:03pm]]> Thu, 06 Sep 2007 14:57:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1111#1111 insert update blobs : My example primarily shows how... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1110#1110 Author: davidklitzke
Subject: 411
Posted: 06-Sep-2007 at 2:49pm

My example primarily shows how to assign an arbitrary photo to an individual and display it.  To save it you should convert it back to a blob and save it.  To do this, you need to write an ImageTobytes utility.

Edited by davidklitzke - 06-Sep-2007 at 2:50pm]]> Thu, 06 Sep 2007 14:49:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1110#1110 insert update blobs : Is this the proper syntax? Employee... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1108#1108 Author: Linguinut
Subject: 411
Posted: 06-Sep-2007 at 2:38pm

Is this the proper syntax?
 
Employee mCurrentEmp = (Employee)mEmpSource.Current;
mCurrentEmp.RowState = DataRowState.Modified;
 
**Nope--the RowState property is read-only.
Interesting. 


Edited by Linguinut - 06-Sep-2007 at 2:39pm]]> Thu, 06 Sep 2007 14:38:01 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1108#1108 insert update blobs : Sorry for my ignorance, but what... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1107#1107 Author: Linguinut
Subject: 411
Posted: 06-Sep-2007 at 2:33pm

Sorry for my ignorance, but what is the syntax for setting the datarowstate to modified on the current entity?  I assume, since you specified that I would need to figure out how to save to the database, that DevForce will not save the image to the database once the save method is called on the persistence manager?  So, if you could provide the syntax, I'll try to wire up the actual image save routine.
 
Thanks.
]]> Thu, 06 Sep 2007 14:33:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1107#1107 insert update blobs : The object (i.e., the employee)... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1101#1101 Author: davidklitzke
Subject: 411
Posted: 06-Sep-2007 at 2:12pm

The object (i.e., the employee) won't get saved unless its datarowstate gets set to MODIFIED.  Since the photo is readonly, it doesn't have a setter'

]]> Thu, 06 Sep 2007 14:12:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1101#1101 insert update blobs : Ouch! I imagine that the issue... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1100#1100 Author: Linguinut
Subject: 411
Posted: 06-Sep-2007 at 2:11pm

Ouch!  I imagine that the issue is the underlying database.  Different databases handle the storage of images differently, I suppose; therefore, IdeaBlade decided not to implement this piece of the puzzle, yet.  Is that right?
 
In the meantime, I am not sure what you mean by "setter".  And, why doesn't the cached entity change?  If I change a picture on one entity, move to the next entity, then back again, the picture always reverts back to the one in the database.  What else might be going on here, behind the scenes?
 
Thanks for your help!!
 
(I am casting my vote to move this feature up the priority list.  This ranks right behind CAB templates/wizards, for me.)
]]> Thu, 06 Sep 2007 14:11:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1100#1100 insert update blobs : You are correct. The .NET PictureBox... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1099#1099 Author: davidklitzke
Subject: 411
Posted: 06-Sep-2007 at 2:01pm

You are correct.
 
The .NET PictureBox (and also the corresponding controls in DevExpress and Infragistics) are readonly controls.
 
However, that is not to say that with a little work, you couldn't get some update and save capability.
 
(1) You'll need a setter for the PictureBox control, and a way to set the DataRow state to Modified
 
(2) You'll need a way to save the new bitmap to the database.
 
There is currently a low priority feature request in our Bug Tracking system to do this work.
 
]]> Thu, 06 Sep 2007 14:01:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1099#1099 insert update blobs : I added drag/drop to the form... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1098#1098 Author: Linguinut
Subject: 411
Posted: 06-Sep-2007 at 1:22pm

I added drag/drop to the form and was not able to get any new images dropped onto the form to update the database, either.  If the image property of the picturebox changes, shouldn't the databindings see that and consider it a change to the entity?]]> Thu, 06 Sep 2007 13:22:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1098#1098 insert update blobs : Thanks for the reply. The example... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1097#1097 Author: mw243270
Subject: 411
Posted: 06-Sep-2007 at 12:32pm

Thanks for the reply.

The example does indeed change the pic out, but "Save" doesn't recognize anything as being changed.

]]> Thu, 06 Sep 2007 12:32:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1097#1097 insert update blobs : I have attached a very simple... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1094#1094 Author: davidklitzke
Subject: 411
Posted: 06-Sep-2007 at 10:21am

I have attached a very simple solution that has a "Change Picture" button.  When you click this button, it changes the picture of Nancy Davolio to a picture of Margaret Peacock.
 
 
uploads/20070906_132132_Change_Picture.zip
]]> Thu, 06 Sep 2007 10:21:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1094#1094 insert update blobs : In the sample tutorial applications... http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1088#1088 Author: mw243270
Subject: 411
Posted: 05-Sep-2007 at 6:40pm

In the sample tutorial applications I don't see any mention of how to insert or update the employee pictures stored as blobs in the database. Can anyone provide insight on how to accomplish this?

]]> Wed, 05 Sep 2007 18:40:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=411&PID=1088#1088