<div>
what do you get? what is the value of s?<br />
<br />
you can also try string.Format(&quot;{0:C}&quot;, rdr[&quot;myValue&quot;].ToString())<wbr />;
</div>


what do you get? what is the value of s?

you can also try string.Format("{0:C}", rdr["myValue"].ToString());

<div>
String.Format(&quot;{0:.##}&quot;, rdr[&quot;myValue&quot;].ToString())<wbr />;
</div>


String.Format("{0:.##}", rdr["myValue"].ToString());

<div>
@p_davis - I'm getting &quot;0.0000&quot; as a result for <br />
string s = string.Format(&quot;{0:c}&quot;, rdr[&quot;myValue&quot;].ToString())<wbr />;<br />
<br />
I tried string s = string.Format(&quot;{0:C}&quot;, rdr[&quot;myValue&quot;].ToString())<wbr />;<br />
and still getting &quot;0.0000&quot;
</div>


@p_davis - I'm getting "0.0000" as a result for
string s = string.Format("{0:c}", rdr["myValue"].ToString());

I tried string s = string.Format("{0:C}", rdr["myValue"].ToString());
and still getting "0.0000"

<div>
<div class="content wysiwyg-content">
I have a value I am retrieving from a database. &nbsp;I am assigning the value to a text box on my asp.net form. &nbsp;The field in the database is a money value. &nbsp;I want the below result.<br />
<br />
Database Value &nbsp; &nbsp; Result Value<br />
0.000000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00<br />
<br />
I have tried the following<br />
<br />
string s = string.Format(&quot;{0:c}&quot;, rdr[&quot;myValue&quot;].ToString())<wbr />;<br />
this.myTextBox.text = s;<br />
<br />
and<br />
<br />
string s = string.Format(&quot;{0:#,0.00}&quot;<wbr />, rdr[&quot;myValue&quot;].ToString())<wbr />;<br />
this.myTextBox.text = s;<br />
<br />
But neither works.<br />
<br />
Any ideas?
</div>
</div>


I have a value I am retrieving from a database.  I am assigning the value to a text box on my asp.net form.  The field in the database is a money value.  I want the below result.

Database Value     Result Value
0.000000                0.00

I have tried the following

string s = string.Format("{0:c}", rdr["myValue"].ToString());
this.myTextBox.text = s;

and

string s = string.Format("{0:#,0.00}", rdr["myValue"].ToString());
this.myTextBox.text = s;

But neither works.

Any ideas?

ASP.NET - C# - Format string to numeric value

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).