yes ..!! i did it :
call gridview. and generate pdf ..
if (dt8.Rows.Count > 0)
{
GridView GridView2 = new GridView();
GridView2.AllowPaging = false;
GridView2.DataSource = dt8;
GridView2.DataBind();
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView2.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate());
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;" +
"filename=JobcardDate_vehicleType.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
}
else
{
Response.Write("<script> alert('Reports Not Found')</script>");
}
and for date difference use BETWEEN .
like , data BETWEEN "" AND""