private void Ricerca(bool reset) { //Session.Remove("DataSet"); S_Controls.Collections.S_ControlsCollection CollezioneControlli = new S_Controls.Collections.S_ControlsCollection(); cmbsComune.DBDefaultValue = "0"; cmbsEdificio.DBDefaultValue = "0"; cmbsServizio.DBDefaultValue = "0"; CollezioneControlli = GetData(); S_Controls.Collections.S_Object s_p_pageindex = new S_Object(); s_p_pageindex.ParameterName = "pageindex"; s_p_pageindex.DbType = CustomDBType.Integer; s_p_pageindex.Direction = ParameterDirection.Input; s_p_pageindex.Index = 16; s_p_pageindex.Value = DataGridRicerca.CurrentPageIndex + 1; CollezioneControlli.Add(s_p_pageindex); S_Controls.Collections.S_Object s_p_pagesize = new S_Object(); s_p_pagesize.ParameterName = "pagesize"; s_p_pagesize.DbType = CustomDBType.Integer; s_p_pagesize.Direction = ParameterDirection.Input; s_p_pagesize.Index = 17; s_p_pagesize.Value = DataGridRicerca.PageSize; CollezioneControlli.Add(s_p_pagesize); Classi.ManProgrammata.Rapportino _Rapportino = new TheSite.Classi.ManProgrammata.Rapportino(); DataSet _MyDs = _Rapportino.GetData(CollezioneControlli).Copy(); if (reset) { CollezioneControlli.Clear(); CollezioneControlli = GetData(); int _totalRecords = _Rapportino.getCount(CollezioneControlli); this.GridTitle1.NumeroRecords = _totalRecords.ToString(); } this.DataGridRicerca.DataSource = _MyDs.Tables[0]; // this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString(); this.DataGridRicerca.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords); this.DataGridRicerca.DataBind(); }
private void Execute(bool reset) { ///Istanzio un nuovo oggetto Collection per aggiungere i parametri S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection(); ///creo i parametri _SCollection = getParam(); // nuovi parametri paginazione S_Controls.Collections.S_Object s_p_pageindex = new S_Object(); s_p_pageindex.ParameterName = "pageindex"; s_p_pageindex.DbType = CustomDBType.Integer; s_p_pageindex.Direction = ParameterDirection.Input; s_p_pageindex.Index = 16; s_p_pageindex.Value = MyDataGrid1.CurrentPageIndex + 1; _SCollection.Add(s_p_pageindex); S_Controls.Collections.S_Object s_p_pagesize = new S_Object(); s_p_pagesize.ParameterName = "pagesize"; s_p_pagesize.DbType = CustomDBType.Integer; s_p_pagesize.Direction = ParameterDirection.Input; s_p_pagesize.Index = 17; s_p_pagesize.Value = MyDataGrid1.PageSize; _SCollection.Add(s_p_pagesize); ///Istanzio la Classe per eseguire la Strore Procedure Classi.AnagrafeImpianti.Apparecchiature _Apparecchiature = new Classi.AnagrafeImpianti.Apparecchiature(Context.User.Identity.Name); ///Eseguo il Binding sulla Griglia. DataSet Ds = _Apparecchiature.RicercaDescStanze(_SCollection); // GridTitle1.NumeroRecords=(Ds.Tables[0].Rows.Count)==0? "0":Ds.Tables[0].Rows.Count.ToString(); MyDataGrid1.DataSource = Ds; if (reset) { _SCollection.Clear(); _SCollection = getParam(); int _totalRecords = _Apparecchiature.RicercaStanzeDescCount(_SCollection); this.GridTitle1.NumeroRecords = _totalRecords.ToString(); } this.MyDataGrid1.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords); MyDataGrid1.DataBind(); }
/// <summary> /// Esegue la queri di ricerca /// </summary> /// private void Execute(bool reset) { S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection(); //***************************************** // S_Controls.Collections.S_Object s_p_Bl_Id = new S_Controls.Collections.S_Object(); // s_p_Bl_Id.ParameterName = "p_Bl_Id"; // s_p_Bl_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; // s_p_Bl_Id.Direction = ParameterDirection.Input; // s_p_Bl_Id.Size =8; // s_p_Bl_Id.Index = 0; // s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text; // _SCollection.Add(s_p_Bl_Id); // // S_Controls.Collections.S_Object s_p_campus = new S_Controls.Collections.S_Object(); // s_p_campus.ParameterName = "p_campus"; // s_p_campus.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; // s_p_campus.Direction = ParameterDirection.Input; // s_p_campus.Index = 1; // s_p_campus.Size=50; // s_p_campus.Value = RicercaModulo1.TxtRicerca.Text; // _SCollection.Add(s_p_campus); // // S_Controls.Collections.S_Object s_p_piano_id = new S_Controls.Collections.S_Object(); // s_p_piano_id.ParameterName = "p_piano_id"; // s_p_piano_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; // s_p_piano_id.Direction = ParameterDirection.Input; // s_p_piano_id.Size =8; // s_p_piano_id.Index = 2; // s_p_piano_id.Value = (cmbsPiano.SelectedValue==string.Empty)? 0:Int32.Parse(cmbsPiano.SelectedValue); // _SCollection.Add(s_p_piano_id); // // // S_Controls.Collections.S_Object s_p_nomefile = new S_Controls.Collections.S_Object(); // s_p_nomefile.ParameterName = "p_nomefile"; // s_p_nomefile.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; // s_p_nomefile.Direction = ParameterDirection.Input; // s_p_nomefile.Index = 3; // s_p_nomefile.Size = 50; // s_p_nomefile.Value = S_txtnomefile.Text; // _SCollection.Add(s_p_nomefile); // // S_Controls.Collections.S_Object s_p_desc_file = new S_Controls.Collections.S_Object(); // s_p_desc_file.ParameterName = "p_desc_file"; // s_p_desc_file.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; // s_p_desc_file.Direction = ParameterDirection.Input; // s_p_desc_file.Size = 255; // s_p_desc_file.Index = 4; // s_p_desc_file.Value = S_txtdescrizione.Text; // _SCollection.Add(s_p_desc_file); // // S_Controls.Collections.S_Object s_p_categoria = new S_Controls.Collections.S_Object(); // s_p_categoria.ParameterName = "p_categoria"; // s_p_categoria.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; // s_p_categoria.Direction = ParameterDirection.Input; // s_p_categoria.Size =8; // s_p_categoria.Index = 5; // s_p_categoria.Value = (S_CbCategoria.SelectedValue==string.Empty)? 0:Int32.Parse(S_CbCategoria.SelectedValue); // _SCollection.Add(s_p_categoria); // // S_Controls.Collections.S_Object s_p_tipo = new S_Controls.Collections.S_Object(); // s_p_tipo.ParameterName = "p_tipo"; // s_p_tipo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; // s_p_tipo.Direction = ParameterDirection.Input; // s_p_tipo.Size =8; // s_p_tipo.Index = 6; // s_p_tipo.Value = (S_CmbTipologia.SelectedValue==string.Empty)? 0:Int32.Parse(S_CmbTipologia.SelectedValue); // _SCollection.Add(s_p_tipo); //******************************************** _SCollection = creaParam(); // nuovi parametri paginazione S_Controls.Collections.S_Object s_p_pageindex = new S_Object(); s_p_pageindex.ParameterName = "pageindex"; s_p_pageindex.DbType = CustomDBType.Integer; s_p_pageindex.Direction = ParameterDirection.Input; s_p_pageindex.Index = 16; s_p_pageindex.Value = DataGrid1.CurrentPageIndex + 1; _SCollection.Add(s_p_pageindex); S_Controls.Collections.S_Object s_p_pagesize = new S_Object(); s_p_pagesize.ParameterName = "pagesize"; s_p_pagesize.DbType = CustomDBType.Integer; s_p_pagesize.Direction = ParameterDirection.Input; s_p_pagesize.Index = 17; s_p_pagesize.Value = DataGrid1.PageSize; _SCollection.Add(s_p_pagesize); Classi.AnagrafeImpianti.AnagrafeServizi _AnagrafeServizi = new Classi.AnagrafeImpianti.AnagrafeServizi(Context.User.Identity.Name); DataSet _MyDs = _AnagrafeServizi.GetData(_SCollection); ////////// GridTitle1.Visible = true; if (reset == true) { _SCollection.Clear(); _SCollection = creaParam(); int _totalRecords = _AnagrafeServizi.GetDataCount(_SCollection); this.GridTitle1.NumeroRecords = _totalRecords.ToString(); } DataGrid1.DataSource = _MyDs.Tables[0]; this.DataGrid1.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords); this.DataGrid1.DataBind(); if (int.Parse(this.GridTitle1.NumeroRecords) > 0) { setvisible(true); GridTitle1.DescriptionTitle = ""; } else { GridTitle1.DescriptionTitle = "Nessun dato trovato."; setvisible(false); } }
private void Page_Load(object sender, System.EventArgs e) { Classi.SiteModule _SiteModule = (Classi.SiteModule)HttpContext.Current.Items["SiteModule"]; FunId = int.Parse(Request["FunId"]); HelpLink = _SiteModule.HelpLink; // DIACHIARO PRIMA LE VARIABILI INT // get da request le variabili stringa RM001, PTE,CP001 // POI LE RICERCO IN DB E LE TRASFORMO IN INT (ID) // QUINDI VALORIZZO LE VARIABILI USATE QUI: s_bl_id s_piani s_stanza //------------------------------ // bl_str =""; // fl_str =""; // rm_str =""; // // if (Request["var_stanza"]== null || Request["var_stanza"]=="" ||Request["var_stanza"]==string.Empty) // { // s_stanza=0; // TitoloPiano = Request["TitoloPiano"].ToString(); // PageTitle1.Title = "Apparecchiature del Piano " + TitoloPiano; // } // else // {} if (Request["rm"] != null && Request["rm"] != string.Empty && Request["rm"] != "") { S_Controls.Collections.S_Object s_p_rm = new S_Controls.Collections.S_Object(); s_p_rm.ParameterName = "p_rm"; s_p_rm.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_p_rm.Direction = ParameterDirection.Input; s_p_rm.Size = 20; s_p_rm.Index = 1; s_p_rm.Value = Request["rm"].ToString(); _SCollection.Add(s_p_rm); S_Controls.Collections.S_Object s_p_fl = new S_Controls.Collections.S_Object(); s_p_fl.ParameterName = "p_fl"; s_p_fl.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_p_fl.Direction = ParameterDirection.Input; s_p_fl.Size = 20; s_p_fl.Index = 2; s_p_fl.Value = Request["fl"].ToString(); _SCollection.Add(s_p_fl); S_Controls.Collections.S_Object s_p_bl = new S_Controls.Collections.S_Object(); s_p_bl.ParameterName = "p_bl"; s_p_bl.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_p_bl.Direction = ParameterDirection.Input; s_p_bl.Size = 20; s_p_bl.Index = 3; s_p_bl.Value = Request["bl"].ToString();; _SCollection.Add(s_p_bl); DataSet Ds1 = _DataRoom.DatiTestata_STR(_SCollection); DataRow _Dr1 = Ds1.Tables[0].Rows[0]; if (_Dr1["id_rm"] != DBNull.Value) { s_stanza = (int)int.Parse(_Dr1["id_rm"].ToString()); } if (_Dr1["id_piani"] != DBNull.Value) { s_piani = (int)int.Parse(_Dr1["id_piani"].ToString()); } if (_Dr1["id_bl"] != DBNull.Value) { s_bl_id = (int)int.Parse(_Dr1["id_bl"].ToString()); } } if (s_piani == 0) { s_piani = (int)int.Parse(Request["var_piani"]); } if (s_bl_id == 0) { s_bl_id = (int)int.Parse(Request["var_bl_id"]); } if ((Request["var_stanza"] == null || Request["var_stanza"] == "" || Request["var_stanza"] == string.Empty) && (Request["rm"] == null || Request["rm"] == "" || Request["rm"] == string.Empty) ) { s_stanza = 0; //TitoloPiano = //Request["fl"].ToString(); //Request["TitoloPiano"].ToString(); PageTitle1.Title = "Apparecchiature del Piano "; //+ TitoloPiano; } else { if (s_stanza == 0) { s_stanza = (int)int.Parse(Request["var_stanza"]); } //TitoloStanza = Request["TitoloStanza"].ToString(); PageTitle1.Title = "Apparecchiature della Stanza "; //+ TitoloStanza; _SCollection.Clear(); S_Controls.Collections.S_Object s_p_stanza = new S_Controls.Collections.S_Object(); s_p_stanza.ParameterName = "p_stanza"; s_p_stanza.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_p_stanza.Direction = ParameterDirection.Input; s_p_stanza.Size = 20; s_p_stanza.Index = 1; s_p_stanza.Value = s_stanza; _SCollection.Add(s_p_stanza); DataSet Ds = _DataRoom.DatiTestata(_SCollection); if (Ds.Tables[0].Rows.Count == 1) { DataRow _Dr = Ds.Tables[0].Rows[0]; if (_Dr["altezza"] != DBNull.Value) { this.lblAltezza.Text = _Dr["altezza"].ToString(); } if (_Dr["area"] != DBNull.Value) { this.lblArea.Text = _Dr["area"].ToString(); } if (_Dr["categoria"] != DBNull.Value) { this.lblCategoria.Text = _Dr["categoria"].ToString(); } if (_Dr["Descstanza"] != DBNull.Value) { this.lblDescstanza.Text = _Dr["Descstanza"].ToString(); } if (_Dr["Destuso"] != DBNull.Value) { this.lblDestuso.Text = _Dr["Destuso"].ToString(); } if (_Dr["Edificio"] != DBNull.Value) { this.lblEdificio.Text = _Dr["Edificio"].ToString(); } if (_Dr["Nrstanza"] != DBNull.Value) { this.lblNrstanza.Text = _Dr["Nrstanza"].ToString(); } if (_Dr["pareti"] != DBNull.Value) { this.lblPareti.Text = _Dr["pareti"].ToString(); } if (_Dr["pavimento"] != DBNull.Value) { this.lblPavimento.Text = _Dr["pavimento"].ToString(); } if (_Dr["Piano"] != DBNull.Value) { this.lblPiano.Text = _Dr["Piano"].ToString(); } if (_Dr["soffitto"] != DBNull.Value) { this.lblSoffitto.Text = _Dr["soffitto"].ToString(); } } _SCollection.Clear(); } if (!IsPostBack) { Execute(); GridTitle1.Visible = true; if (Context.Handler is TheSite.AnagrafeImpianti.DataRoom) { _fp = (TheSite.AnagrafeImpianti.DataRoom)Context.Handler; this.ViewState.Add("mioContenitore", _fp._Contenitore); } } GridTitle1.hplsNuovo.Visible = false; ///DataRoom.aspx?id_edificio_cad=201&id_piano_cad=1&FromWebCad=true if (Request.QueryString["FromWebCad"] != null || Request.QueryString["FromWebCad"].ToString() != String.Empty) { if (Request.QueryString["WebCadIndietro"] != null) { //BntIndietro.Visible=true; } PageTitle1.VisibleLogut = false; } else { PageTitle1.VisibleLogut = true; } }
private void BindingEdifici(string BlId, bool reset) { if (BlId != "") { BlId = "'" + BlId.Replace(",", "','") + "'"; } // da qui if (chkEdificio.Checked == true) { sql_select += " BL.BL_ID || ' - ' || BL.ADDRESS1 as EDIFICIO"; sql_group += " BL.BL_ID || ' - ' || BL.ADDRESS1"; } if (chkPiano.Checked == true) { if (sql_select != "") { sql_select += ","; } if (sql_group != "") { sql_group += ","; } sql_select += " PIANI.DESCRIZIONE as PIANO "; sql_group += " PIANI.DESCRIZIONE "; } if (chkStanze.Checked == true) { if (sql_select != "") { sql_select += ","; } if (sql_group != "") { sql_group += ","; } sql_select += "RM.RM_ID || '-' || RM.DESCRIZIONE as STANZA "; sql_group += " RM.RM_ID,RM.DESCRIZIONE "; } if (chkCategoria.Checked == true) { if (sql_select != "") { sql_select += ","; } if (sql_group != "") { sql_group += ","; } sql_select += "RM_CAT.CODICE_CATEGORIA || '-' || RM_CAT.DESCRIZIONE as CATEGORIA "; sql_group += " RM_CAT.CODICE_CATEGORIA, RM_CAT.DESCRIZIONE "; } if (chkDestinazione.Checked == true) { if (sql_select != "") { sql_select += ","; } if (sql_group != "") { sql_group += ","; } sql_select += " RM_DEST_USO.DESCRIZIONE as DESTINAZIONE "; sql_group += " RM_DEST_USO.DESCRIZIONE "; } // if (chkReparto.Checked == true) // { // if (sql_select!="") // sql_select += ","; // if (sql_group!="") // sql_group += ","; // // sql_select += " RM_REPARTO.DESCRIZIONE as REPARTO "; // sql_group += " RM_REPARTO.DESCRIZIONE "; // } // a qui if (BlId != "") { if (sql_where != "") { sql_where += " AND"; } sql_where += " UPPER(BL.BL_ID) in (" + BlId.ToUpper() + ") "; } if (cmbsPiano.SelectedValue != String.Empty) { if (sql_where != "") { sql_where += " AND"; } sql_where += " ID_PIANI =" + cmbsPiano.SelectedValue.ToString(); } if (UserStanze1.DescStanza.ToString() != "") { if (sql_where != "") { sql_where += " AND"; } sql_where += " UPPER(RM.RM_ID ||'-'|| RM.DESCRIZIONE) like '%" + UserStanze1.DescStanza.ToUpper() + "%'"; } if (cmbsCategoria.SelectedValue != String.Empty) { if (sql_where != "") { sql_where += " AND"; } sql_where += " RM_CAT.ID_RM_CAT=" + cmbsCategoria.SelectedValue.ToString(); } // if (s_txtReparto.Text != String.Empty) // { // if (sql_where != "") // sql_where += " AND"; // sql_where += " UPPER(RM_REPARTO.DESCRIZIONE) like '%" + s_txtReparto.Text.ToUpper() + "%'" ; // } // if (s_txtDestinazione.Text != String.Empty) { if (sql_where != "") { sql_where += " AND"; } sql_where += " UPPER(RM_DEST_USO.DESCRIZIONE) like '%" + s_txtDestinazione.Text.ToUpper() + "%'"; } if (cmbsConfronto.SelectedValue != String.Empty & s_txtMq.Text != String.Empty) { if (sql_where != "") { sql_where += " AND"; } //s_txtMq.Text.Replace(",","."); sql_where += " RM.AREA " + cmbsConfronto.SelectedValue + " " + s_txtMq.Text.Replace(",", "."); } if (sql_where != "") { sql_where = " WHERE " + sql_where; } ///select finale da passare alla store procedure if (sql_select != "") { sql_select += ", "; } sql = "SELECT " + sql_select + " SUM(RM.AREA) as VALORE_INT FROM BL JOIN FL ON (FL.Id_Bl = BL.Id) " + "JOIN RM USING (id_piani, id_bl) JOIN PIANI ON (id_piani = PIANI.id) " + //"left JOIN RM_REPARTO ON (RM.ID_RM_REPARTO = RM_REPARTO.ID_RM_REPARTO) " + "left JOIN RM_DEST_USO ON (RM.ID_RM_DEST_USO = RM_DEST_USO.ID_RM_DEST_USO) " + " left JOIN RM_CAT ON (RM.ID_RM_CAT = RM_CAT.ID_RM_CAT) " + sql_where; if (sql_group != "") { sql += " GROUP BY " + sql_group; } sqlCount = "SELECT count(distinct RM.RM_ID) FROM BL JOIN FL ON (FL.Id_Bl = BL.Id) " + "JOIN RM USING (id_piani, id_bl) JOIN PIANI ON (id_piani = PIANI.id) " + //"left JOIN RM_REPARTO ON (RM.ID_RM_REPARTO = RM_REPARTO.ID_RM_REPARTO) " + "left JOIN RM_DEST_USO ON (RM.ID_RM_DEST_USO = RM_DEST_USO.ID_RM_DEST_USO) " + " left JOIN RM_CAT ON (RM.ID_RM_CAT = RM_CAT.ID_RM_CAT) " + sql_where; // ///Istanzio un nuovo oggetto Collection per aggiungere i parametri S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection(); // ///creo i parametri ///edifici S_Controls.Collections.S_Object s_sql = new S_Controls.Collections.S_Object(); s_sql.ParameterName = "p_sql"; s_sql.DbType = CustomDBType.VarChar; s_sql.Direction = ParameterDirection.Input; s_sql.Size = 4000; s_sql.Index = 0; s_sql.Value = sql; _SCollection.Add(s_sql); // nuovi parametri paginazione S_Controls.Collections.S_Object s_p_pageindex = new S_Object(); s_p_pageindex.ParameterName = "pageindex"; s_p_pageindex.DbType = CustomDBType.Integer; s_p_pageindex.Direction = ParameterDirection.Input; s_p_pageindex.Index = 16; s_p_pageindex.Value = DtgRicercaSpazi.CurrentPageIndex + 1; _SCollection.Add(s_p_pageindex); S_Controls.Collections.S_Object s_p_pagesize = new S_Object(); s_p_pagesize.ParameterName = "pagesize"; s_p_pagesize.DbType = CustomDBType.Integer; s_p_pagesize.Direction = ParameterDirection.Input; s_p_pagesize.Index = 17; s_p_pagesize.Value = DtgRicercaSpazi.PageSize; _SCollection.Add(s_p_pagesize); Classi.AnagrafeImpianti.ServiziEdifici _ServiziEdifici = new Classi.AnagrafeImpianti.ServiziEdifici(Context.User.Identity.Name); DataSet Ds = _ServiziEdifici.GetRicerca(_SCollection); if (reset) { _SCollection.Clear(); ///edifici S_Controls.Collections.S_Object s_sqlCount = new S_Controls.Collections.S_Object(); s_sqlCount.ParameterName = "p_sql"; s_sqlCount.DbType = CustomDBType.VarChar; s_sqlCount.Direction = ParameterDirection.Input; s_sqlCount.Size = 4000; s_sqlCount.Index = 0; s_sqlCount.Value = sql; _SCollection.Add(s_sqlCount); int _totalRecords = _ServiziEdifici.GetRicercaCount(_SCollection); this.GridTitle1.NumeroRecords = _totalRecords.ToString(); } this.DtgRicercaSpazi.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords); if (Ds.Tables[0].Rows.Count == 0) { Panel1.Visible = false; } // { // int Pagina = 0; // if ((Ds.Tables[0].Rows.Count % DtgRicercaSpazi.PageSize) >0) // { // Pagina ++; // } // if (DtgRicercaSpazi.PageCount != Convert.ToInt16((Ds.Tables[0].Rows.Count / DtgRicercaSpazi.PageSize) + Pagina)) // { // DtgRicercaSpazi.CurrentPageIndex=0; // } // } // else // { // Panel1.Visible=false; // } Panel1.Visible = true; DtgRicercaSpazi.Visible = true; int conta = 0; if (chkEdificio.Checked == false) { DtgRicercaSpazi.Columns.RemoveAt(0); conta += 1; } if (chkPiano.Checked == false) { DtgRicercaSpazi.Columns.RemoveAt(1 - conta); conta += 1; } if (chkStanze.Checked == false) { DtgRicercaSpazi.Columns.RemoveAt(2 - conta); conta += 1; } if (chkCategoria.Checked == false) { DtgRicercaSpazi.Columns.RemoveAt(3 - conta); conta += 1; } if (chkDestinazione.Checked == false) { DtgRicercaSpazi.Columns.RemoveAt(4 - conta); conta += 1; } // if (chkReparto.Checked == false) // { // // DtgRicercaSpazi.Columns.RemoveAt(5 - conta); // conta +=1; // } if (chkEdificio.Checked == false && chkPiano.Checked == false && chkStanze.Checked == false && chkCategoria.Checked == false && chkDestinazione.Checked == false //&& chkReparto.Checked == false ) { DtgRicercaSpazi.Columns.RemoveAt(5 - conta); //creo colonna vuota BoundColumn cl8 = new BoundColumn(); cl8.DataField = ""; cl8.HeaderText = ""; DtgRicercaSpazi.Columns.Add(cl8); } CalcolaTotali(Ds.Tables[0]); this.DtgRicercaSpazi.DataSource = Ds.Tables[0]; DtgRicercaSpazi.DataBind(); GridTitle1.DescriptionTitle = ""; // GridTitle1.NumeroRecords = Ds.Tables[0].Rows.Count.ToString(); }