| 序号 | 类别 | 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 |
PS.本来打算转载Trackback: ( SQL SERVER与C#中数据类型的对应关系) ,但觉得作者以代码的方式写出来,看起来不是那么直观,查找也不方便.所以参考了作者的文章和SQLServer05的帮助文档制作了以上这个表格.
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1288946
/// <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; }