I have a datatable with 2 columns "LONG" and "SHORT". before binding to grid, i need to add one more column "NET" .
NET = LONG - SHORT.
I need to calculate NET value by substracting short from long and I have to handle NULL values too if in case short or long is null.
Finally, my datatable shd be
long short Net
2 1 1
3 3 0
Please someone help me... I tried dng this bt I am missing something. i am not getting exaclty the way i am looking for. Please help me...