this.currentposition = this.dataGridView1.BindingContext
[this.dataGridView1.DataSource, this.dataGridView1.DataMember].Position;
bookContent = this.database.dataSet.Tables[0].Rows
[this.currentposition ][21].ToString().Trim();
MessageBox.Show(bookContent);
1. Custom columns
//Define column width
this.dataGridView1.Columns[0].Width = 80;
this.dataGridView1.Columns[1].Width = 80;
this.dataGridView1.Columns[2].Width = 180;
this.dataGridView1.Columns[3].Width = 120;
this.dataGridView1.Columns[4].Width = 120;
Customize Cells and Columns in the Windows Forms
DataGridView Control by Extending TheirBehavior and
AppearanceHost Controls in Windows Forms DataGridView Cells
Inherit the DataGridViewTextBoxCell class to generate a new Cell class, then inherit DataGridViewColumn to generate a new Column class, and specify
CellTemplate as the new Cell class. The newly generated Column can be added to the DataGridView.
2. Automatically adapt to column width
PRogrammatically Resize Cells to Fit Content in
the Windows Forms DataGridView ControlSamples:
DataGridView.AutoSizeColumns(DataGridViewAutoSizeColumnCriteria.HeaderAndDisplayedRows);
Data GridView.AutoSizeColumn(DataGridViewAutoSizeColumnCriteria.HeaderOnly,2, false);
DataGridView.AutoSizeRow(DataGridViewAutoSizeRowCriteria.Columns,2, false);
DataGridView.AutoSizeRows
(DataGridViewAutoSizeRowCriteria.HeaderAndColumns,0, dataGridView1.Rows.Count, false);
3. Can be bound and Display objects
Bind Objects to Windows Forms DataGridView Controls
4. You can change the table line style
Change the Border and Gridline Styles in
the Windows Forms DataGridView ControlSamples:
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. Dynamically change whether columns are displayed, and dynamically change the display order of columns
Change the Order of the Columns in the Windows Forms DataGridView ControlSamples:
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. Images can be displayed in columns
Display Images in Cells of the Windows Forms DataGridView ControlSamples:
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. Formatted display content:
Format Data in the Windows Forms DataGridView ControlSamples:
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 , scrolling in drag column
Freeze Columns in the Windows Forms DataGridView ControlSamples:
Fix the specified column and previous columns this.dataGridView1.Columns["AddToCartButton"].
Frozen = true;
9. Get the Selected Cells, Rows,
and Columns in the Windows Forms DataGridView ControlSamples:
10. Display the error message that occurs during input
Handle Errors that Occur During Data Entry in the Windows
Forms DataGridView ControlSamples:
private void dataGridView1_DataError
(object sender,DataGridViewDataErrorEventArgs e){
// If the data source raises an exception when a cell value is
// commited, display an error message.
if
(e.Exception != null &&e.Context == DataGridViewDataErrorContext.Commit){
MessageBox.Show("CustomerID value must be unique.");
}
}
11、大数据量显示采用Virtual Mode
Implement Virtual Mode in the Windows Forms DataGridView Control
12、设置指定的列只读
Make Columns in the Windows Forms DataGridView Control Read-OnlySamples:
dataGridView1.Columns["CompanyName"].ReadOnly = true;
13、移去自动生成的列
Remove Autogenerated Columns from a Windows Forms DataGridView ControlSample:
dataGridView1.AutoGenerateColumns
= true;dataGridView1.DataSource
= customerDataSet;dataGridView1.Columns.Remove ("Fax");
或:dataGridView1.Columns["CustomerID"].Visible = false;
14、自定义
选择模式
Set the Selection Mode of the Windows Forms DataGridView ControlSample:
this.dataGridView1.SelectionMode
= DataGridViewSelectionMode.FullRowSelect;
this.dataGridView1.MultiSelect = false;
15、自定义设定光标进入单元格是否编辑模式(编辑模式)
Specify the Edit Mode for the Windows Forms DataGridView
Controlthis.dataGridView1.EditMode
= DataGridViewEditMode.EditOnEnter;
16、新行指定默认值
Specify Default Values for New Rows in the Windows
Forms DataGridView ControlSample:
private void dataGridView1_DefaultValuesNeeded(object sender,
System.Windows.Forms.DataGridViewRowEventArgs e){
e.Row.Cells["Region"].Value = "WA";
e.Row.Cells["City"].Value = "Redmond";
e.Row.Cells["PostalCode"].Value = "98052-6399";
e.Row.Cells["Region"].Value = "NA";
e.Row.Cells["Country"].Value = "USA";
e.Row.Cells["CustomerID"].Value = NewCustomerId();
}
17、数据验证
Validate Data in the Windows Forms DataGridView ControlSamples:
private void dataGridView1_CellValidating
(object sender,DataGridViewCellValidatingEventArgs e){
// Validate the CompanyName entry by disallowing empty strings.
if (dataGridView1.Columns[e.ColumnIndex].Name == "CompanyName"){
if (e.FormattedValue.ToString() == String.Empty){
dataGridView1.Rows[e.RowIndex].ErrorText
="Company Name must not be empty";
e.Cancel = true;
}
}
}
18、数据提交到dataset中
DataSet ds = new DataSet("MyDataSet");
ds.Tables[biaom.Trim()].Rows.Clear();
try{for (int i = 0; i < dataGridView1.Rows.Count - 1; i++){
DataTable dt = ds.Tables[biaom.Trim()];
DataRow myrow = ds.Tables[biaom.Trim()].NewRow();
for (int j = 0; j < dataGridView1.Columns.Count; j++){
myrow[j] = Convert.ToString(dataGridView1.Rows[i].Cells[j].Value);
}
ds.Tables[biaom.Trim()].Rows.Add(myrow);
}
}
catch (Exception){
MessageBox.Show("输入类型错误!");
return;
}
以上就是C#中对DatagridView部分常用操作的内容,更多相关内容请关注PHP中文网(www.php.cn)!