private TypeCode ConvertStringToSystemType(string dataType) { foreach(TypeCode tc in Enum.GetValues(typeof(TypeCode))) { if (tc.ToString().Equals(dataType)) return tc; } return TypeCode.String; }