Align-Right text in DataGrid's column

[albertlse]

How can i make the text inside a DataGrid's column align right? (default is align left)

For your information, my DataGrid is mapped to a DataSource which is DistributeDataSet.
Therefore I did not defined any tablestyle to the DataGrid in the design layout.
So how can I use coding to set some of the columns in DataGrid agliment to right?

please guide thank you.

[CoMMiE]

hi
all you need to do is just set the texboxcolumn table style text alignment to right align

[albertlse]

For your information, my DataGrid is mapped to a DataSource which is DistributeDataSet.
Therefore I did not defined any tablestyle to the DataGrid in the design layout.
So how can I use coding to set some of the columns in DataGrid agliment to right?
please guide, thank you.

[CoMMiE]

Dim dgUnit_PriceColumnStyle As New DataGridTextBoxColumn()
Dim dgGoodsOutTableStyle As New DataGridTableStyle()


With dgLine_NOColumnStyle
.Aignment =HorizontalAlignment.Right
.MappingName = "Line_NO"
.HeaderText = "Line No"
.Width = 30
.ReadOnly = True
.NullText = vbNullString
End With
dgGoodsOutTableStyle.GridColumnStyles.Add(dgLine_NOColumnStyle)

Datagrid1.TableStyles.Add(dgGoodsOutTableStyle)

[albertlse]

what if i only want to apply the "align right" setting to only column 2, column 5, and column 7 of the DataGrid, not all columns? what should i do?

[CoMMiE]

the code i posted actually allow you to do that, for example if "Line_No" in the MappingName is actually col1 then the property that we set will only apply to that col and not all the col

[albertlse]

I still cannot managed to do it. I followed ur guide but still fail...

For your information, in the design layout, my DataGrid does not has any columns.
My DataGrid's DataSource is mapped to a DataSet.
So when the DataGrid is loaded, the DataGrid does not has any columns.
The DataGrid will only display the columns once the DataSet is filled.

So how should I set the alignment?

Please guide thank you!

[CoMMiE]

hi
can you please verify that the mapping name property of the DataGridTextBoxColumn is same as the datatable column in the dataset your are trying to map to?

if all else fail, maybe you can post the code where you bind the datagrid to the dataset and we will see whats wrong from there

[albertlse]

Please download the attachment for my coding...

P/S: You may need to change the Database Connection path to link to the database.

Select from combobox 1
Then, select from combobox 2
The DataGrid will be filled.

I want to make the following columns to alignment right:
1. Taken
2. Return
3. Sold
4. NetPrice
5. TotalPrice

Hope you can help me with this.

Please guide thank you.