会员
周边
众包
新闻
博问
闪存
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
NanKe Sir's Blog
博客园
首页
管理
sqlserver与c#中数据类型的对应关系(转)
sqlserver与c#中数据类型的对应关系
sqlserver与c#中数据类型的对应关系
sqlserver与c#中数据类型的对应关系
/**/
///
///
数据库中与c#中的数据类型对照
///
///
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
"
:
//
0为false
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;
}
posted @
2008-02-27 09:59
NanKe Sir's Blog
阅读(
668
) 评论(
0
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部