How to set default value in string.format if object is null?

Question

How to set default value in string.format if row["ONEYR" ] is null? @String.Format("{0:0.00;(0.00)}", row["ONEYR"])

Sandy · Answer

Thanks for your answer I have a lot of fields in my page and i don't want to write duplicate code becasuse it is not good practice to check each column with null and also firstly convert each object to string which also take memory conumption. Is there is any altneratives of this or how can we do this in best way?

Cynthia Sathuragiri · Answer

It is possible to provide the different format of positive ,negative and zero-valued paramater by separating the format with ';' character.So by checking the object whether it is null using ternary operator we can able to set the default value in string.format function @String.Format("{0:0.00;(0.00);N/A}",row["ONEYR"]==null ? 0 : row["ONEYR"])

Nitin Sontakke · Answer

There is no majic as such. You will obviously need to handle it with code. @String.Format("{0:0.00;(0.00)}", row["ONEYR"] == null ? 0 : row["ONEYR"])

Nitin Sontakke · Answer

Furthermore, if you have a lot of fields which can potentially be null in database, it means your database design is also not quite normalized.

Nitin Sontakke · Answer

I appreciate that you DO NOT accept the given answer and ask more questions. Now that you do that, we will have to dig a bit deeper. Where is the data coming from? Which database are you using? Is there a stored procedure written? And now that you care so much for performance, to write row["ONEYR"] is not a good practice. Are you using dataTable to fetch data? If yes, that is not a good practice either.