How to Populate database records into existing editable pdf?

Question

I need to take the values from database in to existing and editable Pdf by using Asp.net.. Is there any solution?

Pramod Peyyala · Answer

Finally I get the solution. 1st we need to identify the pdf document form fields. for that open pdf document with Adobe arcobat dc, when we click on prepare form then it will display form fields of the document, assign database table values to that form fields. void Page_Load( object sender, EventArgs e) { MemoryStream ms = new MemoryStream(); PdfReader reader = new PdfReader(Request.MapPath( "~/editble.pdf" )); PdfStamper formFiller = new PdfStamper(reader, ms); AcroFields formFields = formFiller.AcroFields; MySqlCommand cmd = new MySqlCommand( "select * from example" , conn); DataSet ds = new DataSet(); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds); conn.Open(); if (! object .Equals(ds.Tables[0], null )) { if (ds.Tables[0].Rows.Count > 0) { for ( int i = 0; i { formFields.SetField( "Given Name Text Box" , ds.Tables[0].Rows[i][ "Gname" ].ToString()); formFields.SetField( "Family Name Text Box" , ds.Tables[0].Rows[i][ "Fname" ].ToString()); formFields.SetField( "Address 1 Text Box" , ds.Tables[0].Rows[i][ "addr1" ].ToString()); formFields.SetField( "House nr Text Box" , ds.Tables[0].Rows[i][ "hno" ].ToString()); formFields.SetField( "Address 2 Text Box" , ds.Tables[0].Rows[i][ "addr2" ].ToString()); formFields.SetField( "Postcode Text Box" , ds.Tables[0].Rows[i][ "postcode" ].ToString()); formFields.SetField( "City Text Box" , ds.Tables[0].Rows[i][ "city" ].ToString()); formFields.SetField( "Country Combo Box" , ds.Tables[0].Rows[i][ "country" ].ToString()); formFields.SetField( "Gender List Box" , ds.Tables[0].Rows[i][ "gender" ].ToString()); formFields.SetField( "Height Formatted Field" , ds.Tables[0].Rows[i][ "height" ].ToString()); formFields.SetField( "Driving License Check Box" , ds.Tables[0].Rows[i][ "driving" ].ToString()); formFields.SetField( "Language 1 Check Box" , ds.Tables[0].Rows[i][ "languages" ].ToString()); formFields.SetField( "Favourite Colour List Box" , ds.Tables[0].Rows[i][ "color" ].ToString()); } } } formFiller.FormFlattening = true ; formFiller.Close(); reader.Close(); Response.ContentType = "application/pdf" ; Response.AddHeader( "Content-Disposition" , "attachment; filename=test.pdf" ); Response.BinaryWrite(ms.ToArray()); }

How to Populate database records into existing editable pdf?

Answers (1)