How To Create PDF
Download "create pdf from database table .zip"
html_pdf_net.zip
Convert in Excel Formt zip File
public partial class _Default : System.Web.UI.Page
{
private SqlConnection con = new SqlConnection(
ConfigurationManager.ConnectionStrings["SQLConnection"].ConnectionString);
private SqlCommand comm = new SqlCommand();
private SqlDataReader dreader;
protected void Page_Load(object sender, EventArgs e)
{
int total = 0;
// read data from data base table
comm.Connection = con;
comm.CommandText = "select * from Products";
try
{
con.Open();
dreader = comm.ExecuteReader();
while (dreader.Read())
{
TableRow row = new TableRow();
Table1.Rows.Add(row);
row.Cells.Add(new TableCell());
row.Cells[0].Text = "id " + dreader["pkey"].ToString();
row.Cells.Add(new TableCell());
row.Cells[1].Text = dreader["product_name"].ToString();
row.Cells.Add(new TableCell());
row.Cells[2].Text = ((DateTime)dreader["date"]).ToShortDateString();
row.Cells.Add(new TableCell());
row.Cells[3].Text = dreader["amount"].ToString();
total += (int)dreader["amount"];
}
Label2.Text = total.ToString();
Label3.Text = total.ToString();
con.Close();
}
catch { }
// get html code of the report
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlWriter = new HtmlTextWriter(objStringWriter);
Panel1.RenderControl(objHtmlWriter);
string html_form = objStringWriter.ToString();
// convert to pdf
try
{
DuoDimension.HtmlToPdf conv = new DuoDimension.HtmlToPdf();
conv.OpenHTML(html_form);
conv.SavePDF(MapPath("~/Pdf/") + "test.pdf");
}
catch {}
}
