Home Backend Development C#.Net Tutorial Some common operations on DatagridView in C#

Some common operations on DatagridView in C#

Dec 21, 2016 pm 02:50 PM

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


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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Active Directory with C# Active Directory with C# Sep 03, 2024 pm 03:33 PM

Guide to Active Directory with C#. Here we discuss the introduction and how Active Directory works in C# along with the syntax and example.

Access Modifiers in C# Access Modifiers in C# Sep 03, 2024 pm 03:24 PM

Guide to the Access Modifiers in C#. We have discussed the Introduction Types of Access Modifiers in C# along with examples and outputs.

Random Number Generator in C# Random Number Generator in C# Sep 03, 2024 pm 03:34 PM

Guide to Random Number Generator in C#. Here we discuss how Random Number Generator work, concept of pseudo-random and secure numbers.

C# Data Grid View C# Data Grid View Sep 03, 2024 pm 03:32 PM

Guide to C# Data Grid View. Here we discuss the examples of how a data grid view can be loaded and exported from the SQL database or an excel file.

C# StringReader C# StringReader Sep 03, 2024 pm 03:23 PM

Guide to C# StringReader. Here we discuss a brief overview on C# StringReader and its working along with different Examples and Code.

Patterns in C# Patterns in C# Sep 03, 2024 pm 03:33 PM

Guide to Patterns in C#. Here we discuss the introduction and top 3 types of Patterns in C# along with its examples and code implementation.

C# Serialization C# Serialization Sep 03, 2024 pm 03:30 PM

Guide to C# Serialization. Here we discuss the introduction, steps of C# serialization object, working, and example respectively.

BinaryWriter in C# BinaryWriter in C# Sep 03, 2024 pm 03:22 PM

Guide to BinaryWriter in C#. Here we discuss syntax and explanation, how it works with examples to implement with proper codes.

See all articles