private void ViewGrid(int ID)
{
SqlConnection conn = null;
SqlDataReader rdr = null;
MainController _cnt = new MainController();
try
{
GridView.DataSource = _cnt.ViewGrid(ID).ExecuteReader();
GridViewLink.DataSource = _cnt.ViewGridLinks(ID).ExecuteReader();
GridView.DataBind();
GridViewLink.DataBind();
}
catch (Exception ex)
{
label_Grid.Text += ex.Message;
}
finally
{
if (conn != null)
{
conn.Close();
}
if (rdr != null)
{
rdr.Close();
}
}
}
protected void btn_Click(object sender, EventArgs e)
{
GridViewLink link = new GridViewLink(exporter);
link.CreateMarginalHeaderArea += new CreateAreaEventHandler(link_CreateMarginalHeaderArea);
link.CreatePS();
link.CreateDocument();
using (MemoryStream stream = new MemoryStream()) {
link.PrintingSystem.ExportToPdf(stream);
Response.Clear();
Response.Buffer = false;
Response.AppendHeader("Content-Type", "application/pdf");
Response.AppendHeader("Content-Transfer-Encoding", "binary");
Response.AppendHeader("Content-Disposition", "attachment; filename=grid.pdf");
Response.BinaryWrite(stream.GetBuffer());
Response.End();
}
}
