Home > Win App > Format Data in the Windows Forms DataGridView Control

Format Data in the Windows Forms DataGridView Control

Useful coding for formation the cells in datagridview in MSDN site

To enable wordwrap in text-based cells

this.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True;

To specify the text alignment of DataGridView cells

this.dataGridView1.Columns["CustomerName"].DefaultCellStyle.Alignment 
= DataGridViewContentAlignment.MiddleRight;

To customize the display of null database values

this.dataGridView1.DefaultCellStyle.NullValue = "no entry";

To format currency and date values

this.dataGridView1.Columns["UnitPrice"].DefaultCellStyle.Format = "c";
this.dataGridView1.Columns["ShipDate"].DefaultCellStyle.Format = "d";

And also as below

dataGridView1.Columns[0].DefaultCellStyle.Format = “dd’/’MM’/’yyyy”;

//Get 13/12/2007

dataGridView1.Columns[1].DefaultCellStyle.Format = “dd’/’MM’/’yyyy hh:mm:ss tt”;

//Get 13/12/2007 5:00:11 PM

Advertisements
Categories: Win App
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: