Page 2 of 2 FirstFirst 12
Results 41 to 42 of 42

Thread: [RESOLVED] Image control - now getting picture from DB - datasource??

  1. #41
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,123

    Re: [RESOLVED] Image control - now getting picture from DB - datasource??

    Quote Originally Posted by szlamany
    We store the size of the image in bytes along with the image - just as a double-check when we re-load later that we got the "amount" of image we expected.
    Ah okay, that clears that up. I thought you could have done it like this.

    Code:
    arBytes() = rs(0).GetChunk(rs(0).ActualSize)
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  2. #42

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: [RESOLVED] Image control - now getting picture from DB - datasource??

    Yes - that would be the size of the "stored image" - but having that extra column that actually "remembers" the original "size of stored image" would allow me to check "stored image" sizes and find corrupt images...

    We also store the original filename...
    Attached Images Attached Images  

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width