转换数值数据 [英] Convert numeric data

问题描述

大家好
我在类型为numeric(10,5)的数据库中有一个字段
在此字段中，用户输入数据可以是22或22.22或22.2222或其他任何值.
现在我的问题是，当我使用选择查询检索数据并将其绑定到datagridview时，它显示22.00000或22.22000或22.22220 bu我分别要22、22.22和22.2222.
您能否说出我该如何实现此目标?

Hi all
I have a field in database of type numeric(10,5)
in this field user enters data it can be 22 or 22.22 or 22.2222 or anything.
Now my problem is when i retrieve the data using select query and bind to datagridview it displays 22.00000 or 22.22000 or 22.22220 bu i want 22 ,22.22 and 22.2222 respectively.
can u say how can i achieve this

推荐答案

double dblValue = 2222.22220;;
Console.WriteLine(dblValue.ToString("N", CultureInfo.InvariantCulture));
// Displays 2,222.22

Console.WriteLine(dblValue.ToString("N1", 
                  CultureInfo.CreateSpecificCulture("sv-SE")));
// Displays -12 445,7

int intValue = 123456789;
Console.WriteLine(intValue.ToString("N1", CultureInfo.InvariantCulture));
// Displays 123,456,789.0

有关更多信息，请 http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx [^ ]
http://stackoverflow.com/questions/1872094/how-to- display-numeric-in-3-digit-grouping [ ^ ]
http://stackoverflow.com/questions/2360372/digit-grouping-in-net [ ^ ]
http://www.dreamincode.net/forums/topic/226278-c ％23-menu-digit-grouping/ [

For more info http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx[^]
http://stackoverflow.com/questions/1872094/how-to-display-numeric-in-3-digit-grouping[^]
http://stackoverflow.com/questions/2360372/digit-grouping-in-net[^]
http://www.dreamincode.net/forums/topic/226278-c%23-menu-digit-grouping/[^]

double value = 22.2222;
double result;
double.TryParse(value.ToString(), NumberStyles.Any, CultureInfo.InvariantCulture, out result);

在需要的地方使用结果.

use result where you want.

这篇关于转换数值数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！