c# - Replacing nulls in table with space -

We have a SQL table that contains a value column that contains several tap entries.

So to see the grid of the table before binding it, I would like to replace it with the location.

  foreach (ds.Tables in DataRow row [0] .Rows) {If (line {"average" "" is the system .dbnlull} {line ["average" "] = convert ToDecimal ("0.00"); // work line ["average"] = ""; // Not working line ["Average Cost"] = Convert. ToDecimal (""); // does not work}}  

I would like to have a grid empty string and not 0.00.

Please suggest.

From your example, it appears that the column average cast is a decimal area that you call it in "space" Will not be able to specify

However, you can add a new column in which the average cost text is represented ...

  DSTibles [0]. Columns Add ("average text", typef (string)); Foreign exchange (Dataraw line in DSTibulls [0] .ro) {line ["average costtext"] = (line ["average list"] == dbnl.low)? String Empty: string.Format ("{0}", line ["average list"]); }