General Methodology

Question

Greetings:

I am currently learning the C# .NET programming language and I wanted to throw out some general questions.  Your feedback is extremely important to my learning process.

In developing applications that access SQL back-ends there are a million ways to accomplish the same task and I am trying to develop my own standards and methods for my own sanity :-) - I will start with an easy one and hopefully drill down.

Lets say I am reading a table to be displayed in a datagridview.  If I need a column in the grid for calculations on each row what is the best approach to populating the grid?  Do I:

• create the column in the DATATABLE for the calculations, loop through the table after the .fill to populate the calculated field?
• create the column in the DATAGRIDVIEW for the calculations, loop the table after the .fill to populate the caclulated field?

From what I can determine, either way I am going to need to loop through the data table to process each row individually, correct?

Thanks for all your help as I plan on residing in these forums  for an extended period!  Cheers!