Example #1
0
        private void textSQL_KeyDown(object sender, KeyEventArgs e)
        {
            String sQuery;

            if (e.KeyCode == Keys.F5)
            {
                if (String.IsNullOrEmpty(textSQL.Text))
                {
                    MessageBox.Show("pesquisa incorreta");
                }
                else if (String.IsNullOrEmpty(textSQL.SelectedText))
                {
                    sQuery = textSQL.Text;
                    DAL.Connection conexao = new DAL.Connection();
                    conexao.Conectar();
                    BindingSource bind = new BindingSource();
                    bind.DataSource             = conexao.DataTable(sQuery);
                    gridSQL.AutoGenerateColumns = true;
                    gridSQL.DataSource          = bind.DataSource;
                }
                else
                {
                    sQuery = textSQL.SelectedText;
                    DAL.Connection conexao = new DAL.Connection();
                    conexao.Conectar();
                    BindingSource bind = new BindingSource();
                    bind.DataSource             = conexao.DataTable(sQuery);
                    gridSQL.AutoGenerateColumns = true;
                    gridSQL.DataSource          = bind.DataSource;
                }
            }
        }