void btnExport_Click(object sender, EventArgs e) { DateTime startDate = rdiStartDate.SelectedDate.Value; startDate = startDate.Subtract(startDate.TimeOfDay); DateTime endDate = rdiEndDate.SelectedDate.Value; endDate = endDate.Subtract(endDate.TimeOfDay); endDate = endDate.Add(new TimeSpan(23, 59, 59)); Facade.IJobSubContractor facJobSubContractor = new Facade.Job(); DataSet dsSubbyExport = facJobSubContractor.GetSubbyReportWithLegRate(startDate, endDate); if (dsSubbyExport != null && dsSubbyExport.Tables.Count > 0) { Session["__ExportDS"] = dsSubbyExport.Tables[0]; Response.Redirect("../Reports/csvexport.aspx?filename=SubContractorReport.csv"); } }