Hi,
I am using a grid which is bound to a dataset and I am using some unbound columns where I am doing some math calculations based on the values entered by the user.
For getting the values from the cell i am using something like
TodateQty = CType(e.Cell.Row.Cells("TodateQty").GetText(Infragistics.Win.UltraWinMaskedEdit.MaskMode.IncludeBoth), Double)
within the cell change event and performing the calculations and updating the other columns.
But even though I made it a double or decimal if the calculation is 152.14 - 150.00 it shows be 2.00 instead of 2.14. How to get it accurate.
Also, If there is any best way suggest me for calculations.
also please provide the link if there is some example in KB.
Thanks
I'm not sure I understand. If you are doing subtraction and getting an incorrect result, then something is seriously wrong on your machine that has nothing to do with the grid. :)
Are you saying that you are getting the correct result, but that the grid is formatting it incorrectly?What do you mean by "it shows 2.00?" What shows it? What are you doing with the result of the calculation you are performing?
Or are you saying that you are getting the wrong value form the grid cell?