//获取数据
DataTable dt = getTable(sql);
dataGridView1.DataSource = dt;
//解决绑定数据后列顺序打乱问题
dataGridView1.Columns["1"].DisplayIndex = 0;
dataGridView1.Columns["2"].DisplayIndex = 1;
dataGridView1.Columns["3"].DisplayIndex = 2;
dataGridView1.Columns["4"].DisplayIndex = 3;
dataGridView1.Columns["5"].DisplayIndex = 4;
dataGridView1.Columns["6"].DisplayIndex = 5;
dataGridView1.Columns["7"].DisplayIndex = 6;
//dataGridView1.Columns["8"].DisplayIndex = 6;
dataGridView1.Columns["9"].DisplayIndex = 7;
dataGridView1.Columns["10"].DisplayIndex = 8;
dataGridView1.Columns["11"].DisplayIndex = 9;
DataTable dt = getTable(sql);
dataGridView1.DataSource = dt;
//解决绑定数据后列顺序打乱问题
dataGridView1.Columns["1"].DisplayIndex = 0;
dataGridView1.Columns["2"].DisplayIndex = 1;
dataGridView1.Columns["3"].DisplayIndex = 2;
dataGridView1.Columns["4"].DisplayIndex = 3;
dataGridView1.Columns["5"].DisplayIndex = 4;
dataGridView1.Columns["6"].DisplayIndex = 5;
dataGridView1.Columns["7"].DisplayIndex = 6;
//dataGridView1.Columns["8"].DisplayIndex = 6;
dataGridView1.Columns["9"].DisplayIndex = 7;
dataGridView1.Columns["10"].DisplayIndex = 8;
dataGridView1.Columns["11"].DisplayIndex = 9;
dataGridView1.Columns["12"].DisplayIndex = 10;
1~12均为列名
本文介绍了一种使用C#代码在DataGridView中调整列显示顺序的方法。通过设置各列的DisplayIndex属性,可以确保加载数据后列的顺序符合预期。此方法适用于解决数据绑定后列顺序错乱的问题。
2476

被折叠的 条评论
为什么被折叠?



