2024年4月19日发(作者：)

17 break;

18 case "datetime":

19 dbType = me;

20 break;

21 case "decimal":

22 dbType = l;

23 break;

24 case "float":

25 dbType = ;

26 break;

27 case "image":

28 dbType = ;

29 break;

30 case "money":

31 dbType = ;

32 break;

33 case "ntext":

34 dbType = ;

35 break;

36 case "nvarchar":

37 dbType = ar;

38 break;

39 case "smalldatetime":

40 dbType = ateTime;

41 break;

42 case "smallint":

43 dbType = nt;

44 break;

45 case "text":

46 dbType = ;

47 break;

48 case "bigint":

49 dbType = ;

50 break;

51 case "binary":

52 dbType = ;

53 break;

54 case "char":

55 dbType = ;

56 break;

57 case "nchar":

58 dbType = ;

59 break;

60 case "numeric":

61 dbType = l;

62 break;

63 case "real":

64 dbType = ;

65 break;

66 case "smallmoney":

67 dbType = oney;

68 break;

69 case "sql_variant":

70 dbType = t;

71 break;

72 case "timestamp":

73 dbType = amp;

74 break;

75 case "tinyint":

76 dbType = t;

77 break;

78 case "uniqueidentifier":

79 dbType = Identifier;

80 break;

81 case "varbinary":

82 dbType = ary;

83 break;

84 case "xml":

85 dbType = ;

86 break;

87 }

88 return dbType;

89 }

1 // sql server中的数据类型，转换为C#中的类型类型

2 public static Type SqlTypeString2CsharpType(string sqlTypeString)

3 {

4 SqlDbType dbTpe = SqlTypeString2SqlType(sqlTypeString);

5

6 return SqlType2CsharpType(dbTpe);

7 }

8

9 // 将sql server中的数据类型，转化为C#中的类型的字符串

10 public static string SqlTypeString2CsharpTypeString(string sqlTypeString)

11 {

12 Type type = SqlTypeString2CsharpType(sqlTypeString);

13

14 return ;

15 }