Post reply

Image Data Type & ADO Retrieval

  • October 4, 2005 at 8:22 am

    #89561

    Well, I first asked for info on SQL Image Data Type, use etc. Now to be more specific I need to know if anyone has worked with a MemoryStream in this context and using ADO recordsets to retrieve the data thru SP. Problem is designing the interface to display the data.

  • October 4, 2005 at 9:15 am

    #594886

    First, I assume since you said "MemoryStream" you are talking .Net.  Yes, you can get a dataset in ADO.Net to get an image datatype and load it into a MemoryStream.

    But you do not specify if you looking to Winforms or Webforms.  For Winforms, you can use a Image class and read the MemoryStream directly to the control.  For Webforms, you will need to save the MemoryStream to a file in the web directory, then reference that file in the web page's Image control.

    Hope this helps



    Mark

  • October 4, 2005 at 9:35 am

    #594896

    Hi Mark

    Yes, it's VB.Net I'm currently working with, and the actual issue is the actual coding of the ADO Recordset Image data type into a memory stream, then populating a picturebox with the image. Hope this explains my problem better

  • October 4, 2005 at 9:45 am

    #594904

    How about this MSKB article?

    HOW TO: Copy a Picture from a Database Directly to a PictureBox Control with Visual Basic .NET



    Mark

  • October 4, 2005 at 11:38 am

    #594939

    Thanks Mark, it was exactly what I needed

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply