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();
}