exporting to pdf doesnot working prperly?
Hi friends i am using the below code to print data's in pdf format with custom table...It runs but the data does not displayed in pdf document....Can any one help me out...
Code:
protected void Btndownload_Click(object sender, EventArgs e)
{
PdfPTable table = new PdfPTable(8);
//actual width of table in points
table.TotalWidth = 216f;
//fix the absolute width of the table
table.LockedWidth = true;
//relative col widths in proportions - 1/3 and 2/3
float[] widths = new float[] { 1f, 2f,3f,4f,5f,6f,7f,8f};
table.SetWidths(widths);
table.HorizontalAlignment = 0;
//leave a gap before and after the table
table.SpacingBefore = 20f;
table.SpacingAfter = 30f;
PdfPCell cell = new PdfPCell(new Phrase("Products"));
cell.Colspan = 2;
cell.Border = 0;
cell.HorizontalAlignment = 1;
table.AddCell(cell);
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("Select T_ID,BranchName,[Type],Brand,ReceivedDate,ReceivedStock,StockOnHand,(SoldDate+' '+[Time])as SoldDate,Quantity From StockManagement Where BranchName='" + DropDownList1.SelectedItem.Text + "' and SoldDate='" + DropDownList2.SelectedItem.Text + "' ", Con);
SqlDataReader rdr = cmd.ExecuteReader();
{
while (rdr.Read())
{
table.AddCell(rdr[0].ToString());
table.AddCell(rdr[1].ToString());
table.AddCell(rdr[3].ToString());
table.AddCell(rdr[4].ToString());
table.AddCell(rdr[5].ToString());
table.AddCell(rdr[6].ToString());
table.AddCell(rdr[7].ToString());
table.AddCell(rdr[8].ToString());
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
Document doc = new Document(PageSize.A2, 10f, 10f, 10f, 0f);
doc.Open();
doc.Add(table);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(doc);
Response.End();
}