Esempio n. 1
0
        private void FormToFields(SqlQueryOptionsForm f)
        {
            this.TextSize = (int)(f.txtTextSize.Value);

            this.NoCount   = f.chkNoCount.Checked;
            this.NoExec    = f.chkNoExec.Checked;
            this.ParseOnly = f.chkParseOnly.Checked;
            this.Concat_Null_Yields_Null = f.chkConcatNullYieldsNull.Checked;
            this.ArithAbort     = f.chkArithAbort.Checked;
            this.ShowPlanText   = f.chkShowPlanText.Checked;
            this.StatisticsTime = f.chkStatisticsTime.Checked;
            this.StatisticsIo   = f.chkStatisticsIo.Checked;

            this.Transaction_Isolation_Level = f.cboTransactionIsolation.Text;
            this.Deadlock_Priority           = f.cboDeadlockPriority.Text;
            this.Lock_Timeout = (int)f.txtLockTimeout.Value;
            this.Query_Governor_Cost_Limit = (int)f.txtQueryGovernorCostLimit.Value;

            this.Quoted_Identifier      = f.chkQuotedIdentifier.Checked;
            this.Ansi_Null_Dflt_On      = f.chkAnsiNullDflt.Checked;
            this.Implicit_Transactions  = f.chkImplicitTransactions.Checked;
            this.Cursor_Close_On_Commit = f.chkCursorCloseOnCommit.Checked;
            this.Ansi_Padding           = f.chkAnsiPadding.Checked;
            this.Ansi_Warnings          = f.chkAnsiWarnings.Checked;
            this.Ansi_Nulls             = f.chkAnsiNulls.Checked;
        }
Esempio n. 2
0
        private void FieldsToForm(SqlQueryOptionsForm f)
        {
            f.txtTextSize.Value = this.TextSize;

            f.chkNoCount.Checked              = this.NoCount;
            f.chkNoExec.Checked               = this.NoExec;
            f.chkParseOnly.Checked            = this.ParseOnly;
            f.chkConcatNullYieldsNull.Checked = this.Concat_Null_Yields_Null;
            f.chkArithAbort.Checked           = this.ArithAbort;
            f.chkShowPlanText.Checked         = this.ShowPlanText;
            f.chkStatisticsTime.Checked       = this.StatisticsTime;
            f.chkStatisticsIo.Checked         = this.StatisticsIo;

            f.cboTransactionIsolation.Text    = this.Transaction_Isolation_Level;
            f.cboDeadlockPriority.Text        = this.Deadlock_Priority;
            f.txtLockTimeout.Value            = this.Lock_Timeout;
            f.txtQueryGovernorCostLimit.Value = this.Query_Governor_Cost_Limit;

            f.chkQuotedIdentifier.Checked     = this.Quoted_Identifier;
            f.chkAnsiNullDflt.Checked         = this.Ansi_Null_Dflt_On;
            f.chkImplicitTransactions.Checked = this.Implicit_Transactions;
            f.chkCursorCloseOnCommit.Checked  = this.Cursor_Close_On_Commit;
            f.chkAnsiPadding.Checked          = this.Ansi_Padding;
            f.chkAnsiWarnings.Checked         = this.Ansi_Warnings;
            f.chkAnsiNulls.Checked            = this.Ansi_Nulls;
        }
Esempio n. 3
0
        public override DialogResult ShowForm()
        {
            SqlQueryOptionsForm f = new SqlQueryOptionsForm();

            FieldsToForm(f);

            DialogResult res = ShowForm(f);

            if (res == DialogResult.OK)
            {
                FormToFields(f);
            }
            return(res);
        }