ASP.NET

 public static Bitmap CreateThumbnail(string lcFilename,int lnWidth, int lnHeight)<br />
<br />
  {<br />
            System.Drawing.Bitmap bmpOut = null;<br />
            try <br />
            {<br />
                  Bitmap loBMP = new Bitmap(lcFilename);<br />
                  ImageFormat loFormat = loBMP.RawFormat;<br />
                  decimal lnRatio;<br />
                  int lnNewWidth = 0;<br />
                  int lnNewHeight = 0;<br />
<br />
                  //*** If the image is smaller than a thumbnail just return it<br />
                  if (loBMP.Width < lnWidth && loBMP.Height < lnHeight) <br />
<br />
                        return loBMP;<br />
<br />
                  if (loBMP.Width > loBMP.Height)<br />
<br />
                  {<br />
                      lnRatio = (decimal) lnWidth / loBMP.Width;<br />
<br />
                        lnNewWidth = lnWidth;<br />
<br />
                        decimal lnTemp = loBMP.Height * lnRatio;<br />
<br />
                        lnNewHeight = (int)lnTemp;<br />
<br />
                  }<br />
<br />
                  else <br />
<br />
                  {<br />
                        lnRatio = (decimal) lnHeight / loBMP.Height;<br />
<br />
                        lnNewHeight = lnHeight;<br />
<br />
                        decimal lnTemp = loBMP.Width * lnRatio;<br />
<br />
                        lnNewWidth = (int) lnTemp;<br />
<br />
                  }<br />
                  // System.Drawing.Image imgOut = <br />
<br />
                  //      loBMP.GetThumbnailImage(lnNewWidth,lnNewHeight,<br />
<br />
                  //                              null,IntPtr.Zero);<br />
                 <br />
                  // *** This code creates cleaner (though bigger) thumbnails and properly<br />
<br />
                  // *** and handles GIF files better by generating a white background for<br />
<br />
                  // *** transparent images (as opposed to black)<br />
<br />
                  bmpOut = new Bitmap(lnNewWidth, lnNewHeight);<br />
<br />
                  Graphics g = Graphics.FromImage(bmpOut);<br />
<br />
                  g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;<br />
<br />
                  g.FillRectangle( Brushes.White,0,0,lnNewWidth,lnNewHeight);<br />
<br />
                  g.DrawImage(loBMP,0,0,lnNewWidth,lnNewHeight);<br />
<br />
                  loBMP.Dispose();<br />
<br />
            }<br />
<br />
            catch <br />
<br />
            {<br />
                  return null;<br />
            }<br />
<br />
            return bmpOut;<br />
      }<br />
<br />
}

SELECT P.ID<br />
FROM PERSONNEL AS P<br />
INNER JOIN COURSES AS C<br />
ON P.ID = C.PERSONNEL_ID<br />
INNER JOIN EDUCATION AS E<br />
ON P.ID = E.PERSONNEL_ID