SqlDataType与C#数据类型的转换(转)
1/// <summary>
2 ///
3 /// </summary>
4 /// <param name="type"></param>
5 /// <returns></returns>
6 private string ChangeToCSharpType(string type)
7 {
8 string reval=string.Empty;
9 switch(type.ToLower())
10 {
11 case "int":
12 reval= "Int32";
13 break;
14 case "text":
15 reval= "String";
16 break;
17 case "bigint":
18 reval= "Int64";
19 break;
20 case "binary":
21 reval= "System.Byte[]";
22 break;
23 case "bit":
24 reval= "Boolean";
25 break;
26 case "char":
27 reval= "String";
28 break;
29 case "datetime":
30 reval= "System.DateTime";
31 break;
32 case "decimal":
33 reval= "System.Decimal";
34 break;
35 case "float":
36 reval= "System.Double";
37 break;
38 case "image":
39 reval= "System.Byte[]";
40 break;
41 case "money":
42 reval= "System.Decimal";
43 break;
44 case "nchar":
45 reval= "String";
46 break;
47 case "ntext":
48 reval= "String";
49 break;
50 case "numeric":
51 reval= "System.Decimal";
52 break;
53 case "nvarchar":
54 reval= "String";
55 break;
56 case "real":
57 reval= "System.Single";
58 break;
59 case "smalldatetime":
60 reval= "System.DateTime";
61 break;
62 case "smallint":
63 reval= "Int16";
64 break;
65 case "smallmoney":
66 reval= "System.Decimal";
67 break;
68 case "timestamp":
69 reval= "System.DateTime";
70 break;
71 case "tinyint":
72 reval= "System.Byte";
73 break;
74 case "uniqueidentifier":
75 reval= "System.Guid";
76 break;
77 case "varbinary":
78 reval= "System.Byte[]";
79 break;
80 case "varchar":
81 reval= "String";
82 break;
83 case "Variant":
84 reval="Object";
85 break;
86 default:
87 reval= "String";
88 break;
89 }
90 return reval;
91 }
2 ///
3 /// </summary>
4 /// <param name="type"></param>
5 /// <returns></returns>
6 private string ChangeToCSharpType(string type)
7 {
8 string reval=string.Empty;
9 switch(type.ToLower())
10 {
11 case "int":
12 reval= "Int32";
13 break;
14 case "text":
15 reval= "String";
16 break;
17 case "bigint":
18 reval= "Int64";
19 break;
20 case "binary":
21 reval= "System.Byte[]";
22 break;
23 case "bit":
24 reval= "Boolean";
25 break;
26 case "char":
27 reval= "String";
28 break;
29 case "datetime":
30 reval= "System.DateTime";
31 break;
32 case "decimal":
33 reval= "System.Decimal";
34 break;
35 case "float":
36 reval= "System.Double";
37 break;
38 case "image":
39 reval= "System.Byte[]";
40 break;
41 case "money":
42 reval= "System.Decimal";
43 break;
44 case "nchar":
45 reval= "String";
46 break;
47 case "ntext":
48 reval= "String";
49 break;
50 case "numeric":
51 reval= "System.Decimal";
52 break;
53 case "nvarchar":
54 reval= "String";
55 break;
56 case "real":
57 reval= "System.Single";
58 break;
59 case "smalldatetime":
60 reval= "System.DateTime";
61 break;
62 case "smallint":
63 reval= "Int16";
64 break;
65 case "smallmoney":
66 reval= "System.Decimal";
67 break;
68 case "timestamp":
69 reval= "System.DateTime";
70 break;
71 case "tinyint":
72 reval= "System.Byte";
73 break;
74 case "uniqueidentifier":
75 reval= "System.Guid";
76 break;
77 case "varbinary":
78 reval= "System.Byte[]";
79 break;
80 case "varchar":
81 reval= "String";
82 break;
83 case "Variant":
84 reval="Object";
85 break;
86 default:
87 reval= "String";
88 break;
89 }
90 return reval;
91 }