private void ResultToTable(SqlCollection result) { if (result.Rows.Count == 0) { return; } foreach (SqlType field in result.Rows[0].Fields) { OutputTable.Add(new OutputColumn(field.Name)); } for (int i = 0; i < result.Count; i++) { SqlObject obj = result.Rows[i]; for (int j = 0; j < obj.Fields.Count; j++) { if (obj.Fields[j].Type == typeof(bool) && obj.Fields[j].Name == "IsBusinessAccount") { OutputTable[j].Add((bool)obj.Fields[j].Value ? "Business" : "Normal"); } else { OutputTable[j].Add(obj.Fields[j].FormatValue()); } } } }