DbType 《==》 Type

1. Type ==>DbType:

01	public static DbType TypeToDbType(Type t)

02

{

03	DbType dbt;

04

try

05

{

06	dbt = (DbType)Enum.Parse(typeof(DbType), t.Name);

07

}

08

catch

09

{

10	dbt = DbType.Object;

11

}

12	return dbt;

13

}

2.  DbType==>Type :

 

01	static Type ConvertType(DbType dbType)

02

{

03	Type toReturn = typeof(DBNull);

04

05	switch (dbType)

06

{

07	case DbType.UInt64:

08	toReturn = typeof(UInt64);

09

break;

10

11	case DbType.Int64:

12	toReturn = typeof(Int64);

13

break;

14

15	case DbType.Int32:

16	toReturn = typeof(Int32);

17

break;

18

19	case DbType.UInt32:

20	toReturn = typeof(UInt32);

21

break;

22

23	case DbType.Single:

24	toReturn = typeof(float);

25

break;

26

27	case DbType.Date:

28	case DbType.DateTime:

29	case DbType.Time:

30	toReturn = typeof(DateTime);

31

break;

32

33	case DbType.String:

34	case DbType.StringFixedLength:

35	case DbType.AnsiString:

36	case DbType.AnsiStringFixedLength:

37	toReturn = typeof(string);

38

break;

39

40	case DbType.UInt16:

41	toReturn = typeof(UInt16);

42

break;

43

44	case DbType.Int16:

45	toReturn = typeof(Int16);

46

break;

47

48	case DbType.SByte:

49	toReturn = typeof(byte);

50

break;

51

52	case DbType.Object:

53	toReturn = typeof(object);

54

break;

55

56	case DbType.VarNumeric:

57	case DbType.Decimal:

58	toReturn = typeof(decimal);

59

break;

60

61	case DbType.Currency:

62	toReturn = typeof(double);

63

break;

64

65	case DbType.Binary:

66	toReturn = typeof(byte[]);

67

break;

68

69	case DbType.Double:

70	toReturn = typeof(Double);

71

break;

72

73	case DbType.Guid:

74	toReturn = typeof(Guid);

75

break;

76

77	case DbType.Boolean:

78	toReturn = typeof(bool);

79

break;

80

}

81

82	return toReturn;

83

}