private void InitializeDataGrid() { DataTable dataTable = new DataTable(); dataTable = _sqliteManager.ExecuteWithResults("pragma table_info(" + _tableName + ");"); for (int i = 0; i < dataTable.Rows.Count; i++) { this.dataGridView1.Columns.Add( dataTable.Rows[i].ItemArray[1].ToString(), dataTable.Rows[i].ItemArray[1].ToString()); } }
private void AddColumnsToGrid() { DataTable dataTable = new DataTable(); dataTable = _sqliteManager.ExecuteWithResults("pragma table_info(" + this.comboBoxTables.Text + ");"); dataGridViewTables.Rows.Add(); dataGridViewTables.Rows[0].Cells[1].Value = dataTable.Rows[0].ItemArray[1].ToString(); dataGridViewTables.Rows[0].Cells[2].Value = "BINARY"; dataGridViewTables.Rows[0].Cells[3].Value = "ASC"; }
private void RunAction_Click(object sender, EventArgs e) { string sql; if (!String.IsNullOrEmpty(QueryTextBox.SelectedText)) { sql = QueryTextBox.SelectedText; } else { sql = this.QueryTextBox.Text; } if (sql.Contains("select")) { lastSelect = sql; } if (!String.IsNullOrEmpty(sql)) { try { DataTable dt = new DataTable(); this.dataGridView1.DataSource = _sqliteManager.ExecuteWithResults(sql); tabControl1.SelectedIndex = 0; string message = "sql Excecuted successfully"; AppendText(message, Color.Blue); string date = DateTime.Now.ToString(); string rows = dataGridView1.Rows.Count.ToString(); this.HistoryGrid.Rows.Add(); } catch (Exception ex) { AppendText(ex.Message, Color.Red); } } else { string message = "Cannot execute empty query."; AppendText(message, Color.Black); } }