ExecuteCommand() 개인적인 메소드

private ExecuteCommand ( string connectionString, string sql ) : bool
connectionString string
sql string
리턴 bool
예제 #1
0
        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
0
        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
0
 private void btnFreeCache_Click(object sender, EventArgs e)
 {
     MessageBox.Show(LoadEngine.ExecuteCommand(_settings.MainDbConnectionInfo.ConnectionString, "DBCC FREEPROCCACHE")
         ? "Cache freed"
         : "Errors encountered");
 }
예제 #4
0
 private void btnCleanBuffer_Click(object sender, EventArgs e)
 {
     MessageBox.Show(LoadEngine.ExecuteCommand(_settings.MainDbConnectionInfo.ConnectionString, "DBCC DROPCLEANBUFFERS")
         ? "Buffers cleared"
         : "Errors encountered");
 }