Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>As @Jon Skeet said, you can use iTextSharp (which is a C# port of the Java iText).</p> <p>First, <a href="http://sourceforge.net/projects/itextsharp/files/itextsharp/iTextSharp-5.1.2/itextsharp-all-5.1.2.zip/download?_test=goal">download iTextSharp</a> (currently 5.1.2), extract <code>itextsharp.dll</code> to some location and add a reference to it in Visual Studio. Then use the following code which is a full-working WinForms app that creates a very basic table in an A4 document. See the comments in the code for more of an explanation.</p> <pre><code>using System; using System.Text; using System.Windows.Forms; using System.IO; using iTextSharp.text; using iTextSharp.text.pdf; namespace Full_Profile1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { //This is the absolute path to the PDF that we will create string outputFile = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "Sample.pdf"); //Create a standard .Net FileStream for the file, setting various flags using (FileStream fs = new FileStream(outputFile, FileMode.Create, FileAccess.Write, FileShare.None)) { //Create a new PDF document setting the size to A4 using (Document doc = new Document(PageSize.A4)) { //Bind the PDF document to the FileStream using an iTextSharp PdfWriter using (PdfWriter w = PdfWriter.GetInstance(doc, fs)) { //Open the document for writing doc.Open(); //Create a table with two columns PdfPTable t = new PdfPTable(2); //Borders are drawn by the individual cells, not the table itself. //Tell the default cell that we do not want a border drawn t.DefaultCell.Border = 0; //Add four cells. Cells are added starting at the top left of the table working left to right first, then down t.AddCell("R1C1"); t.AddCell("R1C2"); t.AddCell("R2C1"); t.AddCell("R2C2"); //Add the table to our document doc.Add(t); //Close our document doc.Close(); } } } this.Close(); } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POC#, Winform - creating PDF
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChris Haas
    1. USChris Haas
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POC#, Winform - creating PDF
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO... and don't forget that you should pay for iTextSharp if you are going to use it in a closed source application.
      singulars
      1. PO
      1. USBobrovsky
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload