title: Returning on ISNULL decimal "0,00"
body: <p>Hello I have got this query that I would like to return '0,00' insead of '0'</p>
  
  <p>When I tried to write it like this:</p>
  
  <pre><code>string sqlcom = "SELECT (ISNULL(s_prijmy, 0,00)), * FROM zajezd WHERE akce &gt;= '" + txt_od.Text + "'AND akce &lt;='" + txt_do.Text + "' AND rocnik='" + klientClass.Rocnik() + "'";
  </code></pre>
  
  <p>It gives me following Exception:</p>
  
  <blockquote>
    <p>System.InvalidCastException: Specified cast is not valid. at
    System.Data.SqlClient.SqlBuffer.get_Decimal()</p>
  </blockquote>
  
  <p>May I ask how can I fix it ?</p>
  
  <p>Thanks in adavance.</p>
  
  <p>Future use of this '0,00' should be following : </p>
  
  <pre><code>this.chart1.Series["Příjmy"].Points.AddXY(myreader.GetString(myreader.GetOrdinal("akce")), myreader.GetDecimal(34).ToString()); // the 34th column
  </code></pre>