Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)delvpublished in(发表于) 2014/1/24 9:07:43 ASP.NET如何保留两位小数点_[Asp.Net教程]
问题:要在Datagrid中显示时间为2.08小时,我在SQL中这样处理:SELECT 125 / 60.00 AS float但在Datagrid中显示为2.083333,请问如何写代码只保留两位小数点2.08?______________________________________________________________________________________________答1:float(7,2)2表示保留两位小数______________________________________________________________________________________________答2:float(8,2)?在哪写呢? ______________________________________________________________________________________________答3:在datagrid的属性生成器中,列,数据格式设置表达式加上:{0:f2}______________________________________________________________________________________________答4:1.在sql语句中:select convert(dt,numeric(5,2)) from
2.在datagrid的绑定列的数据格式一栏添加:{0:f2}______________________________________________________________________________________________答5:任选其一______________________________________________________________________________________________答6:是这样写吗“select convert(125/60.00,numeric(5,2)) from ”?这样写运行时出错啦...
______________________________________________________________________________________________答7:select round(125/60.00,2)______________________________________________________________________________________________答8:select cast(125/60.00 as numeric(5,2))______________________________________________________________________________________________答9:Thank you.请问使用round和cast有何区别?______________________________________________________________________________________________答10:把数据库中的相应字段设置为decimal,然后把他的小数位改成2______________________________________________________________________________________________答11:在Datagrid的OnItemDataBound事件中写e.item.cell[0].text = float(7,2).Tostring()就在dg中第0列中转换并显示出来了
______________________________________________________________________________________________答12:方法确定很多1、设计字段时类型为numeric,小数位设置成22、在sql语句中转换:select convert(字段,numeric(18,2)) AS 字段Ex from 表 如果是datagrid绑定列,则
3、在datagrid的绑定列的属性中这样使用
赞