首页 > 代码库 > 在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数据类型对照)