This is a migrated thread and some comments may be shown as answers.

Adding columns Not to ColumnGroup

2 Answers 86 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Tiago
Top achievements
Rank 2
Tiago asked on 26 Oct 2009, 04:48 PM
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

2 Answers, 1 is accepted

Sort by
0
Tiago
Top achievements
Rank 2
answered on 27 Oct 2009, 04:29 PM
Please help!

Thanks
0
Accepted
Martin Vasilev
Telerik team
answered on 29 Oct 2009, 05:47 PM
Hi Tiago Pinho,

Thank you for writing.

The RadGridView's Column Groups View does not support visualization of columns outside of the groups. You should put a column in a single group to show in the grid. In addition, you can take a look at the HTML View. It could better fit to your scenario.

Sincerely yours,
Martin Vasilev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
GridView
Asked by
Tiago
Top achievements
Rank 2
Answers by
Tiago
Top achievements
Rank 2
Martin Vasilev
Telerik team
Share this question
or