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.sqlConnection.Open();
System.Data.SqlClient.SqlCommand ProfileBLOBSelect = new
System.Data.SqlClient.SqlCommand();
ProfileBLOBSelect.CommandText = "dbo.[AppProfileSelectIDBLOB]";
ProfileBLOBSelect.CommandType = System.Data.CommandType.StoredProcedure;
ProfileBLOBSelect.Connection = db.sqlConnection;
ProfileBLOBSelect.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@RETURN_VALUE" ,
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue,
false, ((System.Byte)(0)), ((System.Byte)(0)), "",
System.Data.DataRowVersion.Current, null));
ProfileBLOBSelect.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@AppProfileID" ,
System.Data.SqlDbType.UniqueIdentifier, 16));
ProfileBLOBSelect.Parameters["@AppProfileID"].Value = row.AppProfileID;
sqlRead = ProfileBLOBSelect.ExecuteReader();
if (sqlRead.Read())
{
int iFileSize = sqlRead.GetInt32( 3 );
Byte[] arBuffer = new Byte[iFileSize];
sqlRead.GetBytes(4, 0, arBuffer, 0, iFileSize);
Stream str = new MemoryStream(arBuffer);
str.Write(arBuffer, 0, iFileSize);
profile = Image.FromStream(str); --> this one is invalid!
str.Close();
}