show other value in datagrid than the value in the dataset

[vbkal]

I have a datagrid where one column contains a distance between two places. If the value in a row == null then I want to SHOW that value retrieved from another table.

My question : I only want to SHOW this value in the column and not set in the dataset (so it doesn't get updated)

Is there a way to achieve this?

 

[chmohan]

yes add a hidden grid column with your distance between twoplaces

and check if the column is having empty string value for the row when loading the grid,if it is,set the value to the hidden grid column value for that row

 

[vbkal]

thx,

problem solved!