datagridview column display index not working properly

Question

4.33/5 (2 votes)

See more:

Hello

i have a little issue with datagridview, I need to reorder columns in datagridview

I have 10 columns loaded into datagridview, 5 of them are invisible, which I made invisible in simple code

and the rest 5 I want to place in order with displayindex property

and here is the thing now

I put in code

dg.AutoGenerateColumns = false;

dg.Columns["Column1].Visible = false;
dg.Columns["Column2].Visible = false;
dg.Columns["Column3].Visible = false;
dg.Columns["Column4].Visible = false;
dg.Columns["Column5].Visible = false;

dg.Column["Column6].DisplayIndex = 1;
dg.Column["Column7].DisplayIndex = 2;
dg.Column["Column8].DisplayIndex = 3;
dg.Column["Column9].DisplayIndex = 4;
dg.Column["Column10].DisplayIndex = 5;

but Column9 gets on place 3 not 4, while Column8 gets on place 8, THEY CHANGE PLACES!!!
I even set it up to save DisplayIndex-es into Properties.Settings of my solution and then I read the displayindexes into textboxes for each column to see, and THERE IT SAYS Column9 is on place 4 but IT IS NOT, it's on 3!!!!

I am puzzled
help, anyone

Posted 11-Jun-13 22:19pm

shonezi

Updated 17-May-21 4:47am

Add a Solution

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Surendra Adhikari SA · Answer 1 · 2013-06-12T02:10:00

Problem arises due to invisible columns .
set DisplayIndex of invisibe column also .(that is give DisplayIndex to both columns (visible and non visible in order).
as follows

C#

dg.Columns["Column1"].Visible = false;
dg.Columns["Column2"].Visible = false;
dg.Columns["Column3"].Visible = false;
dg.Columns["Column4"].Visible = false;
dg.Columns["Column5"].Visible = false;

dg.Column["Column6"].DisplayIndex = 1;
dg.Column["Column7"].DisplayIndex = 2;
dg.Column["Column8"].DisplayIndex = 3;
dg.Column["Column9"].DisplayIndex = 4;
dg.Column["Column10"].DisplayIndex = 5;

dg.Column["Column1"].DisplayIndex = 6;
dg.Column["Column2"].DisplayIndex = 7;
dg.Column["Column3"].DisplayIndex = 8;
dg.Column["Column4"].DisplayIndex = 9;
dg.Column["Column5"].DisplayIndex = 10;

**Nirav Prabtani** · Answer 2 · 2013-06-13T21:06:00

Solution 2

give proper indexing into grid

by set property (index="number")

Posted 13-Jun-13 21:06pm

Nirav Prabtani

kheiltash · Answer 3 · 2014-02-19T20:51:00

//write same code on EventHandler Shown:

MyForm.Shown += new System.EventHandler(this.DlgEmpfListView_Shown);

private void MyForm_Shown(object sender, EventArgs e)
{

C#

dg.Columns["Column1"].Visible = false;
dg.Columns["Column2"].Visible = false;
dg.Columns["Column3"].Visible = false;
dg.Columns["Column4"].Visible = false;
dg.Columns["Column5"].Visible = false;

dg.Column["Column6"].DisplayIndex = 1;
dg.Column["Column7"].DisplayIndex = 2;
dg.Column["Column8"].DisplayIndex = 3;
dg.Column["Column9"].DisplayIndex = 4;
dg.Column["Column10"].DisplayIndex = 5;

dg.Column["Column1"].DisplayIndex = 6;
dg.Column["Column2"].DisplayIndex = 7;
dg.Column["Column3"].DisplayIndex = 8;
dg.Column["Column4"].DisplayIndex = 9;
dg.Column["Column5"].DisplayIndex = 10;

}

Member 14982063 · Answer 4 · 2020-11-02T11:28:00

Responding to an old post/question, i tried turning off the

C#

AutoGenerateColumns

property of the datagridview before assigning the displayindex.

C#

dgv1.AutoGenerateColumns = false;
dgv1.Columns["column1HeaderText"].DisplayIndex = 0;
dgv1.Columns["column2HeaderText"].DisplayIndex = 1;
dgv1.Columns["column3HeaderText"].DisplayIndex = 2;

One suggestion is that if there are some columns/any column that has to be hidden then hide it after setting the display index.

C#

dgv1.Columns["column1HeaderText"].Visible = false;

Hope this helps someone!

Mahadevappa Kanike · Answer 5 · 2015-05-05T01:41:00

I too had this problem and finally resolved this problem in my application.
Apply the Display Index values in ascending order to all the columns exist in grid regardless of invisible or visible columns. You can also shuffle the invisible columns and visible Display Indexes instead of segregating all visible columns should apply with display indexes first and invisible columns afterwards; However Data Grid will display only visible columns in which order that they have the display indexes specified.

Try this :

XML

dg.Columns[&quot;Column1].Visible = false;
dg.Columns[&quot;Column2].Visible = false;
dg.Columns[&quot;Column3].Visible = false;
dg.Columns[&quot;Column4].Visible = false;
dg.Columns[&quot;Column5].Visible = false;

<pre lang="cs">// Apply the DisplayIndex in ascending order 1,2,3... etc
dg.Column[&amp;quot;Column6].DisplayIndex = 1;
dg.Column[&amp;quot;Column7].DisplayIndex = 2;
dg.Column[&amp;quot;Column8].DisplayIndex = 3;
dg.Column[&amp;quot;Column9].DisplayIndex = 4;
dg.Column[&amp;quot;Column10].DisplayIndex = 5;
// These columns are exist in the grid but not displayed, 
// hence you should set the display index for invisible columns as well.
dg.Column[&amp;quot;Column1].DisplayIndex = 6;
dg.Column[&amp;quot;Column2].DisplayIndex = 7;
dg.Column[&amp;quot;Column3].DisplayIndex = 8;
dg.Column[&amp;quot;Column4].DisplayIndex = 9;
dg.Column[&amp;quot;Column5].DisplayIndex = 10;</pre>

HTH
Mahadev

Member 13607973 · Answer 6 · 2018-01-04T20:39:00

Solution 5

Hi,

I was also facing the same issue, got a very simple solution for this. You can use the column name instead of using the index id while accessing it.

For example, use can do like this:

dg["ListType", i].Value = "abc" ( here i is the "row number" and ListType is the column name.

Posted 4-Jan-18 20:39pm

Member 13607973

Comments

Richard MacCutchan 5-Jan-18 4:53am

Well done, only FOUR years too late.

datagridview column display index not working properly

6 solutions

Solution 1

Solution 2

Solution 3

Solution 6

Solution 4

Solution 5

Add your solution here

Preview 0