Some common operations on DatagridView in C#

黄舟
Release: 2016-12-21 14:50:41
Original
1702 people have browsed it

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)! 


source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template