public void Preview(string table) { WaitScreen.Splash(); using (ClickHouseCommand comm = con.CreateCommand($"SELECT * FROM {table} LIMIT 5")) { using (var reader = comm.ExecuteReader()) { List <object> result = new List <object>(); do { while (reader.Read()) { for (var i = 0; i < reader.FieldCount; i++) { var val = reader.GetValue(i); result.Add(val); CHBox.AppendText(result[i].ToString() + ", "); } CHBox.AppendText(Environment.NewLine); result.Clear(); } } while (reader.NextResult()); } } }
private void CHTablesComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { string tableName = CHTablesComboBox.SelectedItem.ToString(); CHBox.Clear(); CHConnection(() => Preview(tableName)); }