首页 > 代码库 > 在C#项目中需要用double类型操作MSSQL float类型数据(附C#数据类型和SQL数据类型对照)
在C#项目中需要用double类型操作MSSQL float类型数据(附C#数据类型和SQL数据类型对照)
C#操作SQL Float类型,数据会多很多小数,原来是C#的float和sql的float类型不一致。以下是数据库中与C#中的数据类型对照。
/// <summary> /// 数据库中与C#中的数据类型对照 /// </summary> /// <param name="type"></param> /// <returns></returns> private string ChangeToCSharpType(string type) { string reval = string.Empty; switch (type.ToLower()) { case "int": reval = "Int32"; break; case "text": reval = "String"; break; case "bigint": reval = "Int64"; break; case "binary": reval = "System.Byte[]"; break; case "bit": reval = "Boolean"; break; case "char": reval = "String"; break; case "datetime": reval = "System.DateTime"; break; case "decimal": reval = "System.Decimal"; break; case "float": reval = "System.Double"; break; case "image": reval = "System.Byte[]"; break; case "money": reval = "System.Decimal"; break; case "nchar": reval = "String"; break; case "ntext": reval = "String"; break; case "numeric": reval = "System.Decimal"; break; case "nvarchar": reval = "String"; break; case "real": reval = "System.Single"; break; case "smalldatetime": reval = "System.DateTime"; break; case "smallint": reval = "Int16"; break; case "smallmoney": reval = "System.Decimal"; break; case "timestamp": reval = "System.DateTime"; break; case "tinyint": reval = "System.Byte"; break; case "uniqueidentifier": reval = "System.Guid"; break; case "varbinary": reval = "System.Byte[]"; break; case "varchar": reval = "String"; break; case "Variant": reval = "Object"; break; default: reval = "String"; break; } return reval; }
数据库中与C#中的数据类型对照
在C#项目中需要用double类型操作MSSQL float类型数据(附C#数据类型和SQL数据类型对照)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。