วิธี Report .RDLC to ไฟล์ PDF ถ้ามีฐานข้อมุลแล้ว เชื่อมต่อฐานข้อมูลกับ data set แล้ว มีฟอมรีพอท RDLC แล้ว ฟังก์ชั่นที่ใช้เขียน

Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string filenameExtension;

byte[] bytes = reportViewer.LocalReport.Render(
    "PDF", null, out mimeType, out encoding, out filenameExtension,
    out streamids, out warnings);

using (FileStream fs = new FileStream("output.pdf", FileMode.Create))
{
    fs.Write(bytes, 0, bytes.Length);
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using Microsoft.Reporting.WebForms;
using System.Text;
using System.IO;
using System.Web.Configuration;
using PdfSharp.Drawing;
using PdfSharp.Pdf;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        PdfDocument DocPDF = new PdfDocument();
        PdfPage objPage = DocPDF.AddPage();
        XGraphics gfx = XGraphics.FromPdfPage(objPage);
        XFont font1 = new XFont("Verdana", 15, XFontStyle.Bold);

        DataSet ds = new DataSet();
        DataTable dt = new DataTable();

        SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConn"].ConnectionString) ;
        SqlCommand command = new SqlCommand();
        Conn.Open();
         string SQL = "SELECT * FROM tb_TRAIN";
        
        SqlDataReader rs = null;
        SqlDataAdapter dtapter = new SqlDataAdapter(SQL, Conn);
        command.CommandText = SQL;
        command.Connection = Conn;
        rs = command.ExecuteReader();
        LocalReport rpt = new LocalReport();


        rpt.ReportPath = "Report.rdlc";
        rpt.EnableExternalImages = true;
        rpt.EnableHyperlinks = true;
        rpt.DataSources.Clear();  
        dt.Columns.Add("empid");
        dt.Columns.Add("startdate");
        dt.Columns.Add("enddate");
        dt.Columns.Add("expdate");
        dt.Columns.Add("result");
        dt.Columns.Add("updater");
        dt.Columns.Add("update");
        dt.Columns.Add("certid");
        dt.Columns.Add("day");
        dt.Columns.Add("hour");
        
        DataRow dr = dt.NewRow();

        while (rs.Read())
        {
            
            dr = dt.NewRow();
            dr["empid"] = rs[0].ToString();
            dr["startdate"] = rs["fl_startdate"].ToString();
            dr["enddate"] = rs["fl_enddate"].ToString() ;
            dr["expdate"] = rs["fl_expdate"].ToString();
            dr["result"] = rs["fl_result"].ToString();
            dr["updater"] = rs["fl_updater"].ToString();
            dr["update"] = rs["fl_update"].ToString();
            dr["certid"] = rs["fl_certid"].ToString();
            dr["day"] = rs["fl_day"].ToString();
            dr["hour"] = rs["fl_hour"].ToString();
            dt.Rows.Add(dr);
        }


        rs.Close();
        rs = null;
        Conn.Close();
        rpt.DataSources.Add(new ReportDataSource("DataSet1", dt));
        rpt.ReportPath = "Report.rdlc";
        rpt.Refresh();
      
      


       String FileName = "MyPDF/PdfDoc.pdf";
       
         DocPDF.Save(Server.MapPath(FileName));
        
        DocPDF.Close();
        DocPDF = null;
        this.lblText.Text = "PDF Created <a href=" + FileName + ">click here</a> to view";
    
    
    }
}

SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConn"].ConnectionString) ;