From Google Analytics, it is obvious that most of the people who come here have been looking for PDF and iTextSharp info.
Well, iTextSharp is nice and lets you do wonderful things, given abundant time, but for that simple “Give me a tabular PDF from a database query” GiosPDF on CodeProject is a gem.
I have wrapped it up in a class, so that you can just give a datatable, and voila there’s your PDF report i 3 easy steps:
1) PDFfromSQL(string connectionstring, string listname, string author)
2) AddSQL(string SQLcmd, string header)
The source code is in a zip here.