Help doing simple math in a datagridview

[oceantrain]

I am new to C#. I have a datagridview with 9 columns. I am simply trying take the value in column 5 and subtract it from column 6. Then display the result in column 9. It seems simple enough.I know it's done in excel all the time. But I just cannot figure this out. Do I need to create a new class with a method called calculate columns? or does the datagridview class have something already built in that can handle this?

[MrMancunian]

What do you already have? Did you already check the MSDN?

Steven

[oceantrain]

Steven,
Thanks for the reply. I found this on MSDN

http://msdn.microsoft.com/en-us/library/system.data.datatable.compute.aspx

But I have not yet tried to implement it. This task of calculating 2 columns and displaying the result in a 3rd column seems like it would be something that has been done many times before. But I just can't find the code to implement it.

[oceantrain]

What do you already have? Did you already check the MSDN?

Steven

Steven,
Thanks for the reply. I found this on MSDN

http://msdn.microsoft.com/en-us/libr...e.compute.aspx

But I have not yet tried to implement it. This task of calculating 2 columns and displaying the result in a 3rd column seems like it would be something that has been done many times before. But I just can't find the code to implement it.

[stoogots2]

Not sure if this is the most efficient, but I would create TemplateField in your GridView and override the RowCreated event to do the math.