DataGridView Column Alignment

[Samuel Shulman]

Hi

For numeric columns I want to align it to the right

How can I do that?

Samuel

[Ken Tucker [MVP]]

Hi,

Change the alignment of the default cell style for the column.

Dim strConn As String
Dim da As SqlDataAdapter
Dim conn As SqlConnection

strConn = "Server = .;Database = AdventureWorks; Integrated Security
= SSPI;"
conn = New SqlConnection(strConn)

da = New SqlDataAdapter("Select * from HumanResources.Employee",
conn)

da.Fill(ds, "Employee")
DataGridView1.DataSource = ds.Tables("Employee")
DataGridView1.Columns("ContactID").DefaultCellStyl e.Alignment =
DataGridViewContentAlignment.MiddleRight
Ken
--------------------------------
"Samuel Shulman" <sa************@ntlworld.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

Hi

For numeric columns I want to align it to the right

How can I do that?

Samuel

[Jim Wooley]

In my solution, I have included a helper class to encapsulate some of these
standard settings. In that class, I have a function which gets a standardized
(for my application) currency formatter as follows:

Public Function DGCurrencyStyle() As DataGridViewCellStyle
Dim Style As New DataGridViewCellStyle
Style.Alignment = DataGridViewContentAlignment.MiddleRight
Style.Format = "c2"
Return Style
End Function

To use it, I modify the .Designer file and set the DataGridViewTextBoxColumn1.DefaultCellStyle=MyHelp er.DGCurrencyStyle.
This way, if I want to change the style throughout my system, I just change
it in the helper and the change is reflected throughout the system.

Jim Wooley
http://devauthority.com/blogs/jwooley/default.aspx

Hi,

Change the alignment of the default cell style for the column.

Dim strConn As String
Dim da As SqlDataAdapter
Dim conn As SqlConnection
strConn = "Server = .;Database = AdventureWorks; Integrated
Security
= SSPI;"
conn = New SqlConnection(strConn)
da = New SqlDataAdapter("Select * from
HumanResources.Employee", conn)

da.Fill(ds, "Employee")
DataGridView1.DataSource = ds.Tables("Employee")
DataGridView1.Columns("ContactID").DefaultCellStyl e.Alignment
=
DataGridViewContentAlignment.MiddleRight
Ken
--------------------------------
"Samuel Shulman" <sa************@ntlworld.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>Hi

For numeric columns I want to align it to the right

How can I do that?

Samuel

[Samuel Shulman]

Thank you,

The actual column header remains on the left and in ListView control it
moves to the right like the content of the list

I am actually not sure what would be the correct way but is there a way of
changing that as well?

Samuel

"Ken Tucker [MVP]" <vb***@bellsouth.netwrote in message
news:uh**************@TK2MSFTNGP06.phx.gbl...

Hi,

Change the alignment of the default cell style for the column.

Dim strConn As String
Dim da As SqlDataAdapter
Dim conn As SqlConnection

strConn = "Server = .;Database = AdventureWorks; Integrated
Security = SSPI;"
conn = New SqlConnection(strConn)

da = New SqlDataAdapter("Select * from HumanResources.Employee",
conn)

da.Fill(ds, "Employee")
DataGridView1.DataSource = ds.Tables("Employee")
DataGridView1.Columns("ContactID").DefaultCellStyl e.Alignment =
DataGridViewContentAlignment.MiddleRight
Ken
--------------------------------
"Samuel Shulman" <sa************@ntlworld.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>Hi

For numeric columns I want to align it to the right

How can I do that?

Samuel

[gene kelley]

On Fri, 11 Aug 2006 15:00:05 +0100, "Samuel Shulman" <sa************@ntlworld.comwrote:

>Thank you,

The actual column header remains on the left and in ListView control it
moves to the right like the content of the list

I am actually not sure what would be the correct way but is there a way of
changing that as well?

Samuel

Me.DataGridView.Columns.Item(Index).HeaderCell.Sty le.Alignment = _
DataGridViewContentAlignment.MiddleCenter

Where Index can be the column index value or the column name string
Gene

>"Ken Tucker [MVP]" <vb***@bellsouth.netwrote in message
news:uh**************@TK2MSFTNGP06.phx.gbl...

>Hi,

Change the alignment of the default cell style for the column.

Dim strConn As String
Dim da As SqlDataAdapter
Dim conn As SqlConnection

strConn = "Server = .;Database = AdventureWorks; Integrated
Security = SSPI;"
conn = New SqlConnection(strConn)

da = New SqlDataAdapter("Select * from HumanResources.Employee",
conn)

da.Fill(ds, "Employee")
DataGridView1.DataSource = ds.Tables("Employee")
DataGridView1.Columns("ContactID").DefaultCellStyl e.Alignment =
DataGridViewContentAlignment.MiddleRight
Ken
--------------------------------
"Samuel Shulman" <sa************@ntlworld.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>>Hi

For numeric columns I want to align it to the right

How can I do that?

Samuel