public static TypeCode GetDataType(String value)
{
switch (value.ToLower())
{
case "string": return TypeCode.String;
case "double": return TypeCode.Double;
case "datetime": return TypeCode.DateTime;
case "date": return TypeCode.DateTime;
case "integer": return TypeCode.Int32;
default: return TypeCode.String;
}
}