C# (CSharp) SQLQueryStress LoadEngine.ExecuteCommandの例

ExecuteCommand() private method

private ExecuteCommand ( string connectionString, string sql ) : bool
connectionString	string
sql	string
return	bool

コード例 #1

        private void btnFreeCache_Click(object sender, EventArgs e)
        {
            if (!_settings.MainDbConnectionInfo.TestConnection())
            {
                MessageBox.Show(Resources.MustSetValidDbConnInfo);
                return;
            }

            MessageBox.Show(LoadEngine.ExecuteCommand(_settings.MainDbConnectionInfo.ConnectionString, "DBCC FREEPROCCACHE")
                ? "Cache freed"
                : "Errors encountered");
        }

コード例 #2

        private void btnCleanBuffer_Click(object sender, EventArgs e)
        {
            if (!_settings.MainDbConnectionInfo.TestConnection())
            {
                MessageBox.Show(Resources.MustSetValidDbConnInfo);
                return;
            }

            MessageBox.Show(LoadEngine.ExecuteCommand(_settings.MainDbConnectionInfo.ConnectionString, "DBCC DROPCLEANBUFFERS")
                ? "Buffers cleared"
                : "Errors encountered");
        }

コード例 #3

ファイル: Form1.cs プロジェクト: vdrav/SqlQueryStress

 private void btnFreeCache_Click(object sender, EventArgs e)
 {
     MessageBox.Show(LoadEngine.ExecuteCommand(_settings.MainDbConnectionInfo.ConnectionString, "DBCC FREEPROCCACHE")
         ? "Cache freed"
         : "Errors encountered");
 }

コード例 #4

ファイル: Form1.cs プロジェクト: vdrav/SqlQueryStress

 private void btnCleanBuffer_Click(object sender, EventArgs e)
 {
     MessageBox.Show(LoadEngine.ExecuteCommand(_settings.MainDbConnectionInfo.ConnectionString, "DBCC DROPCLEANBUFFERS")
         ? "Buffers cleared"
         : "Errors encountered");
 }