Ever needed to convert a System.Type to its corresponding System.Data.SqlDbTye? Here is a nice little utility function that helps you convert a System.Type to it’s corresponding System.Data.SqlDbType.

  1: private SqlDbType GetDBType(System.Type theType)
  2: {
  3:    SqlParameter param;
  4:    System.ComponentModel.TypeConverter tc;
  5:    param = new SqlParameter();
  6:    tc = System.ComponentModel.TypeDescriptor.GetConverter(param.DbType);
  7:    if (tc.CanConvertFrom(theType))
  8:    {
  9:        param.DbType = (DbType)tc.ConvertFrom(theType.Name);
 10:    }
 11:    else
 12:    {
 13:        // try to forcefully convert
 14:        try
 15:        {
 16:            param.DbType = (DbType)tc.ConvertFrom(theType.Name);
 17:        }
 18:        catch(Exception e)
 19:        {
 20:            // ignore the exception
 21:        }
 22:    }
 23:    return param.SqlDbType;
 24: }