public void Esport() { Hashtable _HS = (Hashtable)Session["ParametriSelectSchema"]; string VISTA = Convert.ToString(_HS["NomeVista"]); int IdVista = Convert.ToInt32(_HS["IdVista"]); VISTA = " " + VISTA + " "; TheSite.GIC.App_Code.Consultazioni.interogazioni DQ = new TheSite.GIC.App_Code.Consultazioni.interogazioni(); DQ.VISTA = VISTA; DQ.IdVista = IdVista; DataSet Dt = DQ.GetData(IdQ); Csy.WebControls.Export _objExport = new Csy.WebControls.Export(); DataTable _dt = new DataTable(); _dt = Dt.Tables[0].Copy(); if (_dt.Rows.Count != 0) { _objExport.ExportDetails(_dt, Csy.WebControls.Export.ExportFormat.Excel, "exp.xls"); } else { String scriptString = "<script language=JavaScript>alert('Nessun elemento da esportare');"; scriptString += "/"; scriptString += "script>"; if (!this.IsClientScriptBlockRegistered("clientScriptexp")) { this.RegisterStartupScript("clientScriptexp", scriptString); } } }
public void DysplayGrid() { Hashtable _HS = (Hashtable)Session["ParametriSelectSchema"]; string VISTA = Convert.ToString(_HS["NomeVista"]); int IdVista = Convert.ToInt32(_HS["IdVista"]); VISTA = " " + VISTA + " "; TheSite.GIC.App_Code.Consultazioni.interogazioni DQ = new TheSite.GIC.App_Code.Consultazioni.interogazioni(); DQ.VISTA = VISTA; DQ.IdVista = IdVista; DataGridQuery.DataSource = DQ.GetData(IdQ); DataGridQuery.DataBind(); }