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);
}
}
