winfrom 中 datagridview 控件绑定值时 让没有绑定的实体字段不显示！！

Question

winfrom 中 datagridview 控件绑定值时 让没有绑定的实体字段不显示！！

Answer 1

你可以把不需要显示的字段同样绑定 然后Visable = false

Answer 2

void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
        {
            foreach (DataGridViewColumn dgvc in dataGridView1.Columns)
            {
                switch (dgvc.Name)
                { 
                    case "ID" :
                        {
                            dgvc.HeaderText = "编号";
                            dgvc.Visible = true;
                            break;
                        }
                    case "CollectionTime" :
                        {
                            dgvc.HeaderText = "收集时间";
                            dgvc.Visible = true;
                            break;
                        }
                    case "TempId":
                        {
                            dgvc.HeaderText = "编号";
                            dgvc.Visible = false;
                            break;
                        }
                    case "ChineseName":
                        {
                            dgvc.HeaderText = "中文名称";
                            dgvc.Visible = true;
                            break;
                        }                    case "CondictionDescribe":
                        {
                            dgvc.HeaderText = "条件描述";
                            dgvc.Visible = true;
                            break;
                        }
                    case "CollectionLocation":
                        {
                            dgvc.HeaderText = "位置";
                            dgvc.Visible = true;
                            break;
                        }
                    case "Column1":
                        {
                            dgvc.Visible = true;
                            break;
                        }
                    default:  dgvc.Visible = false;
                        break;                }             
            }
        }

Answer 3

datagridview编辑列 自动生成字段 前面的勾点掉或者 查询的sql语句不用slect * 而是查询你要显示的字段select id,name

Answer 4

自动生成列 不要把钩 去掉了 因为我相信正常情况下不会SELECT *  只要挑出你要的字段就行
当然 可能有些你是要计算 或者什么的  不想让人看到 那你就设置某一个列隐藏就可以了
而且你自己去用代码动态生成列 是个很苦恼的事情，，我以前做过一次
列少还可以忍受 多了你就头疼了DGV.Columns["列名"].Visible = false;