Solved

VB.Net - DataGridView Center Column Headings

Posted on 2013-01-09
10
557 Views
Last Modified: 2013-01-10
Good Day Experts!

I am having trouble centering the column headings in my DataGridView.  When I have the columns defined prior to loading the DataGrid with data it works fine.  But I can't do that this time.  So, I am trying to do everything programatically. I have the data centered in the columns but I cannot get the column headings centered. Here is what I am trying:

Dim dgvColumnHeaderStyle As New DataGridViewCellStyle()
dgvColumnHeaderStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
dgrdPossDupBills.ColumnHeadersDefaultCellStyle = dgvColumnHeaderStyle

Does anything look wrong with my coding?

Thanks,
jimbo99999
0
Comment
Question by:Jimbo99999
  • 5
  • 4
10 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 38759333
try this one:

dataGridView1.Columns(0).HeaderCell.Style.Alignment = DataGridViewContentAlignment.BottomCenter
0
 

Author Comment

by:Jimbo99999
ID: 38759608
Thanks for replying.  However, it did not work. The column headings are still left justified.

Thanks,
jimbo99999
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 38759643
Where did you put this code? After binding the grid?
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:Jimbo99999
ID: 38759967
I have tried it before and after setting the datasource of the DataGrid to the DataTable.  
Everything else works...the readonly, the autosizing and centering of the data in the columns.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 38760019
Try following

Dim row As Windows.Forms.DataGridViewRow = dgrdPossDupBills.Rows(-1)
' Loop through header cells
For Each HeaderCell As Windows.Forms.DataGridViewHeaderCell In row.Cells
HeaderCell.Style.Alignment = Windows.Forms.DataGridViewContentAlignment.MiddleCenter
Next
0
 

Author Comment

by:Jimbo99999
ID: 38760708
Thanks for responding

I am receiveing and error indicating the Index was out of range.  Must be non-negative and less than the size of the collection.

jimbo99999
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 38761191
Try changing -1 to 0.
0
 

Author Comment

by:Jimbo99999
ID: 38762667
Received error: Unable to cast object of type 'System.Windows.Forms.DataGridViewTextBoxCell' to type 'System.Windows.Forms.DataGridViewHeaderCell'
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 38763493
Ok. Here is the result of my test


SCR
0
 

Author Closing Comment

by:Jimbo99999
ID: 38764564
Excellent, that did the trick for me.

I will certainly add your assistance on the topic to my reference.

Thanks,
jimbo99999
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question