blob

[Hrvoje Voda]

I'm using this code to get blob from sql server, but I get an error
"Parameter is invalid."

SqlDataReader sqlRead = null;

Image profile;
db.sqlConnectio n.Open();

System.Data.Sql Client.SqlComma nd ProfileBLOBSele ct = new
System.Data.Sql Client.SqlComma nd();

ProfileBLOBSele ct.CommandText = "dbo.[AppProfileSelec tIDBLOB]";

ProfileBLOBSele ct.CommandType = System.Data.Com mandType.Stored Procedure;

ProfileBLOBSele ct.Connection = db.sqlConnectio n;

ProfileBLOBSele ct.Parameters.A dd(new
System.Data.Sql Client.SqlParam eter("@RETURN_V ALUE",
System.Data.Sql DbType.Int, 4, System.Data.Par ameterDirection .ReturnValue,
false, ((System.Byte)( 0)), ((System.Byte)( 0)), "",
System.Data.Dat aRowVersion.Cur rent, null));

ProfileBLOBSele ct.Parameters.A dd(new
System.Data.Sql Client.SqlParam eter("@AppProfi leID",
System.Data.Sql DbType.UniqueId entifier, 16));

ProfileBLOBSele ct.Parameters["@AppProfil eID"].Value = row.AppProfileI D;

sqlRead = ProfileBLOBSele ct.ExecuteReade r();

if (sqlRead.Read() )

{

int iFileSize = sqlRead.GetInt3 2( 3 );

Byte[] arBuffer = new Byte[iFileSize];

sqlRead.GetByte s(4, 0, arBuffer, 0, iFileSize);

Stream str = new MemoryStream(ar Buffer);

str.Write(arBuf fer, 0, iFileSize);

profile = Image.FromStrea m(str); --> this one is invalid!

str.Close();

}

[dllhell]

"Hrvoje Voda" <hr*********@lu atech.com> wrote in message
news:e1******** **@ss405.t-com.hr...

I'm using this code to get blob from sql server, but I get an error
"Parameter is invalid."

This is code i use for getting crystals from blob.
I have not enaugh time for analysing your code but I hope so this will help
you.

{
string SQLappend="";
const string cQRY = "not so important";
DataSet DST = new DataSet("Crep_B LOB");
byte[] Arr_cRep = new byte[0];
DataRow DRow;

SqlDataAdapter SDA = new SqlDataAdapter( SQLappend, Conn);
SqlCommandBuild er CBuild = new SqlCommandBuild er(SDA);
SDA.Fill(DST, "Crep_BLOB" ); //table name

DRow = DST.Tables["Crep_BLOB"].Rows[0];
Arr_cRep = (byte[])DRow["crepdefaul t"];
int ArraySize = new int();
ArraySize = Arr_cRep.GetUpp erBound(0);
FileStream FStream = new
FileStream(@"c: \cRep_Temp\tRep ort.rpt", FileMode.OpenOr Create,
FileAccess.Writ e);
FStream.Write(A rr_cRep, 0, ArraySize);
FStream.Close() ;
FStream.Dispose ();
DRow.Delete();
}