title: Best way to display/format SQL 2005 money data type in ASP.Net
body: <p>I am attempting to set an asp.net textbox to a SQL 2005 money data type field, the initial result displayed to the user is 40.0000 instead of 40.00.
  In my asp.net textbox control I would like to only display the first 2 numbers after the decimal point e.g. 40.00</p>
  
  <p>What would be the best way to do this?
  My code is below:</p>
  
  <pre><code>this.txtPayment.Text = dr["Payment"].ToString();
  </code></pre>