title: Converting a Numeric value fetched from a Dataset to a String Asp.net c#?
body: <p>I have a numeric value like this in my db,</p>
  
  <pre><code>14192555.00
  </code></pre>
  
  <p>when i get it and put it in text box and convert it in to string it results in,</p>
  
  <pre><code>this.txtPriorNYSDOTRating.Text = ds.Tables[0].Rows[0]["Fact2A_PriorNYSDOTPerfRatingScore"].ToString();
  14192555.0000
  </code></pre>
  
  <p>for it formatting i also tried,</p>
  
  <pre><code>this.txtPriorNYSDOTRating.Text = ds.Tables[0].Rows[0]["Fact2A_PriorNYSDOTPerfRatingScore"].ToString("0.####");
  </code></pre>
  
  <p>it result in error "<code>no overload for method string</code>"</p>
  
  <p>Hopes for your suggestion thanks in advance</p>
  
  <p>EDITED:</p>
  
  <p>i have date in database like,</p>
  
  <pre><code>2010-10-19 00:00:00.000
  </code></pre>
  
  <p>i get it like,</p>
  
  <pre><code>10/19/2010 12:00:00 AM
  </code></pre>
  
  <p>my code is,</p>
  
  <pre><code>this.txtDesignatedDate.Text =Convert.ToDateTime(ds.Tables[0].Rows[0]["DesignatedDate"]).ToString();
  </code></pre>
  
  <p>how to format it to get only `"10/19/2010"</p>
  
  <p>Hopes for your reply  </p>