blocks|key|4483355|text|您可以在ToString调用中使用string+format+codes。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4483356|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/0c899ak8.aspx^0|H|J|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You can use <a href="http://msdn.microsoft.com/en-us/library/0c899ak8.aspx" rel="noreferrer">string format codes</a> in your ToString call.

blocks|key|418968|text|MartGriff，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|418969|我最好的建议是使用SqlMoney类型将其转换为双精度型。在那里，你可以随心所欲地输出它！|418970|下面是一个例子：|418971|System.Data.SqlTypes.SqlMoney+ReturnValue;

//Set+your+returnValue+with+your+SQL+statement
ReturnValue+=+ExecuteMySqlStatement();

//Get+the+format+you+want

//$30.00
string+currencyFormat+=+ReturnValue.ToDouble().ToString("c");

//30.00
string+otherFormat+=+ReturnValue.ToDouble().ToString("0.00");|code-block|syntax|javascript|418972|有关更多格式选项，请查看MSDN：|418973|http://msdn.microsoft.com/en-us/library/system.double.tostring.aspx|offset|length|418974|祝你好运，我希望这对你有帮助。|418975|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|1V|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|12|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|13|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|14|8|@]|9|@$O|15|P|16|1|17]]|A|$]]|$1|Q|3|R|5|6|7|18|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|N]]]]

MartGriff,

My best advice would be to convert it to a double using the SqlMoney type. From there, you can output it however you would like!

Here's an example:

<pre><code>System.Data.SqlTypes.SqlMoney ReturnValue;

//Set your returnValue with your SQL statement
ReturnValue = ExecuteMySqlStatement();

//Get the format you want

//$30.00
string currencyFormat = ReturnValue.ToDouble().ToString("c");

//30.00
string otherFormat = ReturnValue.ToDouble().ToString("0.00");
</code></pre>

For more formatting options, check out the MSDN:

<a href="http://msdn.microsoft.com/en-us/library/system.double.tostring.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/system.double.tostring.aspx</a>

Best of luck, I hope this helps.

blocks|key|1071603|text|是否要使用货币字符格式化字符串？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071604|如果是的话..。|1071605|decimal+m+=+3.4;

string+s+=+string.Format("{0:c}",+m);

//+s+will+be+£3.40,+$3.40,+etc+depending+on+your+locale+settings|code-block|syntax|javascript|1071606|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Do you want your string formatted using a currency character?

If so...

<pre><code>decimal m = 3.4;

string s = string.Format("{0:c}", m);

// s will be £3.40, $3.40, etc depending on your locale settings
</code></pre>

blocks|key|4483402|text|我会使用像这样的东西|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4483403|string+value+=+ReturnValue.ToString("0.00");|code-block|syntax|javascript|4483404|它使用接受格式字符串的ToString重载。上面的格式字符串"0.00“指定了两个小数位。|4483405|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I'd use something like 

<pre><code>string value = ReturnValue.ToString("0.00");
</code></pre>

This uses the ToString overload that accepts a format string.
The above format string "0.00" specifies two decimal places.

blocks|key|1076773|text|我目前正在开发一个船坞网络系统，使用VS+2013社区版。我正在尝试解决如何将货币值输出到文本框中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1076774|我使用的方法是|1076775|fieldName.Text+=+decimalValue.ToString("c")；|1076776|它工作得很完美。|1076777|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I am currently developing a boatdock web system, using VS 2013 Community edition. I was trying to work out how to output a currency value into a textbox.

The method that I used was 

fieldName.Text = decimalValue.ToString("c");

It works perfectly.

blocks|key|3637854|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3637855|yourValueHere.ToString("0.00")|code-block|syntax|javascript|3637856|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:

<pre><code>yourValueHere.ToString("0.00")
</code></pre>

blocks|key|419018|text|我的建议是首先将其转换为Decimal。我会使用类似这样的东西：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|419019|string+value+=+(Convert.ToDecimal(ReturnValue)).ToString("0,0.00");|code-block|syntax|javascript|419020|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

My recommendation is to convert it to Decimal firstly. I'd use something like this:

<pre><code>string value = (Convert.ToDecimal(ReturnValue)).ToString("0,0.00");
</code></pre>

blocks|key|1071635|text|在SQLServer中，货币数据类型相当于一个精度为4位小数的小数。我假设当小数转换为字符串时，精度是守恒的。最好的选择是在进行转换时始终使用格式字符串，例如"#，##0.00“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1071636|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In SQLServer a money data type is the equivalent of a decimal with 4 decimal places of precision. I would assume this is precision is conserved when the decimal is converted to a string. The best option would be to always use a format string eg "#,##0.00" when doing the conversion.

blocks|key|4483547|text|Money数据类型的精度为4位小数。您需要在ToString()参数中指定格式，或者在转换为字符串之前对值进行四舍五入。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4483548|据我所知，如果你使用.ToString()，你不会得到任何舍入。我想你只是把数字弄丢了。|4483549|如果你四舍五入，你不只是砍掉了数字。以下是四舍五入的示例(未经测试的代码)：|4483550|string+value+=+Math.Round(ReturnValue,+2).ToString();|code-block|syntax|javascript|4483551|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The Money data type has a precision of 4 decimal places. You'll need to either specify the format in the ToString() arguments or you can round off the value before converting to a string.

If you use .ToString() you're not getting any rounding as far as I know. I think you just lose the digits.

If you round, you're not just chopping off digits. Here's a sample for rounding (untested code):

<pre><code>string value = Math.Round(ReturnValue, 2).ToString();
</code></pre>

blocks|key|419045|text|string+value+=+(Convert.ToDecimal(ReturnValue)).ToString("c");|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|419046|C代表货币p代表百分比。你可以使用a+list+of+other+letters。|unstyled|offset|length|419047|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings^0|0|H|N|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

<pre><code>string value = (Convert.ToDecimal(ReturnValue)).ToString("c");
</code></pre>

c is for currency
p for percentage.
There is <a href="https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings" rel="nofollow noreferrer">a list of other letters</a> you can use.

I am querying a database field that returns a money value, I am assigning this to a string but it is adding extra 00 on the end.

e.g. Query returns <code>30.00</code>

I assign this to a string (<code>string value = Convert.ToString(ReturnValue);</code>)
but when I output it, it is showing as <code>30.0000</code>

Can you advise me where I'm going wrong and the best way to approach this?

C# Currency to string

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在查询一个返回货币值的数据库字段，我将其赋值给一个字符串，但它在末尾添加了额外的00。例如，查询返回30.00我将它赋给一个字符串(string value = Convert.ToString(ReturnValue);)，但是当我输出它时，它显示为30.0000你能告诉我我哪里错了吗?最好的解决方法是什么？

问字符串的C#货币
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问字符串的C#货币EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问字符串的C#货币
EN