DataType (System.Type t)转 DbType

       private DbType GetDBType(System.Type theType)
        {
            IDbDataParameter iDbDataParameter = GetIDbDataParameter();
            System.ComponentModel.TypeConverter tc = System.ComponentModel.TypeDescriptor.GetConverter(iDbDataParameter.DbType);
             if (tc.CanConvertFrom(theType))
            {
                 iDbDataParameter.DbType = (DbType)tc.ConvertFrom(theType.Name);
            }            
            else

            {

 

                    try
                    {
                        iDbDataParameter.DbType = (DbType)tc.ConvertFrom(theType.Name);
                    }
                    catch (Exception) { }

            }

            return iDbDataParameter.DbType;
        }