S
Samuel Shulman
Hi
For numeric columns I want to align it to the right
How can I do that?
Samuel
For numeric columns I want to align it to the right
How can I do that?
Samuel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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").DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
Ken
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").DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
Ken
J
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=MyHelper.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
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=MyHelper.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
S
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
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
G
gene kelley
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.Style.Alignment = _
DataGridViewContentAlignment.MiddleCenter
Where Index can be the column index value or the column name string
Gene