コード例 #1
0
        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());
                }
            }
        }
コード例 #2
0
        private void CHTablesComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            string tableName = CHTablesComboBox.SelectedItem.ToString();

            CHBox.Clear();
            CHConnection(() => Preview(tableName));
        }