Dear friends,
Please take a look at my code.
I have plenty of columns grouped by months, and i also have two more columns that i don't want to group (iduser_exe and nome_agente).
However, those two columns are not shown in my Grid ... Why? ALso, the column iduser_exe must not be visible.
Can you help me?
Thanks in advance!!
SqlConnection sxv = AppClasses.Connections.retConn();
sxv.Open();
SqlCommand cmdv = new SqlCommand("v_oport_conc_ano", sxv);
cmdv.CommandType = CommandType.StoredProcedure;
cmdv.Parameters.Add(new SqlParameter("@iduser", Convert.ToInt32(AppClasses.ClassAgentes.getIdByUsername(HttpRuntime.Cache["NomeUtilizador"].ToString()))));
cmdv.Parameters.Add(new SqlParameter("@ano", Convert.ToInt32(radSpinEditor1.Value)));
SqlDataReader reader = cmdv.ExecuteReader();
radGridView1.MasterGridViewTemplate.LoadFrom(reader);
sxv.Close();
radGridView1.Columns["iduser_exe"].IsVisible = false;//ATTENTION: I WANT THIS COLUMN OUT OF GROUPING, A NORMAL COLUMN INSTEAD
radGridView1.Columns["nome_agente"].HeaderText = "Agente";//ATTENTION: I WANT THIS COLUMN OUT OF GROUPING, A NORMAL COLUMN INSTEAD
radGridView1.Columns["nome_agente"].Width = 155;
radGridView1.Columns["ano"].IsVisible = false;
radGridView1.Columns["C01"].HeaderText = "Cn.";
radGridView1.Columns["C01"].Width = 28;
radGridView1.Columns["N01"].HeaderText = "Nc.";
radGridView1.Columns["N01"].Width = 28;
radGridView1.Columns["C02"].HeaderText = "Cn.";
radGridView1.Columns["C02"].Width = 28;
radGridView1.Columns["N02"].HeaderText = "Nc.";
radGridView1.Columns["N02"].Width = 28;
radGridView1.Columns["C03"].HeaderText = "Cn.";
radGridView1.Columns["C03"].Width = 28;
radGridView1.Columns["N03"].HeaderText = "Nc.";
radGridView1.Columns["N03"].Width = 28;
radGridView1.Columns["C04"].HeaderText = "Cn.";
radGridView1.Columns["C04"].Width = 28;
radGridView1.Columns["N04"].HeaderText = "Nc.";
radGridView1.Columns["N04"].Width = 28;
radGridView1.Columns["C05"].HeaderText = "Cn.";
radGridView1.Columns["C05"].Width = 28;
radGridView1.Columns["N05"].HeaderText = "Nc.";
radGridView1.Columns["N05"].Width = 28;
radGridView1.Columns["C06"].HeaderText = "Cn.";
radGridView1.Columns["C06"].Width = 28;
radGridView1.Columns["N06"].HeaderText = "Nc.";
radGridView1.Columns["N06"].Width = 28;
radGridView1.Columns["C07"].HeaderText = "Cn.";
radGridView1.Columns["C07"].Width = 28;
radGridView1.Columns["N07"].HeaderText = "Nc.";
radGridView1.Columns["N07"].Width = 28;
radGridView1.Columns["C08"].HeaderText = "Cn.";
radGridView1.Columns["C08"].Width = 28;
radGridView1.Columns["N08"].HeaderText = "Nc.";
radGridView1.Columns["N08"].Width = 28;
radGridView1.Columns["C09"].HeaderText = "Cn.";
radGridView1.Columns["C09"].Width = 28;
radGridView1.Columns["N09"].HeaderText = "Nc.";
radGridView1.Columns["N09"].Width = 28;
radGridView1.Columns["C10"].HeaderText = "Cn.";
radGridView1.Columns["C10"].Width = 28;
radGridView1.Columns["N10"].HeaderText = "Nc.";
radGridView1.Columns["N10"].Width = 28;
radGridView1.Columns["C11"].HeaderText = "Cn.";
radGridView1.Columns["C11"].Width = 28;
radGridView1.Columns["N11"].HeaderText = "Nc.";
radGridView1.Columns["N11"].Width = 28;
radGridView1.Columns["C12"].HeaderText = "Cn.";
radGridView1.Columns["C12"].Width = 28;
radGridView1.Columns["N12"].HeaderText = "Nc.";
radGridView1.Columns["N12"].Width = 28;
#region gridGrouping
ColumnGroupsViewDefinition view = new ColumnGroupsViewDefinition();
view.ColumnGroups.Add(new GridViewColumnGroup("Agente")); //ATTENTION: I WANT THIS COLUMN OUT OF GROUPING, A NORMAL COLUMN INSTEAD
view.ColumnGroups.Add(new GridViewColumnGroup("Jan."));
view.ColumnGroups.Add(new GridViewColumnGroup("Fev."));
view.ColumnGroups.Add(new GridViewColumnGroup("Mar."));
view.ColumnGroups.Add(new GridViewColumnGroup("Abr."));
view.ColumnGroups.Add(new GridViewColumnGroup("Mai."));
view.ColumnGroups.Add(new GridViewColumnGroup("Jun."));
view.ColumnGroups.Add(new GridViewColumnGroup("Jul."));
view.ColumnGroups.Add(new GridViewColumnGroup("Ago."));
view.ColumnGroups.Add(new GridViewColumnGroup("Set."));
view.ColumnGroups.Add(new GridViewColumnGroup("Out."));
view.ColumnGroups.Add(new GridViewColumnGroup("Nov."));
view.ColumnGroups.Add(new GridViewColumnGroup("Dez."));
view.ColumnGroups[0].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[0].Rows[0].Columns.Add(this.radGridView1.Columns["nome_agente"]);
view.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[1].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[1].Rows[0].Columns.Add(this.radGridView1.Columns["C01"]);
view.ColumnGroups[1].Rows[0].Columns.Add(this.radGridView1.Columns["N01"]);
view.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[2].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[2].Rows[0].Columns.Add(this.radGridView1.Columns["C02"]);
view.ColumnGroups[2].Rows[0].Columns.Add(this.radGridView1.Columns["N02"]);
view.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[3].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[3].Rows[0].Columns.Add(this.radGridView1.Columns["C03"]);
view.ColumnGroups[3].Rows[0].Columns.Add(this.radGridView1.Columns["N03"]);
view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[4].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[4].Rows[0].Columns.Add(this.radGridView1.Columns["C04"]);
view.ColumnGroups[4].Rows[0].Columns.Add(this.radGridView1.Columns["N04"]);
view.ColumnGroups[5].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[5].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[5].Rows[0].Columns.Add(this.radGridView1.Columns["C05"]);
view.ColumnGroups[5].Rows[0].Columns.Add(this.radGridView1.Columns["N05"]);
view.ColumnGroups[6].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[6].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[6].Rows[0].Columns.Add(this.radGridView1.Columns["C06"]);
view.ColumnGroups[6].Rows[0].Columns.Add(this.radGridView1.Columns["N06"]);
view.ColumnGroups[7].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[7].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[7].Rows[0].Columns.Add(this.radGridView1.Columns["C07"]);
view.ColumnGroups[7].Rows[0].Columns.Add(this.radGridView1.Columns["N07"]);
view.ColumnGroups[8].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[8].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[8].Rows[0].Columns.Add(this.radGridView1.Columns["C08"]);
view.ColumnGroups[8].Rows[0].Columns.Add(this.radGridView1.Columns["N08"]);
view.ColumnGroups[9].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[9].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[9].Rows[0].Columns.Add(this.radGridView1.Columns["C09"]);
view.ColumnGroups[9].Rows[0].Columns.Add(this.radGridView1.Columns["N09"]);
view.ColumnGroups[10].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[10].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[10].Rows[0].Columns.Add(this.radGridView1.Columns["C10"]);
view.ColumnGroups[10].Rows[0].Columns.Add(this.radGridView1.Columns["N10"]);
view.ColumnGroups[11].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[11].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[11].Rows[0].Columns.Add(this.radGridView1.Columns["C11"]);
view.ColumnGroups[11].Rows[0].Columns.Add(this.radGridView1.Columns["N11"]);
view.ColumnGroups[12].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[12].Rows.Add(new GridViewColumnGroupRow());
view.ColumnGroups[12].Rows[0].Columns.Add(this.radGridView1.Columns["C12"]);
view.ColumnGroups[12].Rows[0].Columns.Add(this.radGridView1.Columns["N12"]);
this.radGridView1.ViewDefinition = view;
#endregion