• SQL SERVER与C#的数据类型对应表


    序号
    类别
    SQLServer
    C Sharp
    备注
    1
    整数
    bit
    Boolean
    True转换为1False转换为0
    2
    tinyint
    Byte
    C Sharp 数据类型都位于System命名空间
    3
    smallint
    Int16
    4
    int
    Int32
    5
    bigint
    Int64
    6
    smallmoney
    Decimal
    7
    money
    Decimal
    8
    numeric
    Decimal
    9
    decimal
    Decimal
    10
    浮点数
    float
    Double
    11
    real
    Single
    12
    日期和时间
    smalldatetime
    DateTime
    13
    datetime
    DateTime
    14
    timestamp
    DateTime
    15
    字符串
    char
    String
    16
    text
    String
    17
    varchar
    String
    18
    nchar
    String
    19
    ntext
    String
    20
    nvarchar
    String
    21
    二进制数据
     
     
    binary
    Byte[]
    22
    varbinary
    Byte[]
    23
    image
    Byte[]
    24
    其他
    uniqueidentifier
    Guid
    25
    Variant
    Object
     
     

    SqlDbType => DbType

    SqlDbType.BigInt				DbType.Int64
    SqlDbType.Binary				DbType.Binary
    SqlDbType.Bit					DbType.Boolean
    SqlDbType.Char					DbType.AnsiStringFixedLength
    SqlDbType.DateTime				DbType.DateTime
    SqlDbType.Decimal				DbType.Decimal
    SqlDbType.Float					DbType.Double
    SqlDbType.Image					DbType.Binary
    SqlDbType.Int					DbType.Int32
    SqlDbType.Money					DbType.Currency
    SqlDbType.NChar					DbType.StringFixedLength
    SqlDbType.NText					DbType.String
    SqlDbType.NVarChar				DbType.String
    SqlDbType.Real					DbType.Single
    SqlDbType.UniqueIdentifier		        DbType.Guid
    SqlDbType.SmallDateTime			        DbType.DateTime
    SqlDbType.SmallInt				DbType.Int16
    SqlDbType.SmallMoney			        DbType.Currency
    SqlDbType.Text					DbType.AnsiString
    SqlDbType.Timestamp				DbType.Binary
    SqlDbType.TinyInt				DbType.Byte
    SqlDbType.VarBinary				DbType.Binary
    SqlDbType.VarChar				DbType.AnsiString
    SqlDbType.Variant				DbType.Object
    SqlDbType.Xml					DbType.Xml
    SqlDbType.Udt					DbType.Object
    SqlDbType.Structured			        DbType.Object
    SqlDbType.Date					DbType.Date
    SqlDbType.Time					DbType.Time
    SqlDbType.DateTime2				DbType.DateTime2
    SqlDbType.DateTimeOffset		        DbType.DateTimeOffset
     
    复制代码
    复制代码
      /// <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;
    }
    复制代码
    复制代码
  • 相关阅读:
    JavaScript初探 三 (学习js数组)
    JavaScript初探 二 (了解数据)
    JavaScript初探 一(认识JavaScript)
    2019暑假学习督促安排
    【C#】让工具栏ToolStrip能触发焦点控件的Leave、Validating、DataError等事件以验证数据
    【C#】回调方法不通过object参数获得委托实例
    【SQL】找出行数与自增标识值不相等的表(即有缺行)
    【SQL】统计所有表的行数
    【SQL】靠谱的TRIM函数,附赠过程一枚
    【C#】在窗体中水平居中的控件,到了XP下不居中的解决办法
  • 原文地址:https://www.cnblogs.com/Alex80/p/11164669.html
一二三 - 开发者的网上家园