Beispiel #1
0
        /// <summary>
        /// Loads an image from a column with the given name if one exists
        /// </summary>
        /// <param name="column"></param>
        /// <param name="reader"></param>
        /// <returns></returns>
        private System.Drawing.Image ImageFromColumn(string column, OdbcDataReader reader)
        {
            try
            {
                int ordinal = reader.GetOrdinal(column);
                if (!reader.IsDBNull(ordinal))
                {
                    MemoryStream ms = new MemoryStream();
                    using (Stream dbs = reader.GetStream(ordinal))
                    {
                        dbs.CopyTo(ms);
                    }

                    return(System.Drawing.Image.FromStream(ms));
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.StackTrace);
            }

            return(null);
        }