示例#1
0
        private void button3_Click(object sender, EventArgs e)
        {
            string _procedure = "";

            _procedure  = "CREATE PROCEDURE " + tb_nome_procedure.Text + "(" + tb_parametros.Text + ")\n";
            _procedure += "BEGIN\n";
            _procedure += rtb_corpo_procedure.Text + "\n";
            _procedure += "END;";

            TriggersProcedures trg_proc = new TriggersProcedures();

            trg_proc._tiggersProceduresCMD = _procedure;

            trg_proc.Show();
            this.Close();
        }
        private void button3_Click(object sender, EventArgs e)
        {
            string _trigger = "";

            _trigger  = "CREATE TRIGGER " + tb_nome_trigger.Text + " " + cb_quando_ativa.Text + " " + cb_condicao.Text + " " + tb_on.Text + " " + tb_parametros.Text + "\n";
            _trigger += "FOR EACH ROW\n";
            _trigger += "BEGIN\n";
            _trigger += rtb_corpo_trigger.Text + "\n";
            _trigger += "END;\n";

            TriggersProcedures trg_proc = new TriggersProcedures();

            trg_proc._tiggersProceduresCMD = _trigger;

            trg_proc.Show();
            this.Close();
        }