Magnificent!
oDataSet.Tables(0).Columns.Add(new DataColumn(“MyNewFieldName”, System.Type.GetType(“System.String”), “CurrentField1 + ‘, ‘ + CurrentField2″)
This code worked great! I noticed that if one of the data fields was null that the new column would return blank, so I just modified it slightly like so:
oDataSet.Tables(0).Columns.Add(new DataColumn(“MyNewFieldName”, System.Type.GetType(“System.String”), “ISNULL(CurrentField1, ‘No Value in CurrentField1’) + ‘, ‘ + ISNULL(CurrentField2, ‘No Value in CurrentField2’)″)