Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 568
  • Last Modified:

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
0
cobolinx1
Asked:
cobolinx1
1 Solution
 
M3mph15Commented:
Hi,

You can write the data from the datareader into variable like this:

Datareader.Read()

String strData = Datareader.GetValue([index]).toString() 'index starts at 0 for the first item.

Is this a web application or a stand alone windows application.

HTH
-M3mph15
0
 
oobaylyCommented:
A Blob should be returned as Byte Array, so assuming you're using the SqlClient:
Dim reader As SqlDataReader = comm.ExecuteReader()
Dim blob As Byte() = Nothing
If (reader.Read()) Then
  blob = CType(reader("fldBlob"), GetType(Byte()))
End If

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now