private void button1_Click(object sender, EventArgs e) { try { string query = ""; if (richTextBox1.SelectedText != "") { query = richTextBox1.SelectedText; } else { query = richTextBox1.Text; } this.UseWaitCursor = true; DataTable data = _connector.GetDataTableFromReader(query); if (data != null && data.Rows != null) { dataGridView1.DataSource = data; dataGridView1.Refresh(); } this.UseWaitCursor = false; } catch (Exception ex) { this.UseWaitCursor = false; MessageBox.Show(ex.ToString()); } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { try { //DatabaseConnector dbConn = new DatabaseConnector(_connectionString); string query = textBox2.Text.Replace("{TABLE}", listBox1.SelectedItem.ToString()); DataTable data = _connectory.GetDataTableFromReader(query); if (data != null && data.Rows != null && data.Rows.Count > 0) { dataGridView1.DataSource = data; dataGridView1.Refresh(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }