<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>

```
```
this.txtPayment.Text = string.Format("{0:c}", dr[Payment"].ToString());
```
```