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