I am glad you managed to do it.

>Ahmad,
>
>Thanks for the reply. It led me to what I needed to figure out. I figured out that you need to put the classname for the MappingName property. Works ok now.
>
>Thanks
>Dan
>
>>Dan,
>>
>>To format the DataGrid the way you want it you must use the "DataGridTableStyle", review the following code it may help you.
>>

>>' Load DataGrid
>>Me.dgSearchResult.DataSource = myDS.Tables("Search")
>>Me.dgSearchResult.ReadOnly = True
>>Me.dgSearchResult.AllowNavigation = False
>>Me.dgSearchResult.AllowSorting = False
>>
>>' Now, Add the new DataGrid view
>>Call MyAddCustomDataTableStyle_Search()
>>
>>Private Sub MyAddCustomDataTableStyle_Search()
>>        ' Make new DataTableStyle for DataGrid
>>        Dim ts As New DataGridTableStyle()
>>        ts.MappingName = "Search"
>>        ts.ReadOnly = True
>>        ts.AllowSorting = False
>>        ts.AlternatingBackColor = Color.LightYellow
>>
>>        Dim TextCol1 As New DataGridTextBoxColumn()
>>        TextCol1.MappingName = "EmployeeID"
>>        TextCol1.HeaderText = "EmployeeID"
>>        TextCol1.Width = 65
>>        TextCol1.NullText = ""
>>
>>        ts.GridColumnStyles.Add(TextCol1)
>>
>>        Dim TextCol2 As New DataGridTextBoxColumn()
>>        TextCol2.MappingName = "Name_e"
>>        TextCol2.HeaderText = "English Name"
>>        TextCol2.Width = 150
>>        TextCol2.NullText = ""
>>
>>        ts.GridColumnStyles.Add(TextCol2)
>>
>>        Dim TextCol3 As New DataGridTextBoxColumn()
>>        TextCol3.MappingName = "Name_a"
>>        TextCol3.HeaderText = "Arabic Name"
>>        TextCol3.Width = 150
>>        TextCol3.NullText = ""
>>
>>        ts.GridColumnStyles.Add(TextCol3)
>>
>>        Dim TextCol4 As New DataGridTextBoxColumn()
>>        TextCol4.MappingName = "CivilID"
>>        TextCol4.HeaderText = "Civil ID"
>>        TextCol4.Width = 90
>>        TextCol4.NullText = ""
>>
>>        ts.GridColumnStyles.Add(TextCol4)
>>
>>        ' Add the TableStyle to the original DataGrid
>>        Me.dgSearchResult.TableStyles.Add(ts)
>>End Sub
>>

>>
>>HTH
>>
>>
>>>I'm trying to bind a collection to the Windows Forms DataGrid. How do I format the grid to display the columns I want? I've tried creating a DataGridTableStyle object but it doesn't seem to use it. Any ideas?
>>>
>>>Thanks,
>>>Dan