public string ResultToStringForStatement(string databaseStatement)
{
DatabaseRecordSet recordSet = new DatabaseRecordSet(this.Database);
int ret = recordSet.Execute(databaseStatement);
StringBuilder resultString = new StringBuilder();
if (ret == 0)
{
for (int i = 0; i < recordSet.GetColumnCount(); i++)
{
resultString.Append(i == 0 ? recordSet.GetColumnName(0) : $";{recordSet.GetColumnName(i)}");
}
resultString.AppendLine();
for (int i = 0; i < recordSet.GetRowCount(); i++)
{
DatabaseRow row = recordSet.GetRow(i);
for (int j = 0; j < recordSet.GetColumnCount(); j++)
{
resultString.Append(j == 0 ? row.GetColumn(0) : $";{row.GetColumn(j)}");
}
resultString.AppendLine();
}
}
return(resultString.ToString());
}
