当前位置：Gxlcms >
数据库问题 >
在C#项目中需要用double类型操作MSSQL float类型数据（附C#数据类型和SQL数据类型对照）
在C#项目中需要用double类型操作MSSQL float类型数据（附C#数据类型和SQL数据类型对照）
时间：2021-07-01 10:21:17
帮助过：3人阅读
<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数据类型对照）
标签：
