C# Data Table holds value to 2dp, but looses 2dp when transferred to a Data Row
<p>I place the results of a stored procedure call into a Data Table.  The stored procedure returns one column as decimal and returns for example 500.00, 500.20. </p>

<p>When this is placed into my data table, I inspect the contents and can see that the decimal places are retained. </p>

<p>However when I loop round the data table to read each of the rows in a for each loop <code>e.g. for each (DataRow row in datatablename.Rows),</code> if I then inspect the contents of  row i have 500 and 500.20 i.e. it looses the zeros after the decimal place. </p>

<p>I need to be able to retain the zeros after the decimal place for display purposes.</p>

<p>The data table that I have used is a generic data table <code>e.g. DataTable results = new DataTable().</code></p>

<p>The table needs to be generic, rather than explicitly declaring each column as the results of many different stored procedures need to go into this table and each stored procedure returns different results (i.e. i don't want to declare some 20 specific data tables).  </p>

<p>Any ideas on how I get the DataRow to retain the zeros after the decimal place?</p>
