blob from database

[Hrvoje Voda]

How to read a blob from database into an array byte ?

Hrcko

 

[Mateusz [PEYN] Adamus]

Hrvoje Voda napisa³(a):

How to read a blob from database into an array byte ?

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

 

[Hrvoje Voda]

This is fine,

but I'm using store procedure to get blob.

How to put a store procedure result into an array?

Hrvoje Voda napisa³(a):

How to read a blob from database into an array byte ?

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

 

[Mateusz [PEYN] Adamus]

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?

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

 

[Ignacio Machin \( .NET/ C# MVP \)]

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,