Reading BLOB data from SQL using a datareader

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi all,

I have some working code that reads BLOBs from an
SQL database, but it reads them into a dataset. This
is fine for small BLOBs, but if they are large I want to
be able to retreive them only when needed. Therefore
I should like to use a datareader. Can this be done?
Does anyone have any sample code or useful
resources that could help me with this task.

Many thanks,

Jason.
.

Relevant Pages

  • Re: Reading BLOB data from SQL using a datareader
    ... Perhaps it will also have some relevance to what you are doing. ... David ... > I have some working code that reads BLOBs from an ... > is fine for small BLOBs, but if they are large I want to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Reading BLOB data from SQL using a datareader
    ... Regards, ... >I have some working code that reads BLOBs from an ... >is fine for small BLOBs, but if they are large I want to ... >Jason. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Documents are BLOBS?
    ... a69d9768.0408191151.46817eca@posting.google.com, "K Crisman" ... > BLOBs in the SQL database and are not saved in a file share on the ... > server. ...
    (microsoft.public.sharepoint.portalserver)