public void getData(string query, int i)
{
con = new SqlConnection(str);
cmd = new SqlCommand(query, con);
if (i == 0)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridIssue.DataSource = ds;
GridIssue.DataBind();
con.Close();
}
else
{
con.Open();
SqlDataAdapter da2 = new SqlDataAdapter(cmd);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
GridReturned.DataSource = ds2;
GridReturned.DataBind();
con.Close();
}
}
protected void imgPDF_Click(object sender, ImageClickEventArgs e)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Issue_Records.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridIssue.AllowPaging = false;
getQuery = "select Issue_ID as 'Issue Id', IssueDate as 'Issue Date', ReturnDate as 'Return Date' , UserName as 'User Name' , BookName as 'Book Name', Category ,ActualReturnDate from IssueRecords";
getData(getQuery, 0);
GridIssue.RenderControl(hw);
GridIssue.HeaderRow.Style.Add("width", "15%");
GridIssue.HeaderRow.Style.Add("font-size", "10px");
GridIssue.HeaderRow.Style.Add("HorizontalAlign", "Center");
GridIssue.Style.Add("text-decoration", "none");
GridIssue.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
GridIssue.Style.Add("font-size", "8px");
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
protected void imgExcel_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Issue_Records.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridIssue.AllowPaging = false;
getQuery = "select Issue_ID as 'Issue Id', IssueDate as 'Issue Date', ReturnDate as 'Return Date' , UserName as 'User Name' , BookName as 'Book Name', Category ,ActualReturnDate from IssueRecords";
getData(getQuery, 0);
GridIssue.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
