How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?
80 pts.
0
Q:
How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?
            After a lot of trying and hard work I finally manged to store an image into an SQL Server database using a byte array. But now I'm stuck at how to retrieve it back into my application's picture box control. 
            This is what I need to do: I need to retrieve the saved image straight back into my application's picture box control. Is it possible? How to do that? Please help!!!


Software/Hardware used:
VB.NET 2005, SQL Server 2005 Express Edition
ASKED: Sep 6 2009  2:19 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
46735 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
It is usually recommended that you not store graphics within the database. The database will quickly become a performance bottleneck and you will see your database grow quickly to a very large size.

That said, I posted an answer to a similar question up on the SearchSQLServer.com site in the mailbag last week. It's very high level as I'm not a programmer, but should give you a starting point.
Last Answered: Sep 7 2009  9:13 PM GMT by Mrdenny   46735 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0