cobolinx1
asked on
save blob to local variable
I've retrieved data using a datareader and some of the columns are blobs. While I'm reading the records I want to put the blobs in local variables to use them as parameters later when I insert them into another database. Currently I'm writing the blobs to pictures and then read them back in when I need them... for some cases this is good and others I want to just store them.How would I store them as just a local variable
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can write the data from the datareader into variable like this:
Datareader.Read()
String strData = Datareader.GetValue([index
Is this a web application or a stand alone windows application.
HTH
-M3mph15