Hello,
I have a iterative process in which I look for certain numeric values in two columns of a datatable (dt1) and if the calculations meet a certain criteria, I then copy those values into a separate table (dt2). Because the process involves many thousands of iterations, I want to make sure I have the fastest approach.
My question is when I set a column for a double value in dt1 as below, what does this accomplish anything versus setting it to a string? It seems I still have to double.Parse when I need the value for a calculation or when I copy the value into dt2. Should I just setup all table columns as strings and parse.double only when I need to apply calculations to the values? Also, when extracting the values from the datatable for calculation, is double.Parse the quickest solution? Or Convert.ToDouble? Or (double)? I'm not sure if the latter two cases would even work.
Again, I have a working solution, but it can take several minutes to run becaus ...
Go to the complete details ...