Thanks and VWD

Thanks and VWD

• scroll

  Well I wasn't able to use your samples unhappily it converted and then wasn't useable for my purposes unfortunately.  I appreciate that you sent a reference though.
  
  I wasn't getting any response in the other areas so had to try in another forum if you have a way of moving a question to another forum to ask a question then I'm all ears.  Thanks.
  
  

• bobherm

  Hi,
  
  I have the same problem as you had in the beginning of your post.
  I would like to store images into my DB using VB.NET using a DetailsView.
  I tried the links as mentioned above, but without success.....
  
  Can someone help me on how I could store images into my SQL Database
  I can send my page(s) to if necessary...
  
  Thank you in advance....
  Bart
  
  

• Amorous

  Hi,
  
  
  Here are some samples that I think you'll be interested in...
  
  http://msdn2.microsoft.com/library/ms173033(en-us,vs.80).aspx
  http://msdn2.microsoft.com/library/4f5s1we0(en-us,vs.80).aspx
  
  Hope this helps.
  
  
  Note:
  Next time, please don't cross-post on other forum groups...
  http://forums.microsoft.com/msdn/ShowPost.aspx PostID=7746
  
  Here's you other post:
  http://forums.microsoft.com/msdn/ShowPost.aspx PostID=11496
  
  
  
  
  cheers,
  
  
  
  Paul June A. Domag
  Community Moderator
  
  
  

• CARR215

  Hi, I found this board searching online for help with uploading files to a folder. I'm using VS 2005 and Microsoft SQL Express Edition.

  Are we able to upload files into a folder then link it to a database How does the logic behind it work

  Are we able to use DetailsView for it

  Please help.Thanks

  
  

• justwanttoreportabug

  
  Storing an image in a SQL Server database is different from storing one in an Access database.  Access wraps the contents of the images and other data types in an OLE header so that when you double-click on the cell in Access you launch the application that manages that data, whether that's Paint, Excel, Word, etc.  One drawback to this approach is that it really only works inside of Access or other components that have a deep understanding of the structure of the headers that Access is using.
  
  SQL Server doesn't use headers to manage images.  Instead, you store the contents of the file in a large binary data type.  The name of the data type in SQL Server is image, though many refer to this data type as a BLOB or a long varbinary.  Even though the name may imply that the database understands that the data is an image, as far as SQL Server is concerned the data is merely a long series of 1's and 0's.
  
  The links that Paul included illustrate how you can store the contents of the image files in the database and use with Streams and Image objects within your .NET code.
  
  Another approach is to store the image files in a separate location, such as an internal share or Web site, and store the file locations in the database.
  
  I hope this information proves helpful.
  
  David Sceppa
  Microsoft
  

  
  
  

• Liviu Uba

  Thanks for your explanation, that does clarify the differences and the whys and wherefores.   I figured out how to link up images while storing them in a centralized folder which seems to work fine. 
  
   I have a slightly different problem at this stage of development and I wondered if you could do as much for this problem.  I created an extensive application using VWD and have at this stage worked out most of the kinks through trial an error and reading online resources, however, I am unable to figure this one out.  I have approximately 2500 users and a small but significant percentage use Mac Computers.  The Mac users are only able to log on using a Netscape 7.0 browser and when within the application they can upload photos and files no problem.  However in the data entry pages which I've created using the details data entry they are unable to edit, they can start a new entry and enter as far as I can understand but not edit.   But they have a significant problem using the site.  Can you tell me is there a fix for this
  
  Thank You
  Debbie
  
• Thanks and VWD