/// <summary> /// 输出[Table]所有内容 /// </summary> private void ShowTotalTable() { dataGridView1.DataSource = null; var queryResult = database.ExecuteQuery("select * from " + TableName); dataGridView1.DataSource = queryResult; this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells); this.dataGridView1.RowHeadersWidth = GetRowHeaderWidth(queryResult.Rows.Count); }
private void QueryAndCalculate() { try { sqlite.ExecuteUpdate(DeleteTempVarsSQL()); } catch (Exception) { } sqlite.ExecuteUpdate(CreateSqlFunctionSQL()); resultTable = sqlite.ExecuteQuery(CountSumDateTimeOfEachMonthSQL()); }
private void FillTextBox() { DataTable analyseData = database.ExecuteQuery(AverageDurationSQL()); foreach (DataRow row in analyseData.Rows) { textBox1.Text = "数据库平均登录时间为: "; try { textBox1.Text += row[0].ToString(); if (float.Parse(row[0].ToString()) > 5) { CreateTipButton(float.Parse(row[0].ToString())); } } catch (FormatException) { textBox1.Text += "0"; } textBox1.Text += "s"; } }