Changing from a number field to a Combo in Datagrid
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?