protected void Page_Load(object sender, EventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { cLogEventos oLogEventos = new cLogEventos(ref oConn); DataTable dt = oLogEventos.Get(); XLWorkbook wb = new XLWorkbook(); wb.Worksheets.Add(dt, "LogEventos"); oConn.Close(); Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment;filename=SqlExport.xlsx"); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } } }
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { cLogEventos oLogEventos = new cLogEventos(ref oConn); oLogEventos.NkeyDeudor = hdd_nkey_deudor.Value; oLogEventos.NoContrato = txt_no_contrato.Text; oLogEventos.CodFlujo = dropdownflujo.SelectedValue; if ((RadDatePicker1.SelectedDate != null) && (RadDatePicker2.SelectedDate != null)) { oLogEventos.FchDesdeLog = RadDatePicker1.SelectedDate.Value.ToString("yyyyMMdd") + " 00:00:00"; oLogEventos.FchHastaLog = RadDatePicker2.SelectedDate.Value.ToString("yyyyMMdd") + " 23:59:59"; } RadGrid1.DataSource = oLogEventos.Get(); } oConn.Close(); }
public void ProcessRequest(HttpContext context) { DBConn oConn = new DBConn(); if (oConn.Open()) { cLogEventos oLogEventos = new cLogEventos(ref oConn); oLogEventos.NkeyDeudor = oWeb.GetData("sNkeyDeudor"); oLogEventos.NoContrato = oWeb.GetData("sNoContrato"); oLogEventos.CodFlujo = oWeb.GetData("sCodFlujo"); if ((!string.IsNullOrEmpty(oWeb.GetData("sRadDatePicker1"))) && (!string.IsNullOrEmpty(oWeb.GetData("sRadDatePicker2")))) { oLogEventos.FchDesdeLog = oWeb.GetData("sRadDatePicker1"); oLogEventos.FchHastaLog = oWeb.GetData("sRadDatePicker2"); } DataTable dt = oLogEventos.Get(); XLWorkbook wb = new XLWorkbook(); wb.Worksheets.Add(dt, "LogEventos"); oConn.Close(); context.Response.Clear(); context.Response.Buffer = true; context.Response.Charset = ""; context.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; context.Response.AddHeader("content-disposition", "attachment;filename=LogEventos.xlsx"); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(context.Response.OutputStream); context.Response.Flush(); context.Response.End(); } } }