dataGriview操作

DataGridView新特色、常用操作 列操作 c# dataGridView1.Columns.Insert 1、自定义列 srxljl Customize Cells and Columns in the Windows Forms DataGridView Control by Extending Their Behavior and Appearance Host Controls in Windows Forms DataGridView Cells 继承 DataGridViewTextBoxCell 类生成新的Cell类，然后再继承 DataGridViewColumn 生成新的Column类，并指定 CellTemplate为新的Cell类。新生成的Column便可以增加到DataGridView中去。 2、自动适应列宽 srxljl Programmatically Resize Cells to Fit Content in the Windows Forms DataGridView Control Samples： DataGridView.AutoSizeColumns( DataGridViewAutoSizeColumnCriteria.HeaderAndDisplayedRows); DataGridView.AutoSizeColumn( DataGridViewAutoSizeColumnCriteria.HeaderOnly, 2, false); DataGridView.AutoSizeRow( DataGridViewAutoSizeRowCriteria.Columns, 2, false); DataGridView.AutoSizeRows( DataGridViewAutoSizeRowCriteria.HeaderAndColumns, 0, dataGridView1.Rows.Count, false); 3、可以绑定并显示对象 srxljl Bind Objects to Windows Forms DataGridView Controls 4、可以改变表格线条风格 srxljl Change the Border and Gridline Styles in the Windows Forms DataGridView Control Samples: this.dataGridView1.GridColor = Color.BlueViolet; this.dataGridView1.BorderStyle = BorderStyle.Fixed3D; this.dataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.None; this.dataGridView1.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; this.dataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; 5、动态改变列是否显示，和动态改变列的显示顺序 srxljl Change the Order of the Columns in the Windows Forms DataGridView Control Samples： customersDataGridView.Columns["CustomerID"].Visible = false; customersDataGridView.Columns["ContactName"].DisplayIndex = 0; customersDataGridView.Columns["ContactTitle"].DisplayIndex = 1; customersDataGridView.Columns["City"].DisplayIndex = 2; customersDataGridView.Columns["Country"].DisplayIndex = 3; customersDataGridView.Columns["CompanyName"].DisplayIndex = 4; 6、可以在列中显示图像 srxljl Display Images in Cells of the Windows Forms DataGridView Control Samples： Icon treeIcon = new Icon(this.GetType(), "tree.ico"); DataGridViewImageColumn iconColumn = new DataGridViewImageColumn(); iconColumn.Image = treeIcon.ToBitmap(); iconColumn.Name = "Tree"; iconColumn.HeaderText = "Nice tree"; dataGridView1.Columns.Insert(2, iconColumn); 7、格式化显示内容: srxljl Format Data in the Windows Forms DataGridView Control Samples: this.dataGridView1.Columns["UnitPrice"].DefaultCellStyle.Format = "c"; this.dataGridView1.Columns["ShipDate"].DefaultCellStyle.Format = "d"; this.dataGridView1.DefaultCellStyle.NullValue = "no entry"; this.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewWrapMode.Wrap; this.dataGridView1.Columns["CustomerName"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; 续....... DataGridView.AutoSizeColumns( DataGridViewAutoSizeColumnCriteria.HeaderAndDisplayedRows); DataGridView.AutoSizeColumn( DataGridViewAutoSizeColumnCriteria.HeaderOnly, 2, false); DataGridView.AutoSizeRow( DataGridViewAutoSizeRowCriteria.Columns, 2, false); DataGridView.AutoSizeRows( DataGridViewAutoSizeRowCriteria.HeaderAndColumns, 0, dataGridView1.Rows.Count, false); 3、可以绑定并显示对象 srxljl Bind Objects to Windows Forms DataGridView Controls 4、可以改变表格线条风格 srxljl Change the Border and Gridline Styles in the Windows Forms DataGridView Control Samples: this.dataGridView1.GridColor = Color.BlueViolet; this.dataGridView1.BorderStyle = BorderStyle.Fixed3D; this.dataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.None; this.dataGridView1.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; this.dataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; 5、动态改变列是否显示，和动态改变列的显示顺序 srxljl Change the Order of the Columns in the Windows Forms DataGridView Control Samples： customersDataGridView.Columns["CustomerID"].Visible = false; customersDataGridView.Columns["ContactName"].DisplayIndex = 0; customersDataGridView.Columns["ContactTitle"].DisplayIndex = 1; customersDataGridView.Columns["City"].DisplayIndex = 2; customersDataGridView.Columns["Country"].DisplayIndex = 3; customersDataGridView.Columns["CompanyName"].DisplayIndex = 4; 6、可以在列中显示图像 srxljl Display Images in Cells of the Windows Forms DataGridView Control Samples： Icon treeIcon = new Icon(this.GetType(), "tree.ico"); DataGridViewImageColumn iconColumn = new DataGridViewImageColumn(); iconColumn.Image = treeIcon.ToBitmap(); iconColumn.Name = "Tree"; iconColumn.HeaderText = "Nice tree"; dataGridView1.Columns.Insert(2, iconColumn); 7、格式化显示内容: srxljl Format Data in the Windows Forms DataGridView Control Samples: this.dataGridView1.Columns["UnitPrice"].DefaultCellStyle.Format = "c"; this.dataGridView1.Columns["ShipDate"].DefaultCellStyle.Format = "d"; this.dataGridView1.DefaultCellStyle.NullValue = "no entry"; this.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewWrapMode.Wrap; this.dataGridView1.Columns["CustomerName"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; 8、更改列名应该使用 dataGridView1.Columns[0].HeaderText = "序号";