protected void CarterasPoligonales_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Ver") { string nombreCarteraP = CarterasPoligonales.Rows[int.Parse(e.CommandArgument.ToString())].Cells[0].Text; string emailP = lblEmail.Text; CarteraDAO cartera = new CarteraDAO(); lblNombreCartera.Text = nombreCarteraP; List <CarteraDAO> lista = cartera.verPoligonal(emailP, nombreCarteraP); CarteraPoligonal.DataSource = lista; CarteraPoligonal.DataBind(); List <CarteraDAO> listaC = cartera.verCaracPoligonal(emailP, nombreCarteraP); CaracPoligonal.DataSource = listaC; CaracPoligonal.DataBind(); } else { if (e.CommandName == "Eliminar") { CarteraDAO carteraE = new CarteraDAO(); string nombreCarteraE = CarterasPoligonales.Rows[int.Parse(e.CommandArgument.ToString())].Cells[0].Text; string emailE = lblEmail.Text; carteraE.EliminarCartera(emailE, nombreCarteraE); } else { } } }
private void ExportGridToExcel() { /*Response.Clear(); * Response.Buffer = true; * Response.ClearContent(); * Response.ClearHeaders(); * Response.Charset = ""; * string FileName = lblNombreCartera.Text + ".xls"; * StringWriter strwritter = new StringWriter(); * HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter); * Response.Cache.SetCacheability(HttpCacheability.NoCache); * Response.ContentType = "application/vnd.ms-excel"; * Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName); * CarteraPoligonal.GridLines = GridLines.Both; * CarteraPoligonal.HeaderStyle.Font.Bold = true; * CarteraPoligonal.RenderControl(htmltextwrtter); * CaracPoligonal.GridLines = GridLines.Both; * CaracPoligonal.HeaderStyle.Font.Bold = true; * CaracPoligonal.RenderControl(htmltextwrtter); * Response.Write(strwritter.ToString()); * Response.End(); */ Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename = '" + lblNombreCartera.Text + "'.xls"); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); CarteraPoligonal.RenderControl(htmlWrite); CaracPoligonal.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); }