private static Type GetColumnType(DBHelper dbh, SqlCommand cmd, string tableName, string columnName) { cmd.CommandText = string.Format(CultureInfo.InvariantCulture, "SELECT [{0}] FROM [{1}]", columnName, tableName); DataTable dt = dbh.RunCmdDataTable(cmd); return dt.Columns[columnName].DataType; }