protected void btnExport_Click(object sender, EventArgs e) { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename = InProcess.xls"); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); GrdInProcessCompletedScheduleStatus.AllowPaging = false; BindGrdInProcessCompletedScheduleStatus(); GrdInProcessCompletedScheduleStatus.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); }
protected void BindGrdInProcessCompletedScheduleStatus() { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@OPR", "44"), new SqlParameter("@ScheduleTypeId", "2"), new SqlParameter("@ShiftCode", lblshift.Text.Trim()) }; DataTable Dt = new DataTable(); Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA"); GrdInProcessCompletedScheduleStatus.DataSource = Dt; GrdInProcessCompletedScheduleStatus.DataBind(); } catch (Exception ex) { _logger.Error(string.Concat("BindGrdProcessCompletedScheduleStatus::", ex.Message), ex); } }