blob from database

  • Thread starter Thread starter Hrvoje Voda
  • Start date Start date
Hrvoje Voda napisa³(a):
How to read a blob from database into an array byte ?
Click to expand...

You can first read it into DataSet (ds) and then do something like this:

foreach(DataRow dr in ds.Tables[0].Rows)
{
//assuming blob is in the first field
byte[] blobArray = (byte[])dr.ItemArray[0];
}

best regards
Mateusz [PEYN] Adamus
 
This is fine,

but I'm using store procedure to get blob.

How to put a store procedure result into an array?


Mateusz [PEYN] Adamus said:
Hrvoje Voda napisa³(a):
How to read a blob from database into an array byte ?
Click to expand...

You can first read it into DataSet (ds) and then do something like this:

foreach(DataRow dr in ds.Tables[0].Rows)
{
//assuming blob is in the first field
byte[] blobArray = (byte[])dr.ItemArray[0];
}

best regards
Mateusz [PEYN] Adamus
Click to expand...
 
Hrvoje Voda napisa³(a):
This is fine,

but I'm using store procedure to get blob.

How to put a store procedure result into an array?
Click to expand...

Hmm, try put result from stored procedure into DataSet (I think select
in the end of the SP should be enough) and then you know what to do.



bets regards
Mateusz [PEYN] Adamus
 
hi,

you just asked the same two days ago, as a matter of fact you posted later
yesterday/earlier today this same question in that thread which I just
responded :)

please, do not double post

cheers,
 
Back
Top