VB.Net - DataTable Add Column and Perform Calculation
Posted on 2015-02-03
Good Day Experts!
I have a little project going on here that I am looking for a bit of help on. I have a DataTable that is filled with query results from a SQL query. Once I fill that DataTable I would like to add a column to the DataTable and then put in the column the value of subtracting 2 columns that were already present in the DataTable.
I have added the column. But now how do I subtract two columns in the DataTable and put the results in this new column:
tblGetExportReseachFinal.Columns.Add("Count Remaining", Type.GetType("System.Integer"))