public SqlAnywhereTable ReadCommand(OdbcCommand cmd) { var table = new SqlAnywhereTable(); using (var reader = cmd.ExecuteReader()) { for (int ordinal = 0; ordinal < reader.FieldCount; ordinal++) { table.Columns.Add(reader.GetName(ordinal)); } while (reader.Read()) { var row = new string[reader.FieldCount]; for (var i = 0; i < reader.FieldCount; i++) { row[i] = reader[i].ToString(); } table.Rows.Add(row); } } return table; }
private void ShowResults(SqlAnywhereTable table) { ResultsDataGrid.Columns.Clear(); ResultsDataGrid.ItemsSource = null; ResultsDataGrid.Items.Refresh(); for (int i = 0; i < table.Columns.Count; i++) { var col = new DataGridTextColumn { Header = table.Columns.ElementAt(i), Binding = new Binding("[" + i + "]") }; ResultsDataGrid.Columns.Add(col); } ResultsDataGrid.ItemsSource = table.Rows; ResultsDataGrid.Items.Refresh(); }