How Do I Fetch Data From Mysql Database In C# And Create A PDF?

Upload and start working with your PDF documents.
No downloads required

How To Create PDF Online?

Upload & Edit Your PDF Document
Save, Download, Print, and Share
Sign & Make It Legally Binding

Easy-to-use PDF software

review-platform review-platform review-platform review-platform review-platform

How do I fetch data from MySQL database in C# and create a PDF?

ConnetionString = "Data Source=YourServerName;Initial Catalog=pubs;User ID=sa;Password=zen412"; sql = "select pub_name,city,country from publishers"; connection = new SqlConnection(connetionString); connection.Open ; command = new SqlCommand(sql, connection); adapter.SelectCommand = command; adapter.Fill(ds); connection.Close ; PdfDocument pdf = new PdfDocument ; pdf.Info.Title = "Database to PDF"; PdfPage pdfPage = pdf.AddPage ; XGraphics graph = XGraphics.FromPdfPage(pdfPage); XFont font = new XFont("Verdana", 20, XFontStyle.Regular ); pubname = ds.Tables[0].Rows[i].ItemArray[0].ToString ; city = ds.Tables[0].Rows[i].ItemArray[1].ToString ; state = ds.Tables[0].Rows[i].ItemArray[2].ToString ; graph.DrawString(pubname, font, XBrushes.Black, new XRect(40, yPoint, pdfPage.Width.Point, pdfPage.Height.Point), XStringFormats.TopLeft); graph.DrawString(city, font, XBrushes.Black, new XRect(280, yPoint, pdfPage.Width.Point, pdfPage.Height.Point), XStringFormats.TopLeft); graph.DrawString(state, font, XBrushes.Black, new XRect(420, yPoint, pdfPage.Width.Point, pdfPage.Height.Point), XStringFormats.TopLeft); full source... http.//csharp.net-informations.com/file/dbtopdf.htm

Customers love our service for intuitive functionality

4.5

satisfied

46 votes

Create PDF: All You Need to Know

A small example for the basic HTTP protocol, using the W3 C Sharp HTTP C# Get, set, delete.

What Our Customers Say

Deborah W.
Deborah W.
I corrected a mistake in my form and replaced it with the right information. It took a few minutes only! Thanks a lot!
James S.
James S.
The process of PDF correction has never been so easy. I’ve managed to create a new document faster than ever before!
William G.
William G.
It was really easy to fill out my PDF document and add a signature to it! This is a great service! I recommend it to you!
Denis B.
Denis B.
I edited the document with my mobile phone. It was fast and, as a result, I’ve got a professional-looking document.

Supporting Forms

Submit important papers on the go with the number one online document management solution. Use our web-based app to edit your PDFs without effort. We provide our customers with an array of up-to-date tools accessible from any Internet-connected device. Upload your PDF document to the editor. Browse for a file on your device or add it from an online location. Insert text, images, fillable fields, add or remove pages, sign your PDFs electronically, all without leaving your desk.