How to write code for yeild the image from database, the image datatype is VARBINARY (MAX).
SqlCommand cmd = new SqlCommand(_sql, DBConnection.conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
return new AntiBiogramFile
{
fileID = rdr.GetInt32(rdr.GetOrdinal("fileID")),
fileLink = rdr.GetString(rdr.GetOrdinal("fileLink")),
fileName = rdr.GetString(rdr.GetOrdinal("fileName")),
uploadDate = rdr.GetDateTime(rdr.GetOrdinal("uploadDate"))
};
}