private void OnSelectResults(RuntimeTable<ResultRow> result)
{
StringFormat format = StringFormat.GenericTypographic;
format.FormatFlags |= StringFormatFlags.MeasureTrailingSpaces;
var columns = new List<ColumnHeader>();
var items = new List<ListViewItem>();
columns.Add(new ColumnHeader() { Text = "" });
foreach (var column in result.Columns()) //headers
columns.Add(new ColumnHeader() { Text = column });
for (int x = 0; x < result.RowCount; x++)
{
var rowItem = new ListViewItem((x + 1).ToString());
foreach (var columnValue in result[x])
rowItem.SubItems.Add(columnValue.ToString());
items.Add(rowItem);
}
DoInvoke(new Action(() =>
{
resultsListView.BeginUpdate();
resultsListView.Columns.Clear();
resultsListView.Items.Clear();
resultsTabs.SelectedIndex = 0;
resultsListView.GridLines = true;
resultsListView.Columns.AddRange(columns.ToArray());
resultsListView.Items.AddRange(items.ToArray());
resultsListView.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
resultsListView.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
resultsListView.EndUpdate();
}));
}