How to Populate database records into existing editable pdf?

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 < ds.Tables[0].Rows.Count; 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());
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Pramod Peyyala8y ago
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 < ds.Tables[0].Rows.Count; 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());
}
0