protected void btnExcel_Click(object sender, EventArgs e) { TestBLL test = new TestBLL(); DateTime dt = Convert.ToDateTime("24/06/2013"); DataTable dtExcel = new DataTable(); dtExcel = test.GetTypeWiseStockSummary("1", "1", dt); ExporttoExcel(dtExcel); }