• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

C#和SQLServer类型转换

原作者: [db:作者] 来自: [db:来源] 收藏 邀请
/// <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;
}

  


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
热门推荐
热门话题
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap