public void exportar() { Response.Clear(); Response.AddHeader("content-disposition", "attachment; filename = ReporteVenta.xls"); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); GvReporte.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); }
public void Buscar() { try { DateTime FechaFinal = Convert.ToDateTime(TxtFecFin.Value, new CultureInfo("es-ES")); FechaFinal = FechaFinal.AddDays(1); string FechaSalida = FechaFinal.ToString("dd/MM/yyyy"); GvReporte.DataSource = obj.ListarReporteVentaDistribuidor(TxtFechaInicio.Value.ToString(), FechaSalida.ToString(), Convert.ToString(DDVendedor.SelectedValue)); GvReporte.DataBind(); if (GvReporte.Rows.Count < 1) { BtnExportar.Visible = false; } else { BtnExportar.Visible = true; } }catch (Exception ex) { } }
public void Buscar() { //try //{ String Totall = ""; DataTable dt = new DataTable(); dt = obj.ReporteVendedorDistribuidor(TxtFechaInicio.Value.ToString(), DDUsuario.SelectedValue.ToString().Trim()); GvReporte.DataSource = dt; GvReporte.DataBind(); if (GvReporte.Rows.Count < 1) { BtnExportar.Visible = false; } else { BtnExportar.Visible = true; } //}catch(Exception ex) //{ //} }