Changing from a number field to a Combo in Datagrid

[Coppermill]

I have read through all the examples of using a combo in a Datagrid, (from syncfusion.com, gotdotnet.com and C# Corner) and they all seem to be around adding formatting and building the columns. I need to edit the formatting within an existing column.

My problem is that I am pulling in the Data fields direct from the database. like so:

DataAdapter.TableMappings.Add("Table", "Data")
DataSet = New DataSet()

DataAdapter.Fill(DataSet)
dgData.SetDataBinding(DataSet, "Data")


But I need to be able to change the fields which are foreign keys and place a combo which has the correct data to be displayed.

Therefore I need to be able to reformat the column in a DataAdapter.

Is this possible, or am I barking up the wrong tree?