public byte[] GetImageDB(Guid coid)
        {
            byte[] image = null;
            try
            {
                SqlCommand cmd = CreateCommand("getImage");
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@CoID", coid));

                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    if(reader.Read())
                    {
                        image = (byte[])reader["newsImage"];     
                    }
                    reader.Close();
                }

            }

            catch (SqlException e)
            {
                Debug.WriteLine("GetImageDB(): " + e.Message);
                throw e;

            }
            return  image;