I hope that I have chosen the correct category for my question, but if not, please excuse me I am new. So to the point... I have loaded a excel file using OleDB connection. The code loads the excel file to a dataGridView. Now I want to use the values of the datatable, lets sum, multiply, compare and so on. Over the net I have found only the static way of doing this

object 1 = DATATABLE.Compute("sum(NameOfTable)", "").ToString();

But since i load different excel files, i need a more genuine way.

Thanks in advance