I am trying to change the column styles i na datagrid, ive been over
exampel after example and cannot seem to figure it out. I am however
quite close the following code works but the datagrid onyl displays one
column in the datagrid and its the last one that had a column style
applied to it

'make table style for the datagrid
Dim tst As New DataGridTableStyle
tst.MappingName = dsInspections.Tables(3).TableName
tst.BackColor = Color.OldLace
tst.AlternatingBackColor = Color.OldLace
tst.HeaderBackColor = Color.Wheat
tst.HeaderForeColor = Color.SaddleBrown
'add column styles for each column
Dim col1 As DataGridColumnStyle = New DataGridTextBoxColumn
col1.MappingName = "ID"
col1.Width = 50
tst.GridColumnStyles.Add(col1)

Dim col2 As DataGridColumnStyle = New DataGridTextBoxColumn
col1.MappingName = "Item"
col1.Width = 100
tst.GridColumnStyles.Add(col2)

Dim col3 As DataGridColumnStyle = New DataGridTextBoxColumn
col1.MappingName = "Description"
col1.Width = 220
tst.GridColumnStyles.Add(col3)

Dim col4 As DataGridColumnStyle = New DataGridTextBoxColumn
col1.MappingName = "Quantity"
col1.HeaderText = "QTY"
col1.Width = 220
tst.GridColumnStyles.Add(col4)

'add table style to the datagrid
dgMods.TableStyles.Add(tst)
dgMods.Refresh()